Thanks! That did the trick for me. I don't know why I couldn't figure out the ceiling/floor deal...but this is exactly what I needed.

Well. it was a good idea ... but evidently the synonym has to refer to a 'final' object (table or view or stored proc)... and the [servername].[databasename] portion is...

I know nothing about synonyms before so this is a good point to learn.

My environment is that I am deploying a stored proc at multiple locations (different...