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 |
|
p.shaw3@ukonline.co.uk
Posting Yak Master
103 Posts |
 Posted - 2007-03-19 : 11:25:56
|
| Hi All,This may be a silly question but I just want to be 100% sure before I continue.I have a live SQL Server 2000 instance that resides on a web server. This has been up and running for a while now but I have just decided that I want to use replication. The problem is that the instance is named (Local) and of course you cannot use replication unless the server is 'named':"SQL Server replication does not support nicknames, such as "." or"(local)" as server names.Delete the SQL Server registration for this server and register itusing the actual server name"What I want to be sure of is, if I delete thie current registration and re-register using the server name, will the re-registered instance be exactly the same as the old (Local) instance when it is re-registered. Will I lose anything by deleting then re-registering?Also, will replication have an impact on and degrade the overall performance of the web site?Thanks. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-03-19 : 11:50:31
|
| The instance isn't named (local) - that's just how you've named it in enterprise manager.It'll be the same server. It only affects the enterprise manager connection so what are you worried about - the worst that could happen is that you would need to reregister.What type of replication? Transactional replication will have an impact - it will probably cause more logging. Again - try it and see.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Rename registered server in Enterprise Manager