This is probably one of the easiest method to find out SQL server details.
Check SQL server version using SQL server properties 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 Check SQL server version using system extended stored procedure There are many more Server properties which you can get using the ServerProperty query in SQL server, here is the complete list for SERVERPROPERTY 3. 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 Check SQL server version using ServerProperty in query Select = left(cast(serverproperty('productversion') as varchar), 4) You can also use below SQL Query to check sql server version declare numeric(4,2)
HOW DO I GET THE SQL PROMPT WINDOWS
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. Checking SQL server version using various methods
HOW DO I GET THE SQL PROMPT UPGRADE
This is helpful for person like DBA and who want's to upgrade SQL server now, so to upgrade you must first know the current version and details of your service pack, so in that case this article would be helpful for you.Īlthough it shouldn't be difficult for anyone to find details of version but you should know the below listed various easy ways to determine it quickly. In this article, I will provide you the possible ways to find or check Microsoft sql server version, service pack etc installed on your pc/server.
0 kommentar(er)
