Is there an easy way to be connected to a MS SQL database and execute a stored procedure from another DB? Thank you for your assistance. Chuck
yes sure, the simplest way; select * from [OtherServerName].[OtherDBName].[dbo].[OtherTableName] you may use linked server queries too but the first one is easy. ps:Your sql server user must have access to both databases.