I am not a DBA, i am a systems administrator and i usually only deal with Windows Servers and hardware, Recently our only programmer left the company. We have a very important script that runs every day. Last weekend we moved our maion database toa new server with a new server name. I can see in his stored procedures where he names the server i the select statement. When i change the server name i get the following message
"Error 7202" Could not find Server 'NewServerName' in sysservers. Execute sp_addlinkedserver to add teh server to sysservers.
I ran a query "sp_addlinkedservers NewServerName" and it said it completed successfully but when i go back to change teh stored procedure it comes up with the same messsage