|
|
|
SSC Eights!
      
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 10:26 AM
Points: 891,
Visits: 1,958
|
|
| That looks very neat, but considering the cost of getting into Management Server, I doubt we'll ever see it here.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, October 08, 2008 4:03 PM
Points: 36,
Visits: 65
|
|
| I was looking for information like this. We have recently implemented SCOM and as a DBA I need to learn part of it. Yesterday I upgraded one of my moitored server to sql 2005 with sp2 and latest hotfix. Today SCOM sents an alert saying this installation does not have sevice pack. We checked to make sure. We have other tools and we found that it was a false alert.
|
|
|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Saturday, January 03, 2009 8:35 PM
Points: 9,
Visits: 12
|
|
Thanks for the article.
I used it to create a view into our depot servers :)
We assign roles to all of our servers so I used your method to get the role name out of the registry.
Very nice and well done
Thanks!
|
|
|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Wednesday, October 31, 2012 8:32 AM
Points: 104,
Visits: 128
|
|
| OpsManager reminds me a lot of another product, Data Palette (www.stratavia.com). Does anyone have experience using both products? If so, what are the pros and cons of each?
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: Monday, April 22, 2013 1:48 PM
Points: 63,
Visits: 178
|
|
Tom, I did finally get this all setup and thanks a ton for this. I am still having some issues on certain instances not showing up. I'll dig more but wonder if you had similar issues.
Certain SQL2005 cluster instances are not showing up. Some are however so that is strange.
Also I have one named instance on SQL2000 that doesn't get caught. I'll start digging into the Registry keys tomorrow to see what's up but if you had run into this you might save me some time.
Thanks,
2/9/2010 Update I have figured out that the Registry key that this article is pointing to is the default instance key for SQL Server. So on servers without a default instance (We have a few) this will not work. Still looking for other options and will post back when I find one.
|
|
|
|