SQL 2005 Licensing

[woodings]

Please could someone tell me the difference between an SQL 2005 Standard and Enterprise Licence.

we have a server which has been built as Windows 2003 Enterprise - it has 8GB memory and quad core processor but SQL 2005 Standard has been installed

 

[bborissov]

http://www.microsoft.com/sql/howtobuy/licensing.mspx

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

http://www.microsoft.com/sql/editions/standard/sysreqs.mspx

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[woodings]

Thanks for this but Im trying to find out server memory of processor limitations that apply to SQL Licencing

 

[bborissov]

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[mrdenny]

Both the standard edition and Enterprise edition can use all the RAM in the server. The limit is based on the hosting operating systems limit. SQL 2005 Standard supports 4 physical CPUs (it doesn't matter how many cores those processors have the limit is based on the number of physical CPUs).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog