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