Index Maintenance - Error

  • Hello Everyone

    I am getting following error when i am performing Index Maintenance on our productin databases. I have checked the Maintenance task report and it is just showing following error and nothing else.

    Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Following is the T-SQL code from Execute T-SQL Statement Task

    DECLARE@return_value int

    EXEC@return_value = [dbo].[sproc_IndexMaintenance]

    has anyone come across anything like this before?

    Any help would be much appreciated.

    Many thanks.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • Have a look at this link

    http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/b7fc33d2-f402-43e9-91a1-ef0049d49554/

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • Thanks for your reply.

    I have tried doing running following statement on production SQL Server but that doesn't resolve the issue.

    RegSvr32 SQLTaskConnections.dll

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • Hi

    The problem could be the Proc [dbo].[sproc_IndexMaintenance]

    Does this [dbo].[sproc_IndexMaintenance] run when called directly eg EXEC [dbo].[sproc_IndexMaintenance]?

    When you run the job set does the database context change - and does the proc [dbo].[sproc_IndexMaintenance] exist in every database?

  • Seth Lynch (9/11/2009)


    Hi

    The problem could be the Proc [dbo].[sproc_IndexMaintenance]

    Does this [dbo].[sproc_IndexMaintenance] run when called directly eg EXEC [dbo].[sproc_IndexMaintenance]?

    Yes, It does.

    When you run the job set does the database context change - and does the proc [dbo].[sproc_IndexMaintenance] exist in every database?

    No. sproc_IndexMaintenance exists in one database and it executes from that db for all the existing databases on production server.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • Vivek , let me try to help you .

    Can you please share the sp code to hi_abhay78@yahoo.co.in.

    Regards

    Abhay Chaudhary
    Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)

  • Hi Abhay

    Thanks a lot for your reply but i have managed to resolve this issue.

    It was a problem with table name and stored procedure wasn't taking care of it.

    Thanks again.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply