SQL Server 2008 R2 Express Database Size Limit Increased to 10GB

April 25, 2010

The maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB.

To try it out  – -go to SQL Server 2008 R2 Download Page and select “SQL Server 2008 R2 Express” from the menu on the left side of the page:

http://www.microsoft.com/sqlserver/2008/en/us/R2Downloads.aspx

Advertisements

How to determine which version of SQL Server 2005 is running

July 27, 2009

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

  • The product version (for example, 9.00.1399.06)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise Edition)

For example, the results resemble the following.

 Collapse this table Expand this table
9.00.1399.06 RTM Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table
Release Sqlservr.exe
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

 Source (KB321185)…


How to identify your version of MSDE?

July 23, 2009

Run the following code in Query Analyzer

SELECT @@VERSION

Release Sqlservr.exe
RTM 2000.80.194.0
SQL Server 2000 SP1 2000.80.384.0
SQL Server 2000 SP2 2000.80.534.0
SQL Server 2000 SP3 2000.80.760.0
SQL Server 2000 SP3a 2000.80.760.0
SQL Server 2000 SP4 + KB948110 2000.8.00.2039
SQL Server 2000 SP4 2000.8.00.2050
SQL Server 2000 SP4 + KB960082* 2000.8.00.2055

* KB960082: Patch to resolve security issue identified in the Microsoft SQL Server 2000 Desktop Engine (WMSDE) that could allow an attacker to compromise your Microsoft Windows-based system and gain control over it. After you install this item, you may have to restart your computer.

How to identify your SQL Server version and edition…

SQLWMSDE-KB948110-x86-ENU.exe…


Where do I get the installer for MSDE SP4?

June 25, 2009

Microsoft SQL Server Desktop Engine (MSDE) is a free version of Microsoft SQL Server that is suitable for logging data in smaller networks.

(Microsoft does not support installing MSDE on Windows Server 2008).

Language Link
English http://eval.websense.com/auxiliary/MSDESP4/MSDE-en.zip
Brazilian Portuguese http://eval.websense.com/auxiliary/MSDESP4/MSDE-bp.zip
German http://eval.websense.com/auxiliary/MSDESP4/MSDE-de.zip
Spanish http://eval.websense.com/auxiliary/MSDESP4/MSDE-es.zip
French http://eval.websense.com/auxiliary/MSDESP4/MSDE-fr.zip
Italian http://eval.websense.com/auxiliary/MSDESP4/MSDE-it.zip
Japanese http://eval.websense.com/auxiliary/MSDESP4/MSDE-jp.zip
Korean http://eval.websense.com/auxiliary/MSDESP4/MSDE-ko.zip
Simplified Chinese http://eval.websense.com/auxiliary/MSDESP4/MSDE-sc.zip
Traditional Chinese http://eval.websense.com/auxiliary/MSDESP4/MSDE-tc.zip