Check your SQL Server version and edition

Posted: August 12, 2009 | Author: | Filed under: SQL Server | Leave a comment
If you are wondering about your SQL Server instance’s version and edition, you can run this query:

SELECT SERVERPROPERTY(‘productversion’) as [Product version], SERVERPROPERTY (‘productlevel’) as [Product level] , SERVERPROPERTY (‘edition’) as Edition

,

@@VERSION as VersionInfo

The query result from my SQL Server 2008 instance is (as today):

product version product level Edition AllInfo
10.0.2531.0 SP1 Developer Edition 

Microsoft SQL Server 2008 (SP1) – 10.0.2531.0 (Intel X86)   Mar 29 2009 10:27:29   Copyright (c) 1988-2008 Microsoft Corporation  Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

The version numbers for SQL Server 2005 are:

Product Level Product version
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
SQL Server 2005 Service Pack 2 2005.90.3042
SQL Server 2005 Service Pack 3 2005.90.4035

About green triangle indicator in Excel cells’ upper-left corner

Posted: August 6, 2009 | Author: | Filed under: Excel 2003 | Leave a comment
When I generate excel data report, there are a few result columns with mixed number and text. I define the column as text and the cells include numbers in this column show green triangles at each cell.
If this green triangel bothers you, you can always turn it off from Tools>> Options>>Error checking tab:  Store number stored as text. and click OK. The green triangles will disppear for the column with mixed number and text values.