Stored Procedure Execution Error


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Stored Procedure Execution Error

  1. #1
    Join Date
    Apr 2005
    Posts
    3

    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

  2. #2
    Join Date
    Nov 2003
    Location
    Portland, OR
    Posts
    8,387
    Phil Weber
    http://www.philweber.com

    Please post questions to the forums, where others may benefit.
    I do not offer free assistance by e-mail. Thank you!

Similar Threads

  1. Replies: 1
    Last Post: 08-23-2005, 09:58 AM
  2. Oracle Stored Procedure for trimming table
    By Saiful in forum Database
    Replies: 1
    Last Post: 05-02-2001, 07:35 AM
  3. Syntax Error in stored procedure
    By Asher Khan in forum Database
    Replies: 1
    Last Post: 01-08-2001, 05:51 PM
  4. Winsock32, Connect fails to connect to a peer
    By Chris.G in forum VB Classic
    Replies: 4
    Last Post: 11-13-2000, 04:16 PM
  5. Command Line execution of a Stored Procedure?
    By Kristin Piskulic in forum Database
    Replies: 1
    Last Post: 04-05-2000, 12:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center