July 6, 2007 at 8:42 am
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
John Mac Pherson
Database Administrator
Optimal Information Systems Pty (Ltd)
jmacpherson@ois.co.za
July 6, 2007 at 9:02 am
One difference that I'm aware of, and I believe it's still the case, is that the feature pak add-on for SQL 2000 DTS packages in the SQL 2005 environment is not available in x64. Which means that any existing DTS processes (if you have any) would need to be converted to SSIS on your x64 box.
July 10, 2007 at 1:32 am
Hi all
There is an error in BOL, Microsoft have acknowledged that and have requested the 2 changes to be made.
Quote (From MSDN thread I started):
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.
Thought I would let everyone know
John Mac Pherson
Database Administrator
Optimal Information Systems Pty (Ltd)
jmacpherson@ois.co.za
July 10, 2007 at 9:04 am
db mail is in 64 bit, i'm using it on enterprise
sql mail will not work and will give you an error message
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply