Ask limitation about SQL server

Hi, Any one can tell me is it true that:
The SQL Server in Windows Small Business Server 2003 Premium Edition have a
limitation on building a database can not bigger than 10G. It is difficult t
o find such info. in MS web site.
Please help, thanks a lot.
TONo, SBS has the same size limitation as SQL Server 2000 (~1 million TB).
However, you are limited to two physical processors and 4 GB RAM.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"TO" <anonymous@.discussions.microsoft.com> wrote in message
news:E5355930-B0C9-434A-B77F-2CA80676D995@.microsoft.com...
> Hi, Any one can tell me is it true that:
> The SQL Server in Windows Small Business Server 2003 Premium Edition have
a limitation on building a database can not bigger than 10G. It is difficult
to find such info. in MS web site.
> Please help, thanks a lot.
> TO|||I only got as far as 475,000 TB and my machine choked.
LOL.
James Hokes
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%230bO5oz$DHA.2348@.TK2MSFTNGP09.phx.gbl...
> No, SBS has the same size limitation as SQL Server 2000 (~1 million TB).
> However, you are limited to two physical processors and 4 GB RAM.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "TO" <anonymous@.discussions.microsoft.com> wrote in message
> news:E5355930-B0C9-434A-B77F-2CA80676D995@.microsoft.com...
have
> a limitation on building a database can not bigger than 10G. It is
difficult
> to find such info. in MS web site.
>

ARITHABORT

Help!!!
When attempting an insert to a table in SQL I get a message indicating that
the ARITHABORT setting is incorrect. Running (select databasepropertyex db,
'isarithabortenabled') returns null.
Running (alter database 'db' set arithabort off) doesn't change the setting.
I've tried setting it on and off, but the check always returns NULL.
Isn't there someway to set this value to 0 directly?
If anyone can help me I'd truly appreciate it. The table affected is the
primary table in the database and therefore, my db system is DOWN and
inoperable!!
Thanks.
Ross
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.592 / Virus Database: 375 - Release Date: 2/18/2004Try:
SELECT DATABASEPROPERTYEX('MyDatabase', 'IsArithmeticAbortEnabled')
Note that ARITHABORT must be *ON* when updating a table with an indexed view
or index on computed column.
Hope this helps.
Dan Guzman
SQL Server MVP
"Ross Culver" <rculver@.alliant-solutions.com> wrote in message
news:Ox%235GRW$DHA.3804@.TK2MSFTNGP09.phx.gbl...
> Help!!!
> When attempting an insert to a table in SQL I get a message indicating
that
> the ARITHABORT setting is incorrect. Running (select databasepropertyex
db,
> 'isarithabortenabled') returns null.
> Running (alter database 'db' set arithabort off) doesn't change the
setting.
> I've tried setting it on and off, but the check always returns NULL.
> Isn't there someway to set this value to 0 directly?
> If anyone can help me I'd truly appreciate it. The table affected is the
> primary table in the database and therefore, my db system is DOWN and
> inoperable!!
> Thanks.
> Ross
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.592 / Virus Database: 375 - Release Date: 2/18/2004
>