If it's a simple while loop, they'll execute serially anyway and therefore putting a delay between them won't have much effect. Are you sure you're using option 3 that...

Maybe you've got an uncommitted transaction or something like that. How much free space is there in the log file after the index maintenance has finished and the log...

Once the rebuild of any index has used up space in your transaction log, that space won't be freed up again until the transaction log is backed up. You...

Is your database in Full recovery mode, and if so, how often do you back up the transaction log?

John

You're doubling up your quotes. If you avoid doing that, it should solve your problem. If you're working in Management Studio, everything enclosed in quotes should be coloured...

Who told you to do that? Please will you post the CREATE TABLE statement for Table A?

John

You shouldn't do that, because you'll destroy your referential integrity, and chances are you can't do it anyway, since the REASONSREFERRAL column probably has a data type that won't allow...

Presumably you're hitting an error in your TRY block and breaking out of it before the COMMIT TRANSACTION statement is reached. Can you not lose the explicit transaction -...

I'm not sure it would, to be honest. They'd be two different sessions. You'd need to test. But even if it did work, I'd strongly recommend against...

Use a UNC path, not a mapped drive. The mapped drive is only visible to the user that mapped it, not to the SQL Server service account, under whose...

Use DISTINCT when you want to eliminate duplicates from your result test. If you use it in an existence test, like you did in your original post, then it...

As I said before, clean up the data before it goes into AgencyDB so that it doesn't violate the constraints. If you need more detailed help than that, please...

Is there a PRIMARY KEY or UNIQUE constraint on account.account_id? If there is, that'll be why the execution plans are identical.

John

How are you restoring the information from one database to the other? You can't insert any rows into AgencyDB that would violate any constraints in that database. If...

You can't do much with the results of a stored procedure, other than insert them into a table. You'd be better rewriting the procs as functions, the results of...