Look at free space on the drive your writing to. Also, have a look at these links. Varied answers but they may provide some other direction towards a resolution.

http://support.microsoft.com/kb/326485

http://www.dbforums.com/t812439.html

http://www.sqlservercentral.com/Forums/Topic128881-24-1.aspx

http://sql-server-performance.com/Community/forums/t/4946.aspx

Haven't heard or said tuple in ages...probably from my school days, long, long ago! It's a funny sounding word actually. I asked my 13 year-old if she had ever heard...

Your posting in the wrong forum. For quicker, more accurate responses, post in SQL2005. See Ed's post. Quit shrinking the database. Size it properly with enough free disk remaining for...

See Steve's suggestion. Call an outage and restart the services/server. It'll rebuild tempdb. Can you determine what's filling it up (maintenance job? runaway query?) or are you dead in the...

That's about the only way in SQL2K. There are third party tools, like LiteSpeed that will allow you to restore a table (or other objects) individually but I don't recall...

Anything by Itzik Ben-Gan and Kalen Delaney are good ones. The link below has many book reviews, depending on what you want to do (there is one for .NET programming...

I'd be very careful killing jobs that are "sleeping". Why would you want to delete the jobs? Are you trying to do a restore and have an active thread into...

My oldest IS going to college this fall. I can't believe how fast the time has gone by. When she was born, I decided that I had to have a...

If your database is set to "simple", you cannot backup the log. Are you running any maintenance jobs like rebuilding indexes? As far as delete versus truncate, is it purging...

A lot of hits on Google. Does the file exist in that location, with that name? Is it a network drive as opposed to a physical drive? Also, take a...

Glad you sorted it out. It is an online operation, I forgot that SQL will grab as much as it can (up to the max, if there is one) but...

Can you run a DBCC CHECHKDB WITH NO_INFOMSGS, ALL_ERRORMSGS on the database in question and post the results? Wondering if you might have corruption....

If you can supply some table layouts and code samples, we might be able to help. What are the sprocs doing, selects/updates/deletes? Are your indexes optimized? How many is "and...

Great tool. You can download a trial version, for free, and check it out. I've used it in the past to actually resolve an issue we were having. Trying to...

I don't believe there are limits to number of rows (laks = 100,000 -right??). I have tables with 500 times that amount and don't have issues (I'm running SQL2K, sp4)....