Results 1 to 3 of 3

Thread: implications of using sp_dropserver?

  1. 06-22-2005, 09:56 AM #1
    NickKnife
    NickKnife is offline Registered User
    Join Date
    Jun 2005
    Posts
    3

    implications of using sp_dropserver?

    I need to rename my server and i believe i have to use dropserver and addserver. What are the implications of using these commands. Will I lose any data or anything?
    Thanks
    Nick
    Reply With Quote Reply With Quote
  2. 06-22-2005, 12:11 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You will not lose any data, it only updates the system catalog (sysservers table)
    Reply With Quote Reply With Quote
  3. 06-22-2005, 12:13 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    refer this.
    http://databasejournal.com/features/...le.php/2194711

    you need to update master..sysservers table and msdb..sysjobs and the client
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules