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 |
|
fbf
Starting Member
1 Post |
 Posted - 2010-07-30 : 07:53:35
|
| Hi,I have a problem with renaming the PC.Here is the detailed description of my problem.I have a application(i cant reveal the name) which is installed in split manner, here the split manner means i installed the application in a PC(let me say PC1) and while installing the application i need to select a location(PC2) which is having SQL installed so that the application will create the database in PC2 and store the data in it.Now my problem is i want to rename the PC1(which is connected to SQL of PC2).How can i use the "sp_dropserver" and "sp_dropserver" command in this scenario?If it is in the same PC then i can use like,"sp_dropserver 'oldname'" and "sp_addserver 'newname' , 'local'"But in my case SQL is in different PC and the application in different PC.Please help me out.Thanks in advande |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-30 : 08:03:01
|
What is the problem with PC2 (~ SQL Server) when you are going to rename PC1 (~ Client)?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
changing the remote PC name.