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 2000 Forums
 SQL Server Development (2000)
 Stored Procedure Execution Error

Author  Topic 

satishbeh
Starting Member

3 Posts

Posted - 2005-09-04 : 13:54:27
I am executing a Stored Procedure which has start date and end date as parameter every month. For example I give start date to be the first day of the month and the end date to be the last day of the month.
Now when I execute the stored procedure I get the following error message:
"EXTENT CHAIN FOR OBJECT 1026870775 IS NOT CORRECTLY LINKED. SQL SERVER IS TERMINATING THE PROCESS"

The Stored procedure works when I execute for each day separately
ie '01/08/2005','01/08/2005'
'02/08/2005','02/08/2005'
'03/08/2005','03/08/2005'

When I execute the same for the following date:
'01/08/2005','03/08/2005'
I get the same error.

Can any one help me how I can overcome the above error message

I am using SQL Server 6.5version
Satish

nr
SQLTeam MVY

12543 Posts

Posted - 2005-09-04 : 15:37:35
Double post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54767

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -