![]() Right click the file and click Properties.Navigate to C:\Program Files\Microsoft SQL Server\YourServer.SQLExpress\MSSQL\Binn (in my case it was C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS2\MSSQL\Binn).In this method we will check SQL server version through sqlservr properties.Here is the list of procedure you need to follow in this way to get all the details This is probably one of the easiest method to find out SQL server details. Provide me lots of information in single query This is another good method which returns all the details of your SQL server version, try executing the master database stored procedure, in my case it was located in System database-> master -> Programmability -> sys.sp_server_infoĮxecuting this stored procedure, as below exec _server_info There are many more Server properties which you can get using the ServerProperty query in SQL server, here is the complete list for SERVERPROPERTYģ. ![]() Output will be in tabular form with specific details which we have selected in the above queryĬomputerName InstanceName Edition ProductVersion ProductLevelĭESKTOP-1PM1CJ9 DESKTOP-1PM1CJ9\SQLEXPRESS2 Express Edition (64-bit). SERVERPROPERTY('ProductLevel') AS ProductLevel SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ServerName') AS InstanceName, SERVERPROPERTY('MachineName') AS ComputerName, Well this is another method to determine sql server version in detail running scripts, here is the sample script which you can run your SQL server Management studio SELECT Select = left(cast(serverproperty('productversion') as varchar), 4) You can also use below SQL Query to check sql server version declare numeric(4,2) 60 (X64)Įxpress Edition (64-bit) on Windows NT 6.2 (Build 9200: )Īs you can see in the above image we are getting complete details of our SQL server version which is 2012, it is 64-bit version. ![]() Start your SQL server management studio, connect to the server and right-click on your Server, click "New Query", and excute the below query SELECT must be as below Microsoft SQL Server 2012. Now, I will explain possible ways to determine sql server version and service pack, let's get started with it. Using the Windows Command Prompt (CMD)Ĭhecking SQL server version using various methods Checking SQL server version using various methods.
0 Comments
Leave a Reply. |