You check the SQL Agent log?

Not that I know of.

I prefer 2.

The reasoning to me is that this solves your issue, but gives you flexibility for the future. It's easy to say in business, one doc per customer, but...

Profiler will tell you who accesss things. Lumigent, Idera, and a few more have products that can help automate this auditing. I'm not sure how you'll be able to tell...

You should also be able to register by name.

Very true and I hope I didn't miswrite something. I thought I read in one of the many news items that there was a contract, but I could be wrong.

I'd like a farm. I have an old Cisco CSS load balancer, just never got the hardware to implement it. Everytime we've bought a new box, we've repurposed the other...

Good to know

Actually this was sent in by someone and I couldn't remember when the other one was created. Thanks for the note,...

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart1.asp

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart2formatting.asp

A separate db is overkill unless you have an already loaded machine, then you'd want a separate server as well, or you anticipate a high volume of reports that might...

It would be interesting to have some testing done. 12 hour is interesting, what about putting tempdb on it? Lots of order bys, group bys, etc, might benefit from it.

You should be able to just copy both files to a location on the new server and attach from EM.

There isn't a good way that I know of. You could script out the logins and permissions from EM, then do a search and replace. Not sure if there's a...

does sa work?

Why not remove them manually? I'm sure the server doesn't remove them in case they are user dbs that you need. People sometimes detach their dbs, uninstall, reinstall to a...