Are you talking about Linking to multiple servers and running a stored procedure on each server, then yes you would have to have the procedure on all remote SQL Servers. An easy way to check for the procedure is to check sysobjects in the database that you should have the procedure in.

Work like you don't need the money.

Love like you've never been hurt.

And Dance like no one is watching.