How to find out your SQL Server version?
Here’s a quick trick the will allow you to easily retrieve information about the Microsoft SQL Server version that you are currently running. This quick how-to was written using SQL Server 2005, but it’s applicable to SQL Server 2000 as well.
- Login to the Microsoft SQL Server Management Studio (Query Analyzer in SQL Server 2000)
- Click New Query
- Type and Execute the following SQL command:
SELECT SERVERPROPERTY (’productlevel’) as ‘Product Level’, SERVERPROPERTY(’productversion’) as ‘Product Version’, SERVERPROPERTY (’edition’) as ‘SQL Server Edition’
A complete map of SQL Server product Level and Product Versions can be found at the bottom of this page.
Looking for tech support? Need detailed info on tweaking your Windows XP or Vista? Leave me a comment and have your question answered here at EasyTweaks.com!
Other useful related answers:
- How to know which Vista version do I run ?
- How to search for friends on facebook?
- Privacy
- Firefox Addon - Resurrect Pages
- How to find applications on Facebook?
Filed Under How Tos
Comments
Leave a Reply