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.

Ive tried something like:

if @@servername = MyServer
begin

alter proc MyProc
.....

end

But this doesnt work. I also tried using dynamic sql but also didnt work.

Thanks

 

[PlausiblyDamp]

When you say it doesnt work what does happen?