I have a situation, I am trying to run almost 100 update statement on a table say 'XX'
In SQL Server database. But it is giving me an error tat goes something like this...
"Could not allocate space for object 'dbo.XX'.'PK_XX_3489AE06' in database 'MYDATABASE' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to th开发者_Python百科e filegroup, or setting autogrowth on for existing files in the filegroup."
Please advice me what to do... Thankx in advance
Check to see if your database has auto growth enabled.
Make sure you have available space on disk where your database file is located.
精彩评论