Programming SQL

sql server conflicts between versions?
Hi, I am using firebird 2.0 database for my application. It runs at our client site very well. But one day it did not work. Finally we found the client installed some other application, that used lower version of firebird. Now we are planning rewrite our application in .net and use sql server express as dat... 15 Jul 2010 13:13

Is there any way to audit login/logout for specific users ?
Hi Friends, SQL 2008 I creates a server level audit to track SUCCESSFUL_LOGIN_GROUP, but the log files grows crazy and I'm only interested in auditing for specific users and not everyone accessing server. Is there any way to audit login/logout for specific users ? Thanks in advance, Pat ... 14 Jul 2010 19:51

2005 to 2000
Is it possible to convert a sql2005 features to sql2000? Because the ISP server there's no way to install the 2k5 server. Or do you have a statment that can generate a table filled only with the workdays of a year on ms sql 2000. THank you very much ----------------------------------------------------------------... 14 Jul 2010 18:45

Using sp in SSRS
I have a stored procedure that is used in both our asp.net web pages and also as a dataset for an SSRS report. The asp.net page works fine but the SSRS report gives an error about "connecting to DataSource1". Do I need to grant permissions on the sp for the SSRS to use it? The web system is impersonating so ... 14 Jul 2010 12:06

Stress testing
Are there any utilities or scripts that will exercise SQL? I know that SQLIO will simulated SQL IO, but I am looking for something that will do a stress test of SQL on a real database. Thanks. ... 15 Jul 2010 04:29

GROUP BY with join help please!
Hello everyone, I have a vexing problem that I am trying to solve without resorting to something ugly like a cursor or a temp table.... (DDL and sample data below) I have a table, Trees. Each tree has a TreeID (unique PK), a Species, a Quality, and a related Sector. Each Sector in the Sectors table has an Area... 16 Jul 2010 08:49

Change short keyboard
Hello there I created new procedure instead of sp_help can i change the behavior of Alt+F1 so it can call to my procedure and not for sp_help? ... 14 Jul 2010 06:36

creating my sp_help
Hello there the original sp_help and sp_helptext works directly only on objects without schema. after i add schema i have to set sp_help 'scm.obj' I took the original code of sp_help, change it so it will be in use for schema objects and tried to compile it. It gave me an error because it not found TypePro... 15 Jul 2010 04:29

UPDATE within an INSERT Statement
(Firstly, no critisms of the design - its not mine and its what I have to work with) I have the following: - CREATE TABLE [dbo].[Counter]( [LastIndex] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Values]( [Value] [VarChar] (5) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[IndexedValues]( [I... 14 Jul 2010 10:59

NORMDIST in T/SQL
Here is a pretty close version I wrote in T/SQL: create function normdist(@value float, @mean float, @sigma float, @cummulative bit) returns numeric(12,2) begin declare @x float declare @z float declare @t float declare @ans float d... 13 Jul 2010 18:39