'PRIMARY' filegroup full error

When adding records that would take a SQL Server
Developer Ed. table over 2 Gb, I receive an error that
says "Could not allocate space for object 'MyTableName'
in database 'MyDb' because the 'PRIMARY' filegroup is
full." What do I need to do to get around this error?
Thanks in advance,
JoeAre you referring the Desktop (MSDE) edition? This is a known
limitation of that edition and there is no workaround.
The Developer edition has no size limitation. You can expand your
database or add additional files to get around the error.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Joe" <joe.murray@.jmaconsulting.biz> wrote in message
news:0fb401c36738$0c3b53b0$a601280a@.phx.gbl...
> When adding records that would take a SQL Server
> Developer Ed. table over 2 Gb, I receive an error that
> says "Could not allocate space for object 'MyTableName'
> in database 'MyDb' because the 'PRIMARY' filegroup is
> full." What do I need to do to get around this error?
> Thanks in advance,
> Joe