Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Bird SQL Overview SSIS Package III - Full Package RE: SQL Overview SSIS Package III - Full Package

  • September 29, 2011 at 7:44 am

    #1388370

    To fix the value of @@SERVERNAME for renamed server use

    sp_dropserver <old_name>

    GO

    sp_addserver <new_name>, local

    GO

    I have used these comamnds to fix @@SERVERNAME. It requires a restart of the instance.

    Source http://msdn.microsoft.com/en-us/library/ms143799.aspx

    David Bird