I have a situation where I have a couple of stored procs that refer to a linked server. Now, at customer deployment time, my linked server name, isn't likely to be their linked server name. I have a solution to overcome this, not pretty but does work.

What I would like to know is, can I flag a stored proc in any way so as it doesn't get packaged up? If this isn't possible any chance of getting it on the list of enhancements? either with a checkbox, saying Do not deploy OR a group of procs that you just put the proc into the group that you don't want to deploy.

I guess this might sound a little daft, but I don't want to remove the stored procs from the structure, mainly because over time I will likely lose them.

thanks in advance

Geoff