>>Yes, unfortunately it's only supported in Enterprise Edition (or Developer's edition) :(
>
>What does the Enterprise Edition give more?
>
The comparison of editions can be found here
http://msdn.microsoft.com/en-us/library/cc645993.aspx>Also, what would be required for me to update to the Enterprise Edition. Do, I have to uninstall everything and reset everything after?
>
You can have different editions of SQL Server installed, but I think it's easier to have just one edition installed. Enterprise edition cost more than Standard.
>With the Standard Edition, I am able to simulate the same environment from the server, which is Windows Server 2003 with SQL Server 2008, and on my PC, which is Windows XP Pro and SQL Server 2008. But, I have some doubts that the server would support the Enterprise Edition but not my PC.
>
>So, in overall, should I only wait until I move to Windows 7 so to be sure that I can have the same environment as the server?
One possibility is to make a backup image of your current state, uninstall Standard Edition, install Enterprise and test.
I did uninstall SQL Server Standard from my Windows 7 and installed Developer's edition of SQL Server.
On your local computer you also can use Developer's edition - you don't need Enterprise installed locally.
If it's not broken, fix it until it is.
My Blog