Sorry, I do not know about that one.

Yes !

 Yes, there certainly is a security patch that needs to be applied to all SQL S Sp3 installations. Its MS03-031 Security patch. It is version 8.00.819. It plugs several security...

Yes you can. You really should be a SP3a already though.. has lots of fixes and lots of security patches... There is another release above SP3a that fixes even more...

This is about it. Make sure you stop all unneccessary services on your server also. SP3 is more fussy about this... IIS, Antivirus, Compaq/Dell svc, SMTP WW Web.....

The first time...

I have done this a few times but just a little differently. Using a spare server (usually a generation newer), install newest version of operating system and sp then install...

 I have used it a few times and seems to work fine.

From my own personal experience we here are wanting to consolidate SQL Servers also. The way I am approaching it is taking each applications into account. We do not buy...

OK, do you remember the link to the place on Microsofts Web site that shows that type of information ?

If you are referring to SQL Server 6 then you have to upgrade to SQL Server 6.5 to be able to upgrade to SQL Server 2000.

Take this with a grain of salt but I thought I saw on the Microsoft website that SQL Server 7 support will end 12/05. You should really be working on...

Not to trash MOM but we monitor all of about 200+ servers, and the repository server is bogged down with the influx of data and our db was 29 gig....

We have MOM here. THe backend database server that collects the data from all of the windows servers is very busy but we have about 200 servers though. I utilize...

Oh, I never thought of that.... and SQL Server upgrades too... wow, that is big.....  

Thanks !

So did you write scripts to backup all your SQL Server dbs and transaction logs the?  How do you have it automatically delete old ones after x days...???