Post reply

sp_helpserver\dropserver

  • September 15, 2005 at 12:31 pm

    #110770

    I just ran "sp_helpserver" on a production sql 2000 server. It returned two names:

     

    name                      network name   .....

    <OldServername>      NULL

    CurrentServerName    CurrentServerName

     

    1 I was surprised to see the name of an older, now defunct server, in line 1. (The OldServerName must be an artifact from the way the databases were transferred to the new box.)  Still, the network name is NULL so I assume this will have no impact on the functioning of the server. Am I correct?

    2, Next I wanted to run "sp_dropserver 'OldServerName' "  but the query returned that users are still associated with that old server. How can I list those users to make sure there is no login overlap between the old and new servers?

     

    TIA,

     

     

    Bill

  • September 16, 2005 at 7:18 am

    #590560

    First check if the old server is used in any linked server. If it's not, run sp_helplogins to see if you have any logins in the format of oldservername\Login. Asp.net has a predefined login in this format. It's servername\ASPNET.

     

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply