Wayne/Phil,

Those are good examples, but how often do you write them? It seems that you "rarely" solve these issues, get the queries, and often do other things.

LutzM (9/28/2010)

---

If you're a customer/client: How often did you have a chance to talk to the dev team directly to clarify your requirements (or what you think the requirements of...

Typically service restarts are permission related. As mentioned, check the SQL Server error log, or the Windows event log for some type of error message that can help you...

If you can send .RAR files to gmail, then you can send the files. If the client doesn't get them, perhaps their mail system is blocking a .rar file. That...

Under the Management folder in SSMS, there is an error log folder. Look at the prior error log (errorlog.1) to determine when the shutdown was issued.

I guess it's possible. My guess is something just flaked with this particular audit specification and maybe messing with it (enable/disable, drop, alter, etc.) might have "fixed" it.

It's possible...

If you drop and add this back, does it work?

This should be very simple, and I've yet to run into a place where it doesn't just record stuff in testing....

Mauve (9/27/2010)

---

Having worked with Oracle for 25+ years, I'm continually frustrated with the lack of "core" functionality that Microsoft is so slow to implement. This is just another one...

I am not sure I've had many projects at all in my lifetime that were on budget/on time unless they were trivial (< 1 week). It seems anything over that...

Test post for code. This is Wayne's code

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,...

Strange. In a test database, I get this from your script:

Msg 105, Level 15, State 1, Line 4

Unclosed quotation mark after the character string '***\*****)

WITH (STATE = ON)

GO

'.

Msg 102, Level...

SequelSurfer (9/28/2010)

---

Hey there's nothing wrong with beating a Brit, I've been following...

Does the service account have rights to c:\audit? Any errors in the log?

I'll try to dup this and see if I can see anything wrong with the scripts.

Did you enable the server audit? I believe this is disabled by default and you need to specifically enable your audit

This might help: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31603/