FILEGROUP Ful;l ...

I am aware that a Full Filegroup will prohibit INSERTS
into the DB BUT ... Will this also prevent UPDATE and
DELETE operations?
ThanksIt won't prevent DELETE. It might prevent UPDATE if:
The update need to allocate more space on some page (if you expend a column
so it won't fit on the old page so the update need to be performed
internally as a delete followed by an insert).
There is no page with free space to hold the new to of the pages that the
table is currently using.
There is no extent with free pages of the extents that the tables is using.
There are no un-allocated extents in the filegroup.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Jay Kusch" <Jay.Kusch@.mm-games.com> wrote in message
news:145c201c3fa0b$36ff9690$a301280a@.phx.gbl...
> I am aware that a Full Filegroup will prohibit INSERTS
> into the DB BUT ... Will this also prevent UPDATE and
> DELETE operations?
> Thanks
>
>