You can determine what version SQL Server is running by running
Select @@version
Laptop Battery @@Version is a system level variable that holds the current version. On my computer this returns
Microsoft SQL Server 2000 - 8.00.384 (Intel X86) May 23 2001 00:02:52 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
Errata Description Chapter (PDF) Table of Contents (PDF) Index (PDF) Author Information Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced.
Thinkpad The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1. See below for a complete list of versions. It will also tell us the version of the operating system we're running. In this case I'm running Windows 2000 (aka NT 5.0) Service Pack 2. You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties. The version information is displayed in the General tab.
Get all the benefits of Microsoft SQL Server 7 with none of the headaches. in wizards, the Enterprise Manager, and the Query Analyzer. use stored procedures, save time by automating common tasks with Jobs and Alerts, import and export data to and from an SQL Server database, and keep your data secure and backed up with the tips, tricks, and techniques you'll discover inside Microsoft SQL Server 7 For Dummies. have SQL Server tools, too, including programs for automatically building multitier applications, creating SQL Server objects, friendly Visual Basic code.
Microsoft This information is pulled from the system extended procedure xp_msver. You can call this stored procedure like
exec master..xp_msver
sqlservr.exe is the main executable relating to Microsoft's SQL Server Suite. This server application provides industry standard and flexible SQL server services. This program is important for the stable and secure running of your computer and should not be terminated. Check that sqlservr.exe is stable on your computer.
Laptop Computers and it returns
Index Name Internal_Value Character_Value ------ -------------------------------- -------------- ------------------------------ 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 524288 8.00.384 3 Language 1033 English (United States) 4 Platform NULL NT INTEL X86 5 Comments NULL NT INTEL X86 6 CompanyName NULL Microsoft Corporation 7 FileDescription NULL SQL Server Windows NT 8 FileVersion NULL 2000.080.0384.00 9 InternalName NULL SQLSERVR 10 LegalCopyright NULL 1988-2000 Microsoft ... 11 LegalTrademarks NULL Microsoft is a registered ... 12 OriginalFilename NULL SQLSERVR.EXE 13 PrivateBuild NULL NULL 14 SpecialBuild 25165824 NULL 15 WindowsVersion 143851525 5.0 (2195) 16 ProcessorCount 1 1 17 ProcessorActiveMask 1 00000001 18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM 19 PhysicalMemory 255 255 (267902976) 20 Product ID NULL NULL
Furthermore, 'While from an architectural and technical implementation perspective DTS is independent from SQL Server, from a licensing perspective, DTS (as well as any of the other redistributable components packaged with SQL Server) must be part of an application that works in conjunction with SQL Server. While this means that SQL Server must be one of the components in your application, it doesn t mean that your DTS components need to be run from the same physical machine.'
Laptop Computer This is quite a bit of additional information. There really isn't anything exiciting in here that I can find but it's there if you need it. SQL Server Versions
Computer memory is the quickest, cheapest, and easiest way to improve the performance of your system. Find RAM memory upgrades for desktops, laptops, servers, and printers all backed by a lifetime warranty and guaranteed compatible with your computer. Shipping is an everyday low price of $1.99! Computer Memory Outlet sells memory compatible with all leading computer manufacturers like Dell, Apple, Compaq, HP, Sony, IBM, Lenovo, and many more.”
Desktop Computer @@Version SQL Server Version Released 6.50.201 SQL Server 6.5 RTM 6.50.213 SQL Server 6.5 with Service Pack 1 6.50.240 SQL Server 6.5 with Service Pack 2 6.50.258 SQL Server 6.5 with Service Pack 3 6.50.281 SQL Server 6.5 with Service Pack 4 6.50.415 SQL Server 6.5 with Service Pack 5 6.50.416 SQL Server 6.5 with Service Pack 5a 7.00.623SQL Server 7.0 / MSDE 1.0 RTM 7.00.699SQL Server 7.0 SP1July 1999 7.00.842SQL Server 7.0 SP2March 20th, 2000 7.00.961SQL Server 7.0 SP3December 15th, 2000 7.00.1063SQL Server 7.0 SP4 8.00.194SQL Server 2000 RTM 8.00.384SQL Server 2000 SP1 8.00.534SQL Server 2000 SP2November 30th, 2001 8.00.760SQL Server 2000 SP3 Analysis Services
Notebooks You can determine the OLAP version by starting the OLAP Manager. Click on the Servers node in the tree view and click on About Microsoft SQL Server OLAP Services. The versions are listed below:
Help AboutSQL Server OLAP Services version 7.0.1073SQL Server 7.0 OLAP RTM 7.0.1295OLAP Services SP1 7.0.1458OLAP Services SP2 7.0.1508OLAP Services SP3 8.0.194 SQL Server 2000 Analysis Services RTM 8.0.382 Analysis Services SP1 8.0.532 Analysis Services SP2
