Central Management Servers

Question

Post reply

Central Management Servers

Viewing 9 posts - 16 through 23 (of 23 total)

You must be logged in to reply to this topic. Login to reply

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

TO easy -- I use a CMS for all my servers - makes life very simple.

Good question though.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Ken SSCoach Points: 17191 More actions · Answer 2

I don't currently use CMS but I might start. Looks like a very handy way to check things across servers. Thanks for making me go look this up Steve!

Arthur Kirchner Ten Centuries Points: 1239 More actions · Answer 3

Arthur Kirchner

Ten Centuries

Points: 1239

December 13, 2013 at 5:45 am

#1673212

--oops, I overlooked the second page of post, sorry

Hany Helmy SSChampion Points: 13921 More actions · Answer 4

Nice tricky question, must read it very carefully so not to fall in the trap.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Nice question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Damian Widera-396333 Ten Centuries Points: 1196 More actions · Answer 6

Good one but it was not a question about the CMS but rather if you can read the text carefully 🙂

Kindest Regards,

Damian Widera
SQL Server MVP,
MCT, MCSE Data Platform, MCSD.NET

sqlnaive SSCoach Points: 17437 More actions · Answer 7

I was really not sure about the answer and it was hit in the dark. Definitely learned something today. Thanks Steve. 🙂

TomThomson SSC Guru Points: 104773 More actions · Answer 8

Good question.

Given that this limitation is easily evaded, as a couple of comments have pointed out, I agree that it is a drawback as suggested in teh explanation, because it is simply an inconvenience which provides nothing useful. However, if it were properly enforced it might actually be useful - I'm not sure whether it would or not, because I really know pretty well nothing about central Server Management Groups, but I thinnk I can imagine a case where it might be desirable to give people some privileges on the servers in a group but not have those privileges extend to the central server; of course I could be wrong in imagining that.

Tom

jfgoude SSCrazy Points: 2586 More actions · Answer 9

jfgoude

SSCrazy

Points: 2586

January 3, 2014 at 1:09 am

#1677133

never used it and will probably never use it