SQL Server Error 7202 Could not find server

5 pts.
Tags:
SQL error messages
SQL Server
SQL Server errors
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: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • The Most-Watched IT Questions: August 30, 2011 - ITKE Community Blog
    [...] Mrdenny got to the bottom of SQL Server error 7202: Could not find server. 6. Mrdenny has a quick suggestion for multipath [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: