Isn't this the same problem you were working with here:

('http://www.sqlservercentral.com/Forums/FindPost745975.aspx')

?

I wonder if he'll get the magic 8-ball reference.

How big is your MSDB database? Are you sure it's the MSDB backup that is causing the out-of-space condition.

Without more information, my response to a demand for an ASAP...

I had a boss who liked to say that GHOTI was an acceptable English spelling for FISH.

GH as in rough

O as in women

TI as in action

It's cool to speak a...

Optionally, he could open up the disk drive and scrape off the coating on the shiniest part of the disk, using the assumption that it has had greater activity...

I feel...

Really, Lynn, you're making this too complex.

First get a block level disk editing tool.

Find the space on the disk where the rows of the offending table are located.

Examine...

Logically, rows in a table are not ordered in any specific way. You would use the ORDER BY clause when you retrieve the rows to deliver them to the...

Roy,

That was like watching The Sixth Sense, only geekier, and without the creepy little kid.:w00t:

I guess you could actually equate the OPs with ghosts. Stuck here until their issues...

BOL is the "help" for the server. It may have been installed with the server. If you can't find it, MS helpfully keeps it online.

Here's the URL for...

Just a hint.

The WHERE clause you have coded is entirely within the subquery. So there is no WHERE clause that applies to the UPDATE action. Every row...

Restores aren't normally backward compatible. There will be features and structures in the 2008 database that 2005 won't understand or be able to deal with. If this isn't...

Sorry. I think I'm being exceptionally thick today, for some reason.

The OPENROWSET idea is probably the easiest one and it would be well worth your time to search this...

You can save query text in an editor like notepad. I usually use the .sql extension, and open the text file using the open dialog in QA. You...

I'm not sure you'd have much luck rebuilding a table with an identity column from raw data. Normal practice would be to get the last backup, restore the entire...

create unique nonclustered index userkey on tablename (userid, datetime_entered) on PRIMARY

If you're going to just slap these two columns together as a bigint, as you have proposed, you might save...