Q: What version of Microsoft SQL Server rights do I get with System Center 2012 and are there any benefits to using Enterprise?

Analysis Services Files--In SQL Server 2008 Enterprise edition, you can decide where Analysis Services database files will be stored. In the Standard edition, there is only one default location for the files.

Cube Processing--In SQL Server 2008 Enterprise edition, cubes are processed incrementally each night. In the Standard edition, the entire cube is processed each night and therefore, the amount of processing time required will increase as more data is accumulated. Cubes can still be queried when being processed however, reporting performance will be reduced.

Measure Group Partitions--In SQL Server 2008 Enterprise edition, measure groups are partitioned on a monthly basis, instead of as one large partition. This reduces the amount of time it takes to process the partition.

PowerPivot--In SQL Server 2008 Enterprise edition, you can use PowerPivot for SharePoint.