0

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?

2
  • I'm voting to close this question as off-topic because it is only indirectly database related. This is a question about the capabilities of SCCM in regards to SQL Server and would probably be better asked on serverfault.com under the tag sccm. If this question can be formulated to be on-topic, then please edit your question accordingly.
    – John K. N.
    Jan 9 '20 at 7:27
  • I disagree - it's a question about checking service packs on an RDBMS which is an important thing for a DBA to know! Jan 9 '20 at 12:00
2

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.