1.pls check the tempdb size,and set automatically grow . 2.DBCC SHRINKDATABASE('db_name') GO BACKUP TRAN db_name WITH TRUNCATE_ONLY GO 3.In Enterprise Manager right click on the database, choose properties, select the data files tab and see if the automatically grow file option is checked 4.restart MSSQLSERVER service. 5.recreate primary key.
2.DBCC SHRINKDATABASE('db_name')
GO
BACKUP TRAN db_name WITH TRUNCATE_ONLY
GO
3.In Enterprise Manager right click on the database, choose properties, select the data files tab and see if the automatically grow file option is checked
4.restart MSSQLSERVER service.
5.recreate primary key.