Define "copy":

if that is the same objects without content, just script out your full db ( rightclick in your object browser hovering over the dbname, choose "all tasks" select generate...

The kb addresses sql2005 having this issue.

OP stated his server is sql2008.

But it is indeed a good hint on posting the @@version info of this instance.

I would also double check if there is no concurrent full database backup running at the same time. Although the errormsg doesn't state it explicitly ... I would just check...

Don't rush in to...

I really don't want to kick a fallen peer, but this is near to the up most mistake people make when designing tables.

Use the correct data type for your...

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