You can't use ms_foreachdb to insert a parameter into a query that's directly executed. You need to submit a query as a parameter.

Luis has shown you how this would work.

crussell-931424 (7/3/2013)

---

What I worry about is the data getting degraded, "accidentally" changed or whatever, as it moves from one location to another. For example, in your editorial I noticed a...

Whether you agree/believe with/in religion, GWaK does raise a good point that many people that go are very giving. They feel it to be a part of their religion. Is...

Eric M Russell (6/28/2013)

---

LOL! I do recall once, in the aftermath of a delete script gone wrong, querying the transaction log for a clue about what stop date/time to use...

Hope things are well.

I didn't write this because of religion or government.

I have spoken on this before, and I do think it's important. Being a part of some sort of non-profit or...

jasona.work (7/1/2013)

---

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio...

Thanks, glad you liked it.

Good idea, and definitely needed. I've asked for a few items to be added to search and they've been bumped on the list. We have a few things in progress,...

batgirl (6/28/2013)

---

This is my first year in the automotive industry. I must say that for the most part, I don't like being forced to take my vacation at specfic...

touche, I was trapped by Jon and Joe.

Good seeing you in any case and glad you had a good week.

Perhaps we have different definitions of side project. As John H noted, this would be 15-20 hours outside your current job, nights, weekends, whatever.

This would assume you've gotten through an...

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...