This might work. Looks like it's got old sprocs being called in it

http://www.sqlservercentral.com/scripts/Security/63991/

I'd guess you have some permissions issue here. With the three part naming, I'd expect that context isn't an issue, but either the object, or the delete permission is missing...

Thanks, Brent. I've made an update to the article, but the setting is probably OK for us right now.

I've also queried the SQL Monitor folks on the backup history. We...

Already added 😉

That's one I want as well.

I think this is on our list, but I've forwarded it on and (hopefully) given it a bump.

because?

You'll have to provide mode DDL and sample data. Also, how do you define an internal address?

YSLGuru (6/26/2013)

---

SQL Server Audit (as of 2008) can capture everything I need it just puts it in a Window Log and while I can get at it via the fn_get....blahblah...

Andrew Watson-478275 (6/26/2013)

---

Would it be possible to be a bit more careful with the content of articles? Our content filter bounced this newsletter, presumably because of the use of...

Lots to look at. As mentioned, warm v cold cache can matter. Did you run it multiple times on the VM?

You restored, did you update statistics, rebuild indexes (only the...

You're deeper than most us at this point. Apart from burning a call to CSS, I might email Paul and ask him. He may get a blog/article out of it,...

mtucker-732014 (6/25/2013)

---

This is a problem in many businesses and I believe stems from the near universal idea that a business should maximise shareholder value ahead of value generated for other...

I believe SQL Audit can do a lot of this at the database level. You'd have to experiment a bit with that. However you can do some of this with...

What Sean said. This might help: http://www.sqlservercentral.com/articles/66909/

However with regards to #3, explain how the results are calculated. In your example, I assume you want "Customer123@provider.com", but you never say that....

I'd build a calendar tables (there are articles on this site for that). essentially populate it with all days, mark weekends, holidays, and other days. That way you can join...