Robert Hermsen (10/27/2008)

---

I would suggest taking it another step. It may require some dreaded overtime to get in place but is well worth it. We are dba's not...

John Rowan (6/12/2008)

---

Just wanted to say thanks for sharing. The article was well thought out and well written. The level of detail in your object descriptions was great....

Jack Corbett (6/11/2008)

---

don_goodman (6/11/2008)

---

Why? You have C2 security enablement that does all the work for you to generate traces of everything. You have :fn_trace_gettable to read the traces so you...

here is a link i just created on my MSN Live Space. I tested it and it downloaded the file just fine.

Sql File

lemme know if this doesnt work.

im not sure why the code isnt out...

magarity kerns (6/11/2008)

---

Because the DBA knows that independent auditors will eventually catch up with him/her. Maybe not...

magarity kerns (6/11/2008)

---

What a great system! What are the requirements for the monitoring server and how many does yours monitor? Can it be done on the cheap with...

In this articles case, i am the DBA, and of course i can be trusted...

Its a good point...

Kenneth Wymore (3/27/2008)

---

Are the e-mail addresses in the script live? Or are they dummy addresses that you are just using as an example? I would hate to have those addresses...

that is the next step. its difficult to gather specific info fom the job steps, cause they dont key into the job, just seems they are ordered by time,...

I agree that writing it yourself vs buying software is a compelling argument, and people are on both sides of the camp. In my case, the buy it option...

I like the idea. I have various white papers on my desktop. When i read one, i am immediately doubting, because it could be more marketing than technical....

perfect.  thanks for the quick response.  i learned something today.

did you get ananswer for this issue?

I am a DBA.  I sit at a desk, and connect to my database thru a variety of tools.  All remotely.

I don't physically go into the server room.  So, technically,...