"Always be wary of using 2005 tools against earlier versions of sql server."

Can you please amplify that remark?. I always thought that backward compatibility (except for deprecated keywords, sql constructs and stuff...

Great!

Everything you said checks out.  The more of these types of "problems" I encounter the more I think Microsoft must have been rushed to get this product out th door.

TIA,

Bill

P.S. Here's...

Jamie,

I haven't had time to thoroughly read your blog but it looks real good!

Thanks,

Bill

Unfortunately I didn't try that (good idea).

Bill

Sushila,

Thanks. I liked that article.

By extension I guess the author would also qualify all stored proc and view name references.

Bill

I use the defragger that comes with Windows 2003 (and stop SQL). Can you recommend any other production-quality defrag tools from third parties?

TIA,

Bill

Thanks, Chris. That's exactly what I was thinking. Until the need is apparent I'm using the dbo schema only.

TIA,

Bill

Excellent answer...but another question.

I was told that in the 64-bit environment the OS will still claim half of the available RAM (i.e. 4GB) leaving sql 2005 a max of 4GB...

>> You really don't want to enable SQL authentication anyway or

Correct, but on some of our sql 2000 servers we have users accessing the same database via Sql authenticaiton and...

>> Default installation is windows only authentication

I tried to change it to suuport both Windows and Sql. I found that I could have one or the other, per sever, but...

I spoke with Symantec about LiveState 6.0. These said they use VSS to copy databases BUT for best results I should STOP/start the sql server engine before/after the image process. (That rules...

I found more info.....

Latest release is: MDAC 2.8 SP2 (2.82.1830.0) for Windows 2003 SP1

MDAC 2.8 SP1 ( (2.81.1117.6) on Windows XP SP2

Bill

David,

Great response but I need a point clairifed.

>>we find that on certain servers the agent just dies.. >>

Are you referring to the sql server agent?

Also,

>>>if you find that some of...

Thanks to all. VBCity. com look good and so does the MS newsgroups. I found a browser-based way to access the MS Newsgroups:

http://msdn.microsoft.com/newsgroups/managed/

Thanks for the help. I have never used sp_MSforeachdb before. As a learning experience I tried this statement

EXEC sp_MSforeachdb "USE ? IF db_name() NOT IN ('master', 'tempdb', 'model', 'msdb')  print '?',...