Preventing SQL from Running on a Testing SQL Server

There are two ways to prevent your SQL code from running on a testing or production server. You can use the @@SERVERNAME Variable or the DB_NAME function, as shown next below:

@@SERVERNAMEIF @@SERVERNAME = 'ProductionServerName'BEGINPRINT 'Code will NOT execute'RETURNENDELSEBEGINPRINT 'Code will execute'ENDDB_NAME()IF DB_NAME() = 'ProductionServerName'BEGINPRINT 'Code will NOT execute'RETURNENDELSEBEGINPRINT 'Code will execute'END
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts