July 31, 2008 at 7:18 am
SQL Server 2005
The database backup(created from server named FLAG) was restored on another server(named TRAP)
When I try to run the stored proc on the db instance on TRAP, I get the following message:
Msg 7202, Level 11, State 2, Procedure sp_getKeywordList, Line 3
Could not find server 'Flag\INETPPCDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
There is no explicit reference to "Flag", the original server, in the stored proc. I should not need/don't want any reference to Flag, I don't know why it is looking for Flag. It should be self-contained on TRAP. There must be a hidden reference somewhere...
I would appreciate a push in the right direction!
Thanks, Dan
August 1, 2008 at 8:16 am
Check what Linked Servers you have setup on FLAG... set up the same ones on TRAP
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.August 2, 2008 at 5:47 pm
That was it! Thanks.
Dan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply