This is a logged operation, and so two copies of the index are needed until the reindexing is finished.

Your databases are growing because you have not properly sized them. The...

If this is production, call MS. Don't mess around with this.

Are you sure it's the same code?

Can you post it?

Silverfox is correct, this wouldn't apply if you don't hold a MS certification.

I wouldn't look at the exam page, look at the certification page and choose the path the makes...

Yes, that's all you do. Monitor the size and free space, and keep enough space to last you 3-6 months. Increase it in one large chunk for the next 3-6...

As Mike showed, you need to write the update statement first.

Once you do that, just enclose it in a stored procedure.

create procedure UpdateDownload

as

update....

return

Let me say that I might recommend you...

change the file sizes in the database properties in SSMS, or you can use the ALTER DATABASE command (http://msdn.microsoft.com/en-us/library/aa275464%28SQL.80%29.aspx) modify the file size.

I'm not sure that employers are as concerned about you being current in your field, especially as educating yourself without experience might not be the greatest way to develop skill....

Very interesting responses. I have to say that I haven't necessarily had that experience, but I can see your points. There are definitely managers that worry they would be out...

We are looking through code today to see if we can do something. A number of users and IPs have been banned to try and combat this.

You shouldn't create tables accepting more than 8060 characters in the design, or use TEXT fields. That way you will not run into this error.

It's a warning only, and the...

The other thing you could try to do is pre-trap the error. If you know it's a particular type of data, then look for that data before you process it...

SSIS is not available in SQL 2000. Are you using SQL 2000 with DTS or SQL 2005 with SSIS?

If it's DTS, I think you're stuck with this error. What you...

Or you should just buy a 500GB-1TB USB drive, attach it restore, then shrink things down, set a better log size and make a new backup.

It's not much $$, and...

@@error is your only way to do this in SQL 2000. Error trapping was fairly simplistic.