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?