SQL Server 2008 - Build information - Servicing SQL Server 2008 R2 - Build information - Installation SP4 (.0 - September 2017) SP3 (.0 - November 2015) SP2 (.0 - June 2014) SP1 (.00 - November 2012 18 Ive seen this link, but with no help: How can I determine installed SQL Server instances and their versions So here is my question: I want to see what versions of sql are installed on my computer. SQL Server 2012 - Build information - Installation SQL Server 2014 - Build information - Installation SQL Server 2016 - Build information - InstallationĪzure Connect pack (.253 - May 2022) SP3 (.2 - September 2021) SP2 (.0 - April 2018) SP1 (.0 - November 2016) SQL Server 2017 - Build information - InstallationĬU (.2 - September 2022) CU31 + GDR (.9 - February 2023) SQL Server 2019 - Build information - InstallationĬU (.3 - June 2023) CU18 + GDR (.7 - February 2023) SQL Server 2022 - Build information - Installation Latest updates available for currently supported versions of SQL ServerĮach of the following links provides information for all of the applicable products and technologies. You may have to manually filter that down though.For information about SQL Server Support lifecycle, see SQL Server support lifecycle information. If you loop through all your servers and grab all services that start with "MSSQL" you'll have a rudimentary list to start with. In addition, this method may take a significant amount of time to execute, so be careful about calling it when performance is critical.Īnother thing you could consider is to reach out across all of your servers (again, very time consuming) and get all services that contain a known SQL Server string in their name. If you plan to use this function to let users select a server from a list, make sure that you always also supply an option to type in a name that is not in the list, in case the server enumeration does not return all the available servers.
Something to note about this call, and documented in the above reference:ĭue to the nature of the mechanism used by SqlDataSourceEnumerator to locate data sources on a network, the method will not always return a complete list of the available servers, and the list might not be the same on every call. If you want to programmatically find this information, you can make a call to the SqlDataSourceEnumerator.GetDataSources Method: # PowerShell example
0 kommentar(er)
