I have a database which I need to edit becuase the database is a 'settings' database and this database has some links within that point to a old server that I need to change to the new server name.
Im using SQL Express 2005 but do have access to the full version if needed.
So i just need to open up the database and change any links to the old server to the new one.
Here is the settings database attached, the link to the old server is called haybrooksbs and the new one is called hbit5\sqlexpress.
I have attached the database with the extension changed to .mdb from a .mdf so i could attach it, please change the extension to .mdf before viewing