April 13, 2006
mssql stored procedure garbage (geekin)
since nobody on the internet seems to need to know this, or i just don't know how to search for it, here we go:
in order to execute a stored procedure in mssql from a database other than the one it exists in, you need to create a synonym for the stored procedure you want to execute in the database you want to execute it from. index that.