|
Your stored procedure may or may not be the problem, I cannot say for sure
without seeing your code. However if you are sure that the only command you
are issuing with this proc is DBCC SHOWCONTIG then it is probably not the
cause of your tables disappearing. My money would be on either your
database had suffered some sort of corruption, which would have shown up
using DBCC CHECKDB or someone (or something) other than this procedure had
dropped your tables.
Check SQL Servers error log as there may be some clues here. If not then
we'll never know, unless it happens again, but if you want to post the code
of your SP then I will have a look at this also.
For More Information
|
