hi to all i get this error when i going to insert record to my database .
Error code is :
Server: Msg 1105 ,level 17, state 2, procedure sp_userprocedure ,line 9
Could not allocate space for object table_name becuase the priamry file group i full full .
and stops insert new record into table i am using a Query Analyzer to querying db in remote manner and Enterprise Manger to create or altering DB for ease of use how i can avoid of this problem .
any good idea to guide me how i can avoid this type of problem when a databaserunning in a online server and maybe many user can open the site and the data inserts into table and fetch.
Thanx In Advance.
YoOrD.

__________________
       YoOrD .
Beauty is not on the face
Beauty is on the heart
~~<<Ghibran Khalil>>~~

What is the version of SQL you use?

This indicates that

1) Disk is full
or
2) The PRIMARY filegroup is limited in size, and that size limit has been reached.

You got to cleanup your disk for more free space or Add a datafile to the database.

Check this Error 1105

Cheers!

_________________________
- Vijay G
Strive for Perfection

Hi Thanx 4 ur reply .
it clerify some thing that it is a remote server and i have'nt permission to cleaning up disk i can only reach db using remote quey analyzer and enterprise manager tools of sql server if u can or any body give solution that i remotely doing this type of jobs.
if u think i must contact the sql server hosting admin and tell hi/her to this type of jobs to do for me.
thanx for u and other in advance.
YoOrD.

Hi YoOrD,

That should be the right thing to do. You can contact your hosting admin for clearing up space in that disk. But I am not sure how good they would do that for you.

If they are unable to help you on that, then probably you can try shrinking the database and cleanup the unused space so that it doesn't fail to get data inserted.

May be you can take a look at this thread - Shrink Log without SQL service restart However you can take a look at my last post at the bottom of that thread which has steps to clean up space. This needs either SQL service restart or (detatch and attach DB commands) 4th and 5th step in that post, to free up the unused space. But if it is the live DB server, then this would not be the solution you are looking for. May be your hosting admin could help you on that.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

thanx to u for your reply.
it is impossible to deattach db but i can find some documents that help me to guide about every thing about how i remotely configure my db about qouta and transaction log file that not to enlarges more.
i must to mentioned that i am a beginer.
thanx in Advance.
YoOrD.