Register
Home   Ask Question Discuss Purchase Submit Events Give Solutions Share News
Automobiles Beauty & Styles Business Computers & Internet Sports Travel Consumer Electronics Education Entertainment & Music Family Society & Culture Food & Drinks Health
Computer Networking
Hardware
Internet
Programming & Design
Security
Software
Other - Computers
Find Microsoft SQL version and Service pack
-->

Issue: How to use query to find the Microsoft SQL version and Service pack for SQL?

I wanted to know how to find the service pack version installed on my SQL server. I foudn the following query that gives details of it.

Solution:

Open the SQL Management studio and run the below query.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

--
Bookmark and Share
Related Posts
Comments
Add Comment
Name*
Email*
Comment*
Hot Categories: Other - Electronics Personal Finance Security Movies India Community Service Television Hardware
Contact Us About Us Privacy Policy Copyright Sitemap