Good to point this out. This is one of those situations where it depends on the business. Calculations can a be a tricky topic because users sometimes believe that...

I agree this may help. This should give you an index...

I forgot to mention that you can set the tsql I posted into a job to run as often as you want.

I do not know what recovery model you have...

Probably would be faster to truncate the destination table and bulk insert from the source to the destination.

I really do not see a reason to spend time trying to figure...

Check the upper limit of what you have allowed for tempdb growth. It may be set extremely large.

I think it is picking up the autogrowth limitation is that roughly what you have available for disk space?

Also, post what the result should be.

I posted the code to create a delimited string, but you should be aware of some things. In some cases, using a function that concatenats the string using a...

There is absolutely no reason to use Dynamic SQL for what you want to accomplish. There are plenty of other options available. All you need to do is...

Ideally, you need to implement some sort of object tracking system. A few available options are source control and DDL triggers.

Source control allows you answer the big...

Are the stored procedures being dropped/created and not altered. I think this would render the previous solution invalid.

For example does the Agent account have access to the directory where you are creating the Excel spreadsheet?

You need to check the job history. Right-click the job and view the history. If it is not working it should tell you why in there. I...

Cool. Thanks for the feedback.

Even though the transaction has been rolled back, the seed is still altered. You would have to reseed to get a consistant flow of ids.

This is the code to...