My only comment, and concern is the clean up of the history on msdb. I would prefer to keep 8 weeks of data in the history, as that can...

Jobs are a pain and even with my super admin AD account sometimes the jobs failed, sometimes they didn't. Depended on if I was still logged onto the system.

Solution...

You can change the Page_verify_option to Checksum on compatibility 80 without going to 90

SELECT name, create_date, compatibility_level,user_access_desc,state_desc, recovery_model_desc,page_verify_option_desc FROM sys.databases

This is just a quick way to gather that info for...

Having converted many databases from SQL2000 via backup and restore and running on SQL2005, changing compatablility is relatively low on my scale of things that need to be changed. ...

Are you just trying to script out the table names and schema or include the data also?

Copy the databases to a test instance and do not do this on...

Thanks, I totally agree with all of you on this.

My current solution to see if this will appease him is to create a proc. I will see if that...

I have an Associates in Photography and BS in Computer Sciences. Wanted to be photographer, developed severe allergies to the chemicals. Started working, to pay bills and went back to...

Yep this is my nightmare. I am only doing it because the CIO has mandateded it.

The trace would be good, but of course the powers that be want an answer now. I will set this up for future usage and tracking. Thanks!

Avoid Hotfixes unless they are truly needed to fix a known problem on your system. Microsoft warns the not to install unless needed. Testing on a test system would be...

I have all developers install all service packs to any version of sql even if it is only desktop tools. It will apply only what is needed. This goes for...

Oh Boy. PCI. Ok to meet PCI compliance, or at least get started on it see if management will agree to separate dev and test systems or a dev/test system....

I think that your hardware configurations for your disk drives are insufficent for what you are planning. 2 146gb drives in Raid 1 gives you only 146gb for working with....

You may also want to look at default location of where SQL does it's log dumps. That can take space from your c drive also.

On the server

Open SQL Server...

I had problems with Microsoft cleaning up report .txt files on our systems that were generated by SQL backup routines. The backups are with the maint plans and can be...