What are you trying to accomplish here? Wouldn't a log table and the OUTPUT clause help you with the statements? Or a trigger?

If you're a consultant and you need this, spend the $$. It's an investment in your time and it pays off. No one I know that has bought either Red...

Derek,

Here's hoping things go well in 2009! And you enjoyed the time off.

I wonder if it's just one folder or if SQL will manage to create subfolders to balance the load. It is really designed to integrate and work well with large...

DBA Morning Checklist -http://www.sqlservercentral.com/articles/Database+Administration/62480/

Disk / array failure

Loss of Windows host

Loss of physical server

Network down, move to new location/network

User deletion of data

haven't seen this, perhaps there's a configuration setting in SQL Agent to log shell access? Or xp_cmdshell access? Or there's there's an issue running it that's tripping windows auditing?

Do you mean instance name?

@@servername

There is a DTS runtime that you can use to run packages.

Thanks, better late than never, and glad you didn't have to get back to work or this site until today!

Happy New Year!

What is happening? Or what isn't happening? You haven't provided much information. Is SSMS running? Can you connect to the instance?

These are great comments on commenting code (recursive comment there?), and I don't avoid documentation, but I don't think it has to be incredibly detailed. Part of my reasoning is...

I don't think I'm selling things short. DBAs do a lot of tuning and moving data around. It depends on your job and things I've done heavily in one job,...

Good job, James. A nice explanation that I'll have to remember to run-run periodically.

I thought I heard last year that there's no great benefit to multiple log files, except space...

I'm not sure here. The certificate is stored in the database, and with a password, I don't think it has anything to do with the DMK. So anything not encrypted,...