January 28, 2009 at 3:02 am
Hi,
I want to find Report Server in my network with TSQL.
How can I do this?
Kind Regards
Ayşegül
February 2, 2009 at 9:41 am
I don't think there is a simple way to do this using T-SQL as a Report Server is a whole different beast. I think the easiest way would be to check the Services applet on your SQL Servers to see if the Reporting Services service is installed.
You could probably write an app in .NET using WMI or SMO to go out and check for Report Servers. If you Operations Manager you could probably do a query in that as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply