Gooooooooooooooood Morning everyone I just wanted to hop on quick and confirm an answer to a question I had after my session @ TechDays here in Edmonton. Q: Can an express edition of SQL Server 2008 be used as a Central Management Server A: Yes… wait a sec… I think so…. yes… Check my blog [...]
Posts Tagged ‘Central Management Server’
Most Recent Job Status of All Enabled Jobs
Seems easy enough… and maybe it is easy and someone is going to comment with something fantastical *hint hint hint* but until that happens… I would like… if I may… to take you on a strange journey Use Case: I want to be able (using CMS- Central Management Server) connect to all my SQL Servers (2000, [...]
SQL 2008 CMS Security
So we’ve recently adopted the use of SQL Server 2008′s Central Managment Server for our development team. Something that tends to get missed or not talked about in articles about CMS is the security required to connect and view the Central Management Server. There are 2 MSDB database roles that relate to the Central Managment [...]
