Can I determine the service pack for all my SQL Servers using SCCM? I'm trying to figure out a way to find out all the service packs for my sql servers. There's about 30+ databases which we hosted &amp; to login to each of the server and check the service pack will going to take some time. Can I use any tools e.g. sccm to crawl into all the sql servers and provide me with the sql versions &amp; it's service packs?
Very quick and easy solution would be to setup a CMS (Central Management Server)
This enables you to run queries on groups of servers.
So if you make a production group, you can run a query on all of them at the same time
Using
SELECT @@VERSION

Would return you all the versions of the group.
If you're managing a bunch of different servers, a CMS is always a very helpful tool.