I am currently running into the following error when run a stored procedure with BEGIN TRANS:
"Could not find server 'VS-DEVELOPERDEVELOPER_SQL' in sysservers. Execute sp_addlinkedserver to add the server to sysservers."
The server shown above is the a local sql server instance that is running the stored procedure and therefore shouldn't need to be linked. Am I misunderstanding the linked server definition or is there another underlying issue with the stored procedure?
SQL Server 2005
August 18, 2011 2:12 PM
March 31, 2012 6:09 PM