When you use dynamic SQL it is excuted in its own context. This is reset between successive call to exec ( ). So construct your complete sql command into one string...

does

convert ( datetime, convert( varchar(8), nsjs.run_date) , 12)

this help?

Also run duration is in HHMMSS ie 125 means 1 Min 25 sec

I see from your script that you are using 'num_assign' assign field for both min() and where in update. Could you possibly create an unique index on that column? Depending...

By any chance 'text in row' specified for the receiving table?

Could you please specify what other indexes are on this table?

You can specify 'WITH INIT' to your BACKUP LOG statement to overwrite the backup device with latest backup. After the restore is successful on the destination server save the file with datetime appended...

In enterprise manager go to Management/ database maintainence plans. Right click on the label. Choose 'New maintainence plan' This will take you to the wizard where you can choose which...

Backup log will by default removes inactive part of the log after it successfully backup the log. Complete backup does not have any effects on inactive entries. Of course you...