MSSQL Tips: Tip #37 – Template to Create SQL Server Synonyms with checks


When a SQL Server synonym is created with T-SQL the base object’s existence is checked only at run time. SQL Server Management Studio (SSMS) has some built-in checks that are performed during synonym creation whereas T-SQL scripts can be written several different ways and do not have any checks by default. In this tip I explain what is the best way to create synonyms and why.

Please read the latest MSSQL Tip: “Template to Create SQL Server Synonyms with checks“.

Check out all of my tips here: