Another TRN is going to fire up in 10 minutes..

and also

going to keep an eye on it for another 24 hours and see what happens

see the attached

let me know if you have any question(s)..

thx guys

Full of course as I have mentioned before. .

runs every 2 hours from 5 am to 5 pm (7 times)

weekdays

no not at the same time nor pattern

If I go ahead, right now, and run the full backup and then the transactional one then it is fine.. until the next day..

same, if I run the full...

Makes total sense

That's perfectly fine if you do not have an answer.

would pivot be able to do the following?

_JobNum_JobName _DivName _PMNames_HrsUsed_DollUsed_JobCost

12680Mission BeachKing County Johnnie ...

Jonathan,

You are right, will not occur again. I can see how that happened to me. First of all I should have run the USP and check.. secondly, I...

Jonathan,

OMG, how embarrassing this is for me.. hehe 😉

it is working great..

thx again

Jonathan,

Wasn't able to find your email link on the blog.. but here is the code..

as you notice that I have commented out most majority of the elements to...

I used your TEST DB creation method, generated 3 statements in the queue.. viewed the content of the queue table did not look any strange or anything like that.. also...

so much for my findings 😉 this tells me that my audit argument in the paragraph may be correct.

http://msdn.microsoft.com/en-us/library/ms182454%28v=sql.90%29.aspx

alright, the search of other possible areas continues.....

FYI

I wonder if my AUDIT_DATABASE_MANAGEMENT_EVENT statement in the paragraph in below does not exist or typed incorrectly..

so, I am going to search on internet / msdn and see what...

Jonathan Kehayias (11/10/2012)

---

John Esraelo-498130 (11/10/2012)

---

Hi Jonathan,

Before I ask a question I wanted to say that I really like your articles, especially in the events area.

Here is the question:

I have create...