SQL Server Performance

Instance name on report?

Discussion in 'SQL Server 2005 Reporting Services' started by EA1, May 11, 2007.

  1. EA1 New Member

    Hi,

    I want to display the name of the (named) instance on my report.

    I've tried using expressions, but without succes!

    Google-ing on it gives a lot of hits, but no answers....

    Suggestions?

    Thanks in advance!
  2. satya Moderator

    SELECT CONVERT(char(20), SERVERPROPERTY('InstanceName'));

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page