Enterprise or not?

Dear ALL,
I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based on
Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL SERVER
2005 Enterprise or standard version could be fine.
Regards
Alberto BrivioStandard will work on a two node cluster but you may loose some other
features you need. Check out the feature comparison in BOL.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||You better determine your needs first...
--
Ekrem Önsoy
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||Alberto,
With SQL2005 the version will depend on the number of CPU's rather than the
memory and of course the features you require. If your server has more than
4 CPU's and you want SQL to use them then you must use Enterprise.
Chris
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>

Enterprise or not?

Dear ALL,
I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based on
Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL SERVER
2005 Enterprise or standard version could be fine.
Regards
Alberto BrivioStandard will work on a two node cluster but you may loose some other
features you need. Check out the feature comparison in BOL.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||You better determine your needs first...
Ekrem nsoy
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||Alberto,
With SQL2005 the version will depend on the number of CPU's rather than the
memory and of course the features you require. If your server has more than
4 CPU's and you want SQL to use them then you must use Enterprise.
Chris
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>

enterprise manager error

Hi,
When trying to modify or add a table using enterprise manager I got this
message error:
Enterprise manager: not enough storage is available to complete this
operation.
I have a lot off space available.
I don't have a memory leake.
My server is Dell PowerEdge 2850 with tho CPU ( 3.6 GHZ)
I Regestred my SQL server 2000 on another enterprise manager in a second
server and I was able to modify the table.
I was able to create a table by using query analyser.
Could someone help me find the bug?
Using EM to modify live tables is never a good idea. It often will create a
new table, copy all the rows over to the new table and then drop the old
one. So it must have at least as much space available in the db as the
table being modified and its indexes. But that does not explain why EM
worked on the other machine.
Andrew J. Kelly SQL MVP
"sql server 2000 enterprise manager" <sql server 2000 enterprise
manager@.discussions.microsoft.com> wrote in message
news:92AC93CE-7CAD-4F79-A92C-1B2B0B08B3CD@.microsoft.com...
> Hi,
> When trying to modify or add a table using enterprise manager I got this
> message error:
> Enterprise manager: not enough storage is available to complete this
> operation.
> I have a lot off space available.
> I don't have a memory leake.
> My server is Dell PowerEdge 2850 with tho CPU ( 3.6 GHZ)
> I Regestred my SQL server 2000 on another enterprise manager in a second
> server and I was able to modify the table.
> I was able to create a table by using query analyser.
> Could someone help me find the bug?
|||Hi, Andrew,
I beleive that using Enterprise manager is not the best choice. but my
issue occurs even when I try to modify a small database as northwind or pubs.
"Andrew J. Kelly" wrote:

> Using EM to modify live tables is never a good idea. It often will create a
> new table, copy all the rows over to the new table and then drop the old
> one. So it must have at least as much space available in the db as the
> table being modified and its indexes. But that does not explain why EM
> worked on the other machine.
> --
> Andrew J. Kelly SQL MVP
>
> "sql server 2000 enterprise manager" <sql server 2000 enterprise
> manager@.discussions.microsoft.com> wrote in message
> news:92AC93CE-7CAD-4F79-A92C-1B2B0B08B3CD@.microsoft.com...
>
>
|||Sounds like a client issue then. Haven't seen that before. You can try
reinstalling the client tools but I bet it is an issue with that machine
more than EM.
Andrew J. Kelly SQL MVP
"sql server 2000 enterprise manager"
<sqlserver2000enterprisemanager@.discussions.micros oft.com> wrote in message
news:24AD6EC4-3A53-4D5A-90A2-8F6633C4A5AC@.microsoft.com...[vbcol=seagreen]
> Hi, Andrew,
> I beleive that using Enterprise manager is not the best choice. but my
> issue occurs even when I try to modify a small database as northwind or
> pubs.
> "Andrew J. Kelly" wrote: