no enough space on tempdb - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

no enough space on tempdb

Author

Topic

shwetamber
Starting Member

1 Post

Posted - 2009-08-04 : 05:42:21

Hi

I am executing a query which have fetch above 50,000 records in cursor. But before complete the execution I found the error no enough disk space error.
Whereas my C drive has 2 GB free space.

Can anyone help me about this problem

Thanks

Shwetamber Chourey

jagpro
Starting Member

1 Post

Posted - 2009-08-04 : 11:30:38

Hi,

Please check your tempdb size.
Increasing the tembdb size may solve your problem.

USE master;
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = 'tempdev', SIZE = 50MB);
GO

Please refer this:
http://www.sqlhacks.com/index.php/Optimize/IncreaseSizeTempdb

-Jagpro

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2009-08-04 : 11:49:57

why are you using a cursor. What are you doing?

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION

kishore_pen
Starting Member

49 Posts

Posted - 2009-08-06 : 05:35:36

Avoid using cursors. Use some other way to do.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources