Hmmm. That is not a bad idea. I'm not sure how much space we'll be able to get, though.

I have no idea how often, nor by how...

The Master database is set to Full for the...

We're working on doing a code camp here in the new few months. Once that's done I think I'd like to do a SQL Saturday. Most of the...

Good article, Tim. I appreciate the reminder. I think it is true, in most cases, that calling someone out privately is best. I know that I prefer...

Thank you, Steve, for this information.

OK, I may have something. I've looked up the DTSER_FAILURE error and came across this article on Microsoft Support (http://support.microsoft.com/kb/938910). I see that this database server is using...

Steve Jones - Editor (2/19/2010)

---

Go to a job step, properties, advanced. There are places to log, including a table. you can specify a file or a table.

If this is a...

GilaMonster (2/19/2010)

---

Not enough info. The messages are always truncated in the history log. Go into the job, set up a file to log output to and check what's in that...

GilaMonster (2/19/2010)

---

Not enough info. The messages are always truncated in the history log. Go into the job, set up a file to log output to and check what's in that...

I think I will change it to use the sa account. However, I'll wait until I get a good backup of the system databases first.

I'm one of the few at work today.

kevriley (12/11/2009)

---

No it's not because you ran it in the master db - it will report activity across all databases.

It could be that nothing was actually running at that point....

I've just read this article, copied the code and created the SP in my master database. Using the code I created the SP dba_WhatSQLIsExecuting, and ran it. However,...

Thank you very much, Steve, for such kind words. SQL Server Central is, for me, the source I go to for help with SQL Server. I appreciate it...