SQL Server Performance Forum – Threads Archive

Stored Procedure Execution Error

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.5 version Satish

Post the code you used in the stored procedure Madhivanan Failing to plan is Planning to fail

Seems you want to read up on DBCC CHECKDB and plan to run it, possibly with the repair option.
But first you would want to search KB (etc) for the error numbers that you get to see if you can
find any tips. You might want to consider opening a case with MS PSS, deepening on if you find
your data worth it….

[<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] you’ve got same response<a target="_blank" href=http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54767>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54767</a> here too. <hr noshade size="1">Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum</a> <center>This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.</center>

]]>