Aug 02, 2019 This article describes how to determine your current Microsoft SQL Server version number and the corresponding servicing or service pack level. It also describes how to determine which specific edition of SQL Server you are using. 942177 How to determine the version of SQL Server Integration Services. Check the version of SQL Server. Nov 07, 2016 To check the ODBC SQL Server driver version (32-bit ODBC) In the ODBC Data Source Administrator, click the Drivers tab. Information for the Microsoft SQL Server entry is displayed in the Version column.
By: K. Brian Kelley | Updated: 2011-12-13 | Comments (8) | Related: 1 | 2 | 3 | More >SQL Server Configurations
For instance, if you looking for a Y8 game that may advance your skills you have to search for Y8 games here. The gaming resource is able to provide you with everything what your entertainment needs are requesting. We have to mention that these online Y8 games are the best means for entertainment for people from across the world.
![]()
Stuffit for mac. Aug 26, 2016 StuffIt Expander supports a number of file formats, including ZIP, ZIPX, 7ZX, RAR, and TAR. The StuffIt Expander interface is clean, allowing you to create archives by the usual drag-and-drop. If you use Stuffit Expander for decompressing archives on your Mac, then you'll probably like StuffIt (formerly Stuffit Standard) which is the most widely used archive utility on Mac. Although there are now several other options out there, StuffIt has certainly been around as long as any and is a powerful tool for anyone that works with multiple file formats.
Problem
I was recently trying to determine what version of SQL Server was installed on a particular server. I found this tip to determine the version and tried to execute the code in the command. However, I do not understand what all the information means. Could someone explain it? Check out this tip to learn about the SELECT @@VERSION command in SQL Server.
Apr 19, 2017 By following this path –%programfiles%Microsoft SQL Server90DTSBinn you will find the required file. By right-clicking on the Properties, you can select the Version tab and view the number. By right-clicking on the Properties, you can select the Version tab and view the number. Looking at the first line of the output, the first thing we can determine is the version of SQL Server: 'Microsoft SQL Server 2008' in this example. If the SQL Server has been updated with a SQL Server service pack, then next to the version you should see the service pack level.
How To Check Database Version SqlSolution
Here is the code that I ran from the tip:
Query To Check Ms Sql Server Version
Let's look at the output of this query on a particular SQL Server. You'll see it below:
Looking at the first line of the output, the first thing we can determine is the version of SQL Server: 'Microsoft SQL Server 2008' in this example. If the SQL Server has been updated with a SQL Server service pack, then next to the version you should see the service pack level. Here, we know this server has had SQL Server 2008 SP3 applied since we see '(SP3)' in the output. If you see (RTM), then you know that no SQL Server-related service pack has been installed. RTM stands for release-to-manufacturing , which means when the product is first released.
Then there is a set of four numbers in the format of A.B.C.D. In this case, it's 10.0.5500.0. The first two numbers (10.0) tell us the numeric version of SQL Server. Going back to SQL Server 2000, we have the following versions, as of the writing of this tip:
The last half of that set of four numbers corresponds to the build of SQL Server at that version and service pack. The best resource to match up what has been installed on your SQL Server compared to the version you're receiving back is the SQL Server Version Database at SQLSecurity.com. 5500.0 is SQL Server 2008 SP3 with no cumulative updates or hotfixes according to the database.
After determining the specific configuration using the version database, the only thing remaining on the first line is '(X64)'. This last piece of information tells us what version of SQL Server is running with respect to chip architecture. It is entirely possible to run a SQL Server x86 installation on an x64 system. Whatever the case, if you see (X86), that tells you that the x86 version of SQL Server was installed.
The middle two lines contain information on when the SQL Server was compiled as well as the copyright notice for SQL Server itself. There's not a whole lot to glean here, so let's take a look at that last line. The first thing we see is the edition of SQL Server. In this example, that would be 'Developer Edition.' Some features are limited due to edition. For instance, Developer Edition is a specially licensed edition of SQL Server that allows you to test and use Enterprise Edition features on, say, a development workstation running Windows 7. Developer Edition is never to be used for a production server. To do so would be a violation of the licensing agreement. Knowing what version of SQL Server is important. Knowing what edition of SQL Server for that version is equally important.
After that we see confirmation that it is running the 64-bit version of SQL Server. It then tells us the operating system. Windows NT 6.1 corresponds to Windows 7. So this particular SQL Server is running on a workstation. We're then told if the OS is 32 or 64-bit. In this case, it's 64-bit. Finally, we see the build and the service pack version.
This last bit of information is often confused with the SQL Server version. Folks see the 'Service Pack 1' and think that means they are running a version of SQL Server with SQL Server Service Pack 1 applied. The service pack version for SQL Server is always going to be on the first line. The service pack version after the operating system corresponds to the OS. So we're not just running on Windows 7, but Windows 7 SP1.
Putting all of this together, from the query we can conclude that we are running SQL Server 2008 SP3 Developer Edition (64-bit) on the 64-bit version of Windows 7 SP1. We could dig in to see if a cumulative update or hotfix was applied on the SQL Server side by taking that four part number (in this case we've already done so with 10.0.5500.0) and comparing it with the version database if that's necessary.
Next Steps
Last Updated: 2011-12-13 Check Mssql Server Version LinuxAbout the author
K. Brian Kelley is a SQL Server author and columnist focusing primarily on SQL Server security.
View all my tips
Related Resources Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |