Great question. An area for me to learn more about.

For your ready made audit, try this:

http://jasonbrimhall.info/2010/03/19/security-audit/

Lowell (11/30/2011)

---

yes, but only with 2008 and above, and i'm not sure if this is an enterprise edition only option. partitioning is certainly Enterrise only, but i think compression is...

Nice find.

Here is one that goes down to the object level.

http://jasonbrimhall.info/2010/03/19/security-audit/

You might want to consider using a POSH script.

Here is an example of one used to delete old backup files.

http://codetempest.blogspot.com/2008/10/delete-old-database-bak-files-using.html

What version of SQL Server are you running?

Sounds like a good opportunity to chat with Microsoft and/or to submit a Connect item on the errors.

Wise words, Steve.

It is very important to get that break from work. If on vacation, be on vacation and stop checking email.:-D

Sqlchicken (6/16/2011)

---

Hyper-V I'm sure has some great stuff in it as well but VMware is so far ahead of everyone its almost unfair. Cost-wise I'm sure Hyper-V will look much...

Are you suggesting that we think before we act/code/work/speak?

Thinking time is essential - whether in small amounts or large chunks.

Thinking time is a good way to also recharge the batteries...

Try View Server State (this will also give that user access to view several other catalog views too).

You could have those paths parameterized and then just pass the parameters to the execution of the dtsx.

Stuart Davies (11/30/2011)

---

KWymore (11/30/2011)

---

Interesting question. My brain did the auto translation that v3=v2 was the same as v2=v3 so I didn't even notice that error until I hit the posts...

L' Eomot Inversé (11/30/2011)

---

Pain, doom, disaster, or maybe I'm just having a bad day.

Today's QotD and my response to comments on it could be taken as an object less in...