Missing Features In Standard Edition X64?

Hi all

In BOL in the features per version section it states that certain features available in the 32-bit version of Std Edition is not available in the 64-bit version. Eg. Database Mail, Query Editor, Query Designer etc.

I have downloaded the latest BOL (May 2007) and installed it and it still says certain features are not available in X64.

However I configured Database Mail on Std Edition X64 and it works 100%. Had some issues with SQLAgent using it but Service Pack 2 solved the problem.

Query Editor and Designer works even though Microsoft says it isn't available.

Is there any difference in the tools or features available in Std Edition 32-bit or 64-bit?

My other concern is what has Microsoft said is available and isn't?

From my tests I can't see anything missing. We are about to go purchase software and licenses and don't want to make the wrong choice.

Thanks
John

Currently, there are not 64 bit client tools pubically available to use with 64 bit SQL Server.

The 32 bit tools work just fine.

You most likely have installed and are using the 32 bit client tools.

|||

The following page in Books on Line is in error.

http://msdn2.microsoft.com/en-us/library/ms143761.aspx

I have submitted two requests for changes:

1. Remove the standard edition 64 bit column from the management tools section, and update the header of the SE 32 column to include SE 64. This says that tools features are the same in 32 and 64 bit.

2. SQL Mail is available only in 32 bit installations. DB Mail is available in 32 and 64 bit installs, whether they are standard or enterprise.

Thanks for pointing this out. I hope we can spare you further confusion.

jkh

|||

Thanks for getting back to me and clearing up the confusion.

Regards

John