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 28, 2011 at 2:31 pm

    #1388087

    Gaius Baltar (11/4/2008)

    Hi,

    Collect Job Info:

    SELECT @@SERVERNAME AS Server

    In Collect Backup History:

    SELECT substring(@@SERVERNAME,1,128) AS Server,

    Just found this today on a problem server. Seems to happen when a server name is changed after SQL is installed. Modify code.

    --Old Way

    Select @@ServerName

    --Better way in some cases

    SELECT SERVERPROPERTY('ServerName')

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter