SQL express-solving 4GB size limit by multiple database files?

[orenbt]

Hi,

I am new to SQL express and try to solve the 4GB size limitation.
Is there a possibility to create a new database file every time I get
to the limit?
How can I do that with C#? how can I create new database file every
time it gets full?
Can I be connected to two database files at the same time (the full db
and the new db)?

thanks in advance,
oren

[David Portas]

orenbt wrote:

Hi,

I am new to SQL express and try to solve the 4GB size limitation.
Is there a possibility to create a new database file every time I get
to the limit?
How can I do that with C#? how can I create new database file every
time it gets full?
Can I be connected to two database files at the same time (the full db
and the new db)?

thanks in advance,
oren

The 4GB limit applies to the total size of the database so creating
extra files won't help. You would need to create a new database. You
can issue a CREATE DATABASE command using ADO, DMO, etc.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/m...S,SQL.90).aspx
--