• um....

    sp_dropserver will "remove a server from the list of known remote and linked servers on the local instance of SQL Server"..... so it will not affect at all your running instance.

    when you run sp_helpserver you are getting production right?

    Not sure if only the sp_addserver with the 'local' option will do the trick

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]