Kind of a rookie when it comes to SQL but maybe someone can help
I backed up 2 databases from a SQL Express 2005 on server1\sqlexpress. I then created 2 new databases on SQL Express 2005 (on SBS2008 64bit) but this instance is called server2\SBSMONITORING.
I then restored the two previously backed up DB's back into the correct database names. When trying to run the program that utilizes this data i receive the error "Could not find server 'SERVER' 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. Could not use view or function 'dbo.MarketingData' becuase of binding errors."
From what I can see everything looks the same between old server and new server but i must obviously be missing something.
Any help would be great.