Index Maintenance - Error

Question

Post reply

Index Maintenance - Error

Vivek Shukla

SSCrazy

Points: 2146
More actions
September 11, 2009 at 8:15 am

#204523

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

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

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

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

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]

Vivek Shukla SSCrazy Points: 2146 More actions · Answer 2

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

Seth Lynch SSCrazy Points: 2975 More actions · Answer 3

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?

Vivek Shukla SSCrazy Points: 2146 More actions · Answer 4

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

hi_abhay78 SSCertifiable Points: 6265 More actions · Answer 5

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)

Vivek Shukla SSCrazy Points: 2146 More actions · Answer 6

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