How to restrict a code from running in the production environment?

[Walid]

Hi,

I am trying to find an elegant way to check, in the beginning of a sproc, if I am in production environment. In which case, I will prevent the code from running. This is suppose to be the last level of protection, of course we will be careful and try to check for this in so many different places in the app but because I am paranoid by nature, only when it comes to coding, I still prefer to have this defense mechanism just in case.

My question is, is any of you ladies and gentlemen, know an elegant way – architectural wise – to perform this. The server name in production is different than dev. Any advice?



Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch

 

[SQLDenis]

if @@Servername <> 'SomeName'
return
else
begin
--rest of proc
end

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

 

[Walid]

Thanks for the reply.

This is what I thought of, originally. But I am looking for more generic way without the code itself being aware of the conditional execution. One of these architectural wows we get here some times.



Walid Magd (MCP)

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch