Primary file group full

I have inherited a SQL server 2000 DB where the system and user tables
are separated into different mdf files (on separate drives). The
primary file group is the system data. I have a query that is
returning data from a remote DB table which is not in the local DB
table. I am running to the problem that as the query is running the
primary file group is now full. I have rebuilt the indexes and run a
shrink of the db, but still the file group is full. I have auto
growth enabled to unrestricted, but am getting an ERROR 1827. Any
help is greatly appreciated!
Daniel
Hi
And do you have enough space on the disk? I have seen such errors , it
could happen what the database tried to grow and while it is growing (writes
zeroes to the pages) users get the error.
"danielp" <danielsmith611@.gmail.com> wrote in message
news:1172157667.706350.173350@.q2g2000cwa.googlegro ups.com...
>I have inherited a SQL server 2000 DB where the system and user tables
> are separated into different mdf files (on separate drives). The
> primary file group is the system data. I have a query that is
> returning data from a remote DB table which is not in the local DB
> table. I am running to the problem that as the query is running the
> primary file group is now full. I have rebuilt the indexes and run a
> shrink of the db, but still the file group is full. I have auto
> growth enabled to unrestricted, but am getting an ERROR 1827. Any
> help is greatly appreciated!
> Daniel
>