I just had this problem on one of my test servers. Simply restarted it and it went away, which you would expect with the problem being in tempdb, unless...

If the table variable is changed to using a temp table, the error does not occur.

I've actually came accross a situation where I can create this error at will. 32 bit SQL 2005 (tested on build numbers 3042 and 3239) running on Windows...

So I'm a few months behind on reading my daily mail from SSC.... (full time employment and styudying for MBA will do that...)

Great article! Don't Panic really is the...

Found the problem: need to have Office 2003 SP3 installed.

LOL

Actually as a consultant I came accross a site that had software compression turned on, back in the days of Pentium Pro 180s.... Lord was I a hero when...

One problem I have with hosting is something we have just gone trough here, and is one of the reasons I just now have time to go trough my emails...

Phil Factor (10/30/2008)

[p]David,[/p]

[p]Yes, I do them for free. [/p]

[p]...and your analogy with cars and...

I think my only 100% absolute is no sp_ in front of stored procedure names. As I think Grant said above, the sweat, blood and tears have worn away...

I've been pretty lucky so far. Pulled everything out of the stock market a week before it hit the top last year to pay off debt. All I...

The MS data center in Iowa is not excatly being built in some small remote town, yes Des Moines is small compared to NYC, Dallas etc, but still ok. ...

Same goes as an employee. Big enough to have the benefits we all need, small enough not to just be an employeeID field in a database.

I've worked at big...

I take it you are asking about Recovery Model? Not changing tables in the models database...

Recovery Model can be changed on the fly with no downtime.

Kind of a broad question. I will start with this: Can you get away with not having XML in the database? You will save yourself a lot...

Bad data happens...

WHen I got my US Passport my last name was spelled wrong. THis with the name taken right off my naturalization papers, which has it right. ...