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...

Charles Kincaid (11/13/2009)

---

Jeff Moden (11/12/2009)

---

Heh... I have an odd personal preference... I don't like languages that require semi-colons or line continuation characters. It seems that they should all be...

Thank you, Bru and Elliot.

Having started out with FORTRAN, then C (I dabbled a little in C++), next VB (4, 5 and 6) and finally VB.NET and C#, I have to say that I...

Steve Jones - Editor (10/20/2009)

---

Yes, it has SSRS.

The thing you want to be careful of with going 2008 is that some things you might work on, or try, will not...

Thank you for that info, Ed.

Would it be a good idea to go to the developer edition of SQL 2008 instead? (I would think it likely that SQL 2008 could read/process any .mdf and...

I guess I'll join it, but man, I get tired of having to create yet another username/password/identity on the web. I just wish I could take my identity from...