No, the message only states something is wrong.... which we already knew 😉

Can you check the maintenance plan log, or enable it ?

Don't just rely on the ddl trigger taking for granted it is active.

Set up a sqlserver event monitoring, so you detect when the trigger is being disabled ("disable trigger"...

as you have noticed any trigger is "in transation".

Your transaction will not complete until your trigger is completed.

Check out SQLServer service broker to get a async solution for this.

Service broker...

Keep in mind you posted in a SQL2005 forum. Maybe ask SSC to shift it to a SQL2008 one.

- please post the actual backup error message (check your sqlserver logs)

Have a look at SQLCMD in books online !

hmm ... so you're going to have users write your sqlscript and direct upload/update your prod db ??

If that user just needs...

I would double check this query using a simple select.

Select COUNT(*) nRows

FROM dbo.convertr$

inner JOIN dbo.tbl_RadioRates

ON SUBSTRING(dbo.convertr$.STA_CODE, 2, 4) =...

Jack Corbett (11/7/2010)

---

Evan is doing okay, but is in a lot of pain still. Hoping to bring him home this evening, but may not be able to because of...

Jeff Moden (11/7/2010)

---

Shifting gears, I'm alive and well and in the Paramount hotel in Seattle which is located and 8th and Pine... just a couple of blocks from the convention...

Jack Corbett (11/5/2010)

---

Today my oldest son (9) fell off a swing, landed wrong on his arm and is on the way to the ER with his mother because I'm pretty...

Roy Ernest (11/5/2010)

---

Ah Crap and double crap. Hurricane Tomas is threatening again. It is turning to the east and the tail is once again coming over the island. Why cant...

Jack Corbett (11/5/2010)

---

Grant Fritchey (11/5/2010)

---

We've been doing this for years. It works really well. I detail a bunch in the book that's getting released from Red Gate next week. In...

GSquared (11/5/2010)

---

CirquedeSQLeil (11/4/2010)

---

Grant Fritchey (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion...

Paul White NZ (11/5/2010)

---

Wouldn't it be nice if MSFT put a bit more effort into their replies on Connect?

Just confirming the bug is nice...

Here's a nice WP from SQLCAT that highlights about high availability and mentions the major topics a SLA/DRP should have:

http://sqlcat.com/whitepapers/archive/2010/11/03/failure-is-not-an-option-zero-data-loss-and-high-availability.aspx

I received feedback from MS ....

...

The problem is that we were trying to apply a particular optimization that doesn't work with table variables. The bug has been fixed for the...