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?
Determine the service pack for all the SQL Servers using SCCM
service-pack
Related Question
- SQL Server 2012 – Cluster Service Pack 3 Fail to Failover Node
- Sql-server – How to determine the service pack of Sql Server
- SQL Server – Upgrading from 2008 R2 SP1 to SP3
- Sql-server – Upgrading SQL Server 2012 from SP2 to SP3
- SQL Server – Service Pack Questions
- Sql-server – Apply the latest Service Pack and Cumulative Update
Best Answer
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
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.