SP4 doesn't seem to require a reboot or manual restart of services. (Recently installed on test server). However, I'll probably be doing reboots on the production boxes - just in...

I would like to nominate myself as an Acceptable DBA of 2011. Is there a category for that ?

You could rename the table to something more useful.

And next time you import from Excel, you get an opportunity in the wizard to give the table a proper name.

This site & tools are well regarded:

http://ola.hallengren.com/

Is every single record wrong ?

If not, how will you identify which ones need fixing ?

I also like to keep a distinction between system stored procedures and non-system stored procedures. I have a few utility stored procedures that are in the master database, and I...

I think that whatever account is running SQL Services would also need permissions to the folder .... It's been a while since I've set up replication though.

Do a test with a smaller amount of data to see what happens

If you use snapshot replication, then I don't think identity columns matter becuase all the data at the subscriber gets dropped & repopulated.

Yes, the folder contains actual data during replication.

You could set up a server side trace to log the information you want.

I was getting strange results with filters, and found it more reliable to export the trace file to a SQL table, then run selects with WHERE

Edited to remove wrong answer.

I use this for character string searches. It will bring back 1 row for each sp. Then open the SP to search for all the uses. You can easily tweak...

Have you...

Shrinking causes fragmentation and uses resources, then it...