difference between Standard and Workgroup editions in MSSQL Server 2008 R2 [Resolved]

Posted by Yrajudba under Sql Server on 9/26/2011 | Points: 10 | Views : 6319 | Status : [Member] | Replies : 2
Hi,

Any body can describe difference between Standard and Workgroup editions in MSSQL Server 2008 R2 and about their licenses.
i need to update to my client.
Please let me know ASAP

Thanks in Advance

Raju




Responses

Posted by: Yrajudba on: 10/3/2011 [Member] Starter | Points: 25

Up
0
Down

Resolved
HI Jitendra,

Thanks a lot

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jeetmcts on: 10/2/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Raju,

Please find below differences:-

Standard:-

SQL Server Standard edition includes the core database engine, along with the stand-alone services. It differs from Enterprise edition in that it supports fewer active instances (number of nodes in a cluster) and does not include some high-availability functions such as hot-add memory (allowing memory to be added while the server is still running), and parallel indexes.

Workgroup:-

SQL Server Workgroup Edition includes the core database functionality but does not include the additional services.

Licence:-

SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

Hope this will help

Cheers,
Jitendra

Jitendra Kumar

Yrajudba, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response