Display Instance Name On Reports

• alimcitp

  SSC Eights!

  Points: 930

  More actions

  March 18, 2008 at 4:52 am

  #180206

  Hi,

  I want to create the SQL Server report to display the status of all SQL Server instances on our company. I know how to do that task in .NET Framework but my employer wants me to do that in Reporting Services. I will really appriciate that if you guys guide me the major steps to accomplish this job.

  I want to display the information like

  Instance Name --- Status

  SERVER 1 Active

  Basit Ali Farooq
  MCITP Database Administrator
  Microsoft Certified Professional Developer (Web Applications)
  Microsoft Certified Database Administrator
  Microsoft Certified Systems Engineer
  Microsoft Certified Systems Administrator
  CIW Security Analyst
  Cisco Certified Network Associate

• meghna.bhargav

  SSCrazy

  Points: 2634

  More actions

  March 18, 2008 at 5:52 am

  #790750

  Do u have the query ?

  thanks