We keep a database and table in each lower environment to map the database names to the appropriate server\database for each distinct environment.

Then I have sql script to dynamically drop...

We started using synonyms a couple years ago and have found them to be a great way to manage lower environments especially for restores.

Also, we usually create a schema for...

Yes it does, thank you. Regardless though, we have found it best practice to make those variables nvarchar(max). Lazy, but effective.:-)

I have searched the internet for this situation to no avail, but we believe that starting in some version of SQL2008+ that if you define the @columns variable as anything...

Fun creative game. Worked great!

"Game over. Computer player wins in 38 shots!"

Wondering if the trouble might be with using Access as the interface. 

Are all users accessing the same interface?  If so, we have found it much better to provide the...

We get this error on just about all database access through Enterprise Manager every time we reboot the server. I am not sure that this is exactly the same...