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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-03 : 10:03:56
|
| Nat writes "SQL server started to work very unstable - the same statesment can take from 1 sec to 2 min to run.This has happend when the name of computer where SQL installed has been changed.Could it effected SQL server and if yes - in which way and how it can be corrected ?" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-03 : 10:37:25
|
| search here for "computer name change"...."all words option"...in the "administration" section....will throw up several items, in which similiar situations to yours seem to have been described....follow the suggested links in the various answers....maybe they will be of help to you. |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-04-03 : 10:41:15
|
| I'm assuming you are on SQL2k, 'cause SQL7 shouldn't even start until you've jumped through a few hoops after renaming your computer... But on SQL2k you will have to run the following: sp_dropserver 'old server name' sp_addserver 'new server name', 'local'---------------Strong SQL Developer wanted in the Boston area. Please e-mail if interested. |
|
|
|
|
|
|
computer name has been changed