Home > IT Answers > SQL Server > SQL Server Error 7202 Could not find server
Jabeam
5 pts.
 SQL Server Error 7202 Could not find server
SQL error messages, SQL Server, SQL Server error messages, SQL Server stored procedures
Hi all, 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?


Software/Hardware used:
SQL Server 2005
ASKED: August 18, 2011  2:12 PM
UPDATED: March 31, 2012  6:09 PM
RELATED QUESTIONS
Answer Wiki:
Sounds like the stored procedure is looking for a linked server as part of the code, but that linked server doesn't exist. You'll need to look at the source code of the stored procedure to be sure.
Last Wiki Answer Submitted:  August 19, 2011  6:18 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _