Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrei
Starting Member
1 Post |
 Posted - 2001-12-13 : 05:13:07
|
| My officemate accidentally changed my computer's computer name and now I can't access any of my SQL databases (and other objects)I don't have a backup. Anyone knows how I can retrieve all my Data Objects?Thanks! |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-13 : 08:22:53
|
| If you are on SQL7, re-run SQL Server setup. It will tell you that your system will be upgraded. After this is done, reboot and run the following in Query Analyzer (connect using new name): exec sp_dropserver 'old server name'exec sp_addserver 'new server name', 'local'Then re-register the server under the new name in EM.If you are on SQL2k, you should not need to re-run setup (just run the commands above). This steps will rename your SQL Server. |
 |
|
|
|
|
|
Change of computer name