Use the Deploy Routines wizard to deploy stored
procedures or user-defined functions to a database. In some cases, you can
create a routine using one server definition, and then deploy it to the same
type of server or to a server with a different server definition.