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 & 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 & 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
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.