Maybe you can use the Update in combination with an SELECT top 1000

UPDATE

You can also use trigger incombination with the deleted and inserted table

ROnald

Hi Bill

We receive the error 'log file for database TempDB is full. Backup the transaction log' in the event log of sql server 2000. the growth is set correctly and...

The last problem we have solved (copy of the backup file>> there was an sequerity problem on the server an windows give an encrypton description the file can be copy...

thanks for you answer

The settings with the server are correct except that i have the grow on 10 percent. So this i have now on 50 percent. The diskspace is...