4GB size limtation on SQL server express

Hi,

I would like to know what problems will occur when I try to create a database that exceed the size limit of 4GB ?

Thanks

Moving to the SQL Server Express forum.|||SQL Server will provide an error message and the attempt to create a database exceeding 4GB will fail.|||

hi,

as Arnie already pointed out, SQLExpress will throw an exception..

this exception is little misleading as it reports
Server: Msg 1105, Level 17, State 2, Line 6
Could not allocate space for object 'a' in database 'test' because the 'PRIMARY' filegroup is full.

I do actually think another exception should be raised, something like
Err 1827: CREATE/ALTER database failed becouse the resulting cumulative database size would exceed your licensed limit of xxxx mb per database.

but this is another story
regards