SQL Server Performance Forum – Threads Archive

Instance name on report?

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!

---

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.

---

]]>