Ask the administrator to back up the transaction log, which should free up space in the file.  Then, as Chris suggested, break up your delete into smaller batches.  However, breaking...

I'd be looking at anything and everything that has been changed in the application at the time that this started.  Its got to be something in the application doing this.  I...

Steve,

Take a look at this thread -

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=124868

Steve

I sometimes get fouled up on joins, and I don't have your schema to test with, but....

UPDATE dbo.Employee

     SET CongDist = R.CongDist

FROM dbo.Ranged R

     INNER JOIN( SELECT R2.Start,...

As a matter of fact, I copied the post that started this thread into my clipboard before posting it!

Steve

missing the "ON"

 

UPDATE dbo.Employee

     SET CongDist = R.CongDist

FROM dbo.Ranged R

     INNER JOIN( SELECT R2.Start, R2.Stop FROM dbo.Ranged R2 

                      WHERE dbo.Employee.hzip = R2.Zip) Range

     ON ......

WHERE...

Juanita,

In my opinion, Microsoft messed up when they named it the "transaction log", because that isn't really what it is.  Its a transaction facilitator.  When you issue an update, for...

I don't have any experience with ftp, but I would think that you would create a maintenance plan to back your database up to a local disk (which includes scheduling),...

In Simple Recovery model, as the transactions are written to the database, they are deleted or "truncated" from the transaction log.  This is done each time a checkpoint is issued,...

I read that in Books Online too.  But its not quite accurate.  In Kalen Delaney's book, Inside SQL Server 2000 (pp231-232), she states -

"A row with variable-length columns requires...

You could send your text as an attachment to overcome the 8000 char limitation.

Steve

Just be absolutely sure that if you are not taking transaction log backups, that you change the database recovery model to Simple.  If you don't, you'll discover that your transaction...

The log will not shrink on its own with a transaction log backup.  It will truncate.  The difference is that SQL has ALLOCATED 450MB to your transaction log because at some...

If your server is going into single user every night, you should probably look at your maintenance plans.  Some maintenance actions require exclusive use of the database, and a maintenance...

If this is a one time shot, you should be ok just copying.  Be aware that the progress bar in Windows Explorer may go haywire, showing incredibly large positive/negative numbers. ...