sql server msde: Hi.

I've a msde database and I'm getting the following error every minute

Error 1105, Severity: 17, ErrState: 2
Could not allocate space for object 'ProductSettings' in database
'epo_Srv-ms-avd' because the 'Primary' filegroup is full

I've cleanup the database but the error keeps on.

I need urgent help!!!

Thank you very much

hi Eduardo,
"Eduardo Crespo" <crespo_santamaria@NOSPAMhotmail.com> ha scritto nel
messaggio news:OoFIRcmuEHA.1992@TK2MSFTNGP10.phx.gbl
[quoted text, click to view]

in addition to Greg's answer, try executing
EXEC sp_helpdb 'your_db_name'
to see, in the 2nd resultset, if the datafile has limited file maxsize
option set or it can growth till 2gb limit...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Thank you very much. Database size is 2 GB

"Eduardo Crespo" <crespo_santamaria@NOSPAMhotmail.com> escribió en el
mensaje news:OoFIRcmuEHA.1992@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

Hi Eduardo,

How big is the database? Any chance it's up to 2G (ie the limit)?

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]