SQL Error - Urgent

[Purnima Singhal]

Hi,

We are using SQL 6.5 and maintaining a application written in Delphi 3.0. While executing the one of the stored procedure(Cover period) we are getting following error msg:

"Unable to create Query Error in Calculating Cover period General SQL Error. Can't allocate space for object '-333' in database 'tempdb' because the 'system' segment is full" with a warning "Fatal Error 1510 occured"

We have increased the space for DB, but still we are getting the same problem.

We would appreciate, if you respond asap

Regards

[Ivo]

I think you have to expand space for database tempdb. It should help you. If problem persists, you could try to rewrite query so that don't use big temporary tables or big cursors.


------------
Purnima Singhal at 8/22/01 1:25:22 AM

Hi,

We are using SQL 6.5 and maintaining a application written in Delphi 3.0. While executing the one of the stored procedure(Cover period) we are getting following error msg:

"Unable to create Query Error in Calculating Cover period General SQL Error. Can't allocate space for object '-333' in database 'tempdb' because the 'system' segment is full" with a warning "Fatal Error 1510 occured"

We have increased the space for DB, but still we are getting the same problem.

We would appreciate, if you respond asap

Regards

[Ivo]

I think you have to expand space for database tempdb. It should help you. If problem persists, you could try to rewrite query so that don't use big temporary tables or big cursors.


------------
Purnima Singhal at 8/22/01 1:25:22 AM

Hi,

We are using SQL 6.5 and maintaining a application written in Delphi 3.0. While executing the one of the stored procedure(Cover period) we are getting following error msg:

"Unable to create Query Error in Calculating Cover period General SQL Error. Can't allocate space for object '-333' in database 'tempdb' because the 'system' segment is full" with a warning "Fatal Error 1510 occured"

We have increased the space for DB, but still we are getting the same problem.

We would appreciate, if you respond asap

Regards