2GB Limit in MSDE 2000

I have a database that has reached the MSDE 2GB limit.
I have tried running the sp_spaceused command and I can't see how the
results equalls 2GB
Can someone explain what values are used by MSDE to determine that the
database has reached the 2GB limit?
Sp_SpaceUsed Resuls:
Database Size 1903.38MB
Unused 0.16MB
Reserved 1947864KB
Data 1038296KB
Index Size 204584KB
unused 704984KB
Hi
Database Size 1903.38MB
If you have it set to 100Mb autogrow, it can't grow any more as it would
exceed 2GB.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"azar" <azar@.discussions.microsoft.com> wrote in message
news:8FBCCD5B-F8C7-4F91-8CCB-F94A1151BD8D@.microsoft.com...
>I have a database that has reached the MSDE 2GB limit.
> I have tried running the sp_spaceused command and I can't see how the
> results equalls 2GB
> Can someone explain what values are used by MSDE to determine that the
> database has reached the 2GB limit?
> Sp_SpaceUsed Resuls:
> Database Size 1903.38MB
> Unused 0.16MB
> Reserved 1947864KB
> Data 1038296KB
> Index Size 204584KB
> unused 704984KB
|||What are you storing in the database that has pushed it to this limit?
Pictures? Documents?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"azar" <azar@.discussions.microsoft.com> wrote in message
news:8FBCCD5B-F8C7-4F91-8CCB-F94A1151BD8D@.microsoft.com...
>I have a database that has reached the MSDE 2GB limit.
> I have tried running the sp_spaceused command and I can't see how the
> results equalls 2GB
> Can someone explain what values are used by MSDE to determine that the
> database has reached the 2GB limit?
> Sp_SpaceUsed Resuls:
> Database Size 1903.38MB
> Unused 0.16MB
> Reserved 1947864KB
> Data 1038296KB
> Index Size 204584KB
> unused 704984KB