Yes this is normal with connection pooling.

Why would that take that long? 1000 mb is not very much anymore.

How did the admin get in to kill spids if he could not run queries? If he used the DAC I believe there are only a few types of...

Well seeing as this is a SQL 2005 forum sure you could.... Login triggers, detect which application and user is loging in, then roll back the login attempt when you...

The only time until now I have ever been sent to SQL training was to become a SQL help desk person at MS, and to get my SQL 7 certification...

I use VSS and the ApexSQL Edit editor so I can double click on the objects in VSS to check them out and open them.

My recent posts!

For my mom's 60th birthday I managed to get to the big sit down dinner party without anyone knowing about it.  Arranged to have a friend of mine get invited...

Maybe use a combo where isdate = 1 and isnumeric = 0 ?

Yes it can be done.  Don't have time to really explain, but the stored procedure below is dynamic both in X and Y axis.  Sample of the result set at...

Hope you all have fun out there.

Where is the event going to be next year?  Need to start working on my boss to get it into the budget for next...

Restores when the files are not already there can take a long time as the files need to be initizalized first, if on Windows 2000.  On 2003 (and XP) you...

declare

@SQLV char(1)

select

@sqlv = convert(char(

Brandie's suggestion works for me.  Converts that string to a smalldatetime just fine.

declare

@ch varchar(20), @dt smalldatetime

set

5 columns of what?  And why approximate?  I have inserts that has 5 columns that take 30 bytes, I have some that take 400K.