How to alter sp only on some servers

[Puiu]

Hello

I have an application that sometimes requires database updates. however some stored procs updates must not be run on all the servers.

 

I've tried something like:

 

if @@servername = 'MyServer'

begin

 

alter proc MyProc

.....

 

end

 

But this doesn't work. I also tried using dynamic sql but also didn't work.

 

Thanks

[PlausiblyDamp]

When you say it 'doesn't work' what does happen?