I've never had that error. Make sure you are connected as system admin on the server.

Also I've tried using the default trace to target single_user changes and it seems...

do you have anything in the sql and windows logs pointing to a possible reason?

Is your server or msdb case sensitive? Maybe you could rerun the query with a...

It works for me and I'm on 2005 too. Make sure you are in the MSDB databse.

Hugo Kornelis (1/4/2011)

---

I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then...

Maybe we're going about this the wrong way.

The optimizer is build by some of the smartest minds on the planet. So while it's not perfect I hardly feel better...

tfifield (12/22/2010)

---

All of the advice so far given is excellent. I would like to expand, however, on a point made earlier.

It is VERY shortsighted of your company to not...

LutzM (12/22/2010)

---

pwalter83,

please stop reposting the same stuff over and over again.

You've been asked multiple times to post some additional information and you've been pointed at a link multiple times that...

Reo (12/22/2010)

---

I do not want to SQL Server to think. I want to force/instruct SQL Server to...

Thanks for the link.

But the more I think about it, it's the same as the report. Any half decent dba will be able to reverse engineer the cubes from...

Ya, I'm trying to force maxdop 2 on a semi-complex query and the optimizer is just not...

Luke L (12/21/2010)

---

Ninja's_RGR'us (12/21/2010)

---

No, that's the solution I had to come up with.

Make an asp .net report project, compile to dll and only deploy the dll.

As for performance I think...

Plz don't cross-post.

Plz post answers to this thread :

http://www.sqlservercentral.com/Forums/Topic1037636-148-1.aspx#bm1037793

SELECT SUM(DATELENGTH(ColName)) As Bytes FROM dbo.table

I only see this error when the server is restarted or someone / something killed my connection.

sqlchanakya (12/21/2010)

---

Basically, in OLTP system, parallelism is not a good thing. The fact is that, the overhead on the parallelism and sometimes, one thread has to wait for the other...