A great article about a very important topic. 

At my previous place of employment, we ran into issues when a user would create a table in code, but not specify...

We have server names with dashes (-) in them, and I have used the following syntax successfully:

exec [Server-Name].[master].[dbo].[script-name]

That should work for you.

This is what I have used in the past to find the latest backup from a particular database and use the file to restore over an existing database:

DECLARE @DBBackupFileName...

Always great to see undocumented stored procs featured.  I will most certainly be using a few of these.

Thanks for the great atricle

All the tables have a clustered index on them already, so I can't add a new clustered index to them.  I wanted to make this process as dynamic as possible, without...

I have a physical FK constraint on there.

thanks