A useful addition might be the option to display the service account.

Rudy, I've got a script that returns the SQLService and SQLAgent accounts for an instance, but it would be...

Useful utility, thanks Rudy:-)

Thanks guys, some food for thought there.:-)

Looks like what appeared as a simple 'copy' operation on the vendor's manual is likely to end up as a complicated set of tasks...

Grant Fritchey (10/5/2010)

---

I wouldn't try it that. Instead, script out the 2008 database to a script or set of scripts. Then you can run those on the 2005 instance, fixing...

My understanding is that rebuilding all indexes will also update their statistics with full scan - so sp_updatestats will just replace the statistics with sampled ones.

Also the SQL service account has to be sysadmin 😉

Useful utility, thanks:-)

Hawkeye_DBA (6/24/2010)

---

I have a DBA database that I record database sizes in every week and keep for 365 days. I can then look at the statistics from that data and...

Furthermore, if you are still stuck this is the code I use on some of my critical instances.

This code also sets the event as 'logable' so you'll also get an...

However you could create a DDL trigger at instance level to stop people from dropping dbs ad-hoc (a wise practice perhaps for live servers)

Useful compilation, thanks!

Very good indeed:cool:

The level is 400 all right. Not for newbies.

A true sceptic - he dispells myths in a convincing way.

(eg: Spreading tempdb in multiple files - a sure...

Do you have Full-Text indexing jobs running?

They can take a lot of CPU cycles and SQL won't see it because it has been delegated to Windows.

The SQL job appears to...