This technology is great there is no doubt. The quality of the games and the units that run them are worlds above what was available when I grew up playing...

I do not think that is recorded anywhere in SQL Server.

I tend to agree. Two to three years is almost too quick for major release upgrades. I understand they need to keep up with the competition but us poor soles...

Years ago we did not purchase SA for our SQL Servers. Good thing since they slipped on the 2000 to 2005 versions. Microsoft was on-site talking to us about 2005...

I think in the Maint plan wizard there is an option to do this without coding it all manually.

I recently had this issue. Not restoring it to a standby server though. A vendor of ours backed up a db, sent it to us and when I attempted to...

I have simply changed ours to audit only failed logins attempts. Why on earth would you want to see every single good login ?  No wonder your logs are so...

  I to have found that user grants are terrible. Personally I do NOT like the Mgt studio from a DBA prospective at all. Ent. Manager flowed very well... oh...

SQL Server:  We have 21 Production SQL2000, and still one is SQL 7.. don't ask !  Two are active passive clusters that serve our 1,500 stores... soon we will be...

Sorry, I just found it via Books Online... Expand DB, tasks, shrink.....

You are correct. I was connected via Mgt. Studio to a SQL 2000 install and was looking at a 2000 db. Once I connected to my SQL 2005 I could...

Databases are not backward compatible even with the compatibility set to 2000. If you really have a need to do this you will have to script out the DDL and...

We have 19 production SQL Servers here running SQL 2000. I have 2005 on a DEV server and have played with it enough to become familiar with it. I have...

I had this exact problem and opened a case with MSFT.. Here is what they had me do... fixed it.

To resolve the problem, perform the following steps:

1....

This is a little bit of a start... I run this script and save it off somewhere. Someone that is unfamiliar with the install can look at this and determine...