Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
brijesh_raja
Starting Member
1 Post |
 Posted - 2012-05-09 : 07:05:55
|
| Hi, We are getting below mention error. Please can you provide some suggestion. SQLState = 37000, NativeError = 1105Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Could not allocate space for object 'dbo.SORT temporary run storage: 141186742222848' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.SQLState = S1000, NativeError = 0Error = [Microsoft][SQL Server Native Client 10.0]Unable to resolve column level collationsThanks,Brij |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-05-11 : 18:47:56
|
| Your TempDB database has used up its allowable disk space. Either the database file(s) in the PRIMARY filegroup are limited in size or the drive that the file resides on has run out of space. Right click the TempDB in management Studio -> Properties -> Files. See if Autogrowth is Restricted. If it is, you can consider making it Unresticted. You may have a valid reason to keep it Restricted. While you are there see where the files are located and see if that drive has run out of space. If it has, delete some unwanted files, if possible. If neither of these is possible, you can add additional files to TempDB on another drive where space is available.HTH=================================================There is a foolish corner in the brain of the wisest man. -Aristotle, philosopher (384-322 BCE) |
 |
|
|
|
|
|
Getting Space issue