As for the reason why it runs quicker the second time through it's because the execution plan has been cached.

Jumping on the bandwagon here: only the second statement returned the correct value for my birthdate. Gimme my point! ARGH!

😛

Oh how I wish I worked in a perfect world! If so, I'd have my logs on a dedicated RAID 1, my tempdb on another and my data on...

I suggest removing rights to any databases that this login may have first prior to deleting the login. As suggested this can all be done in SSMS. Right-click...

Like Lowry, in our environment (both SQL 2000 and 2005) I am responsible as the DBA to make sure all databases are being backed up correctly and am responsible for...

What do you consider "abnormal"? What is your tempdb spec'd at currently? Are we discussing SQL 2000 or 2005? Optimizing tempdb in 2005 is quite different than...

No matter what you specify for the location of program files and for data files, SQL will still place files in C:\Program Files\Microsoft SQL Server\80 (or 90 if this is...

Detach/Attach v. Backup/Restore is really a matter of personal preference. So long as you copy/paste the data/log files in the Detach/Attach instead cut/paste you can recover by re-attaching the...

I completely forgot about that! The other contributing authors are no slouches either.

Henry, I believe your FTP commands would be in the .txt file referenced here in the script:

[font="System"]-- FTP for the file list

SELECT @sql = 'FTP -n -v -s:C:\FTPCmdFile.txt' [/font]

Definitely agree Brandie, just wanted to explain for any lurkers out there so that they just don't go around giving out dbo under the belief that they need to in...

Brandie, I took this as the individual has SSMS and should be able to "see" only a specific database(s) in the Databases node of the Object Explorer and not "see"...

Once you revoke the View Any Database, if you then execute sp_changedbowner for database X for a given login that login should see that database, as well as master and...

I really would not disable the default trace if I were you. Think of it as SQL's "black box". The load it places on the server should be...

The documentation should tell you what the initial size will be; very small initially. The size of the database really depends upon how many servers you plan on monitoring,...