DBCC DBReindex problem - SQL Server Forums

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 Administration (2000)

DBCC DBReindex problem

Author

Topic

JohnDeere
Posting Yak Master

191 Posts

Posted - 2002-03-25 : 14:07:15

Has anyone had any experience with dbcc dbreindex runninng on a table in database A causing problems in database B.
After I started running the reindex a stored proc accesing database B began to fail. I have checked and can find no link in the stored proc to database B.

LHarra
"They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety."
(Benjamin Franklin)

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-25 : 14:35:20

Why do you suspect the DBCC command? What's the error message returned from the procedure execution?

Give details ...

setBasedIsTheTruepath
<O>

JohnDeere
Posting Yak Master

191 Posts

Posted - 2002-03-25 : 14:59:07

I suspect the DBCC beacause the stored proc was running fine until the DBCC DBReindex was started. The error is a generic raiseerror from inside the proc referring to invalid parameters.
The stored proc runs throughout the day and only fails when the DBCC db reindex is running. The stored proc is called from a vb program developed by consultants. I have not been able to get any other info from the consultants related to the error.

LHarra
"They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety."
(Benjamin Franklin)

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-25 : 15:11:57

Hmmmm...

So you believe that a DBCC DBREINDEX is somehow corrupting the parameters sent to a stored procedure in another database? Anything's possible, mathematically speaking, but the odds on that are exceedingly long.

Perhaps your VB consultants have a bug in their middle-tier code that's passing bad data when they have access problems in the other database.

Of course, you should shoot your database developers in the back of the head, double-tap, for running a DBREINDEX in the middle of the day ...

setBasedIsTheTruepath
<O>

JohnDeere
Posting Yak Master

191 Posts

Posted - 2002-03-25 : 15:17:50

I am not sure what is happening. I do know the problems started when the reindexing started. The reindexing is not done during the day, it is done during low usage times at night.

LHarra
"They that can give up essential liberty to obtain a little temporary safety
deserve neither liberty nor safety."
(Benjamin Franklin)

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-25 : 15:23:05

Once again, details are best ...

quote:

The reindexing is not done during the day, it is done during low usage times at night.

Bear in mind that a DBREINDEX is not an on-line operation; there will be a short period of time where the index will not exist. If your developers were experiencing errors because, for example, a query which used an index hint failed, then that would make sense. Bad parameter values don't fit the scenario you're painting.

For anyone here to help you, you'll need to start at the top and be as verbose as you can.

setBasedIsTheTruepath
<O>

Jay99

468 Posts

Posted - 2002-03-25 : 16:39:46

When debugging an error, if the only rationale you can come up with is not rational, you are probably being irrational.

By the way. If...