Has anyone encountered the following error message when
running DBCC Showcontig with tableresults?
[Microsoft][ODBC SQL Server Driver]Unknown token received
from SQL Server
I am doing a dynamic DBCC on every table in my DB to
perform some analysis of indexes, however when I run the
full DB, I get this error. I printed the table.index for
each index prior to running the dbcc and when I take the
table and index and run independantly in ISQL, it executes
fine, but gives me a message about:
'DBCC execution completed. If DBCC printed error messages,
contact your system administrator.'
Which is not viable since it is a text string and not the
parameters of the TABLERESULTS table.
Anyone have a workaround or know what I can do to fix this?I'd start checking the database using CHECKDB. If that comes out clean, I'd say you've hit a bug
(check KB, be current and if that doesn't help open case with MS PSS).
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Chris" <chris@.da-krewe.com> wrote in message news:066a01c391af$9183bca0$a101280a@.phx.gbl...
> Has anyone encountered the following error message when
> running DBCC Showcontig with tableresults?
> [Microsoft][ODBC SQL Server Driver]Unknown token received
> from SQL Server
> I am doing a dynamic DBCC on every table in my DB to
> perform some analysis of indexes, however when I run the
> full DB, I get this error. I printed the table.index for
> each index prior to running the dbcc and when I take the
> table and index and run independantly in ISQL, it executes
> fine, but gives me a message about:
> 'DBCC execution completed. If DBCC printed error messages,
> contact your system administrator.'
> Which is not viable since it is a text string and not the
> parameters of the TABLERESULTS table.
> Anyone have a workaround or know what I can do to fix this?
Monday, February 27, 2012
HELP - Error Message when running DBCC Showcontig with TableResults
Labels:
database,
dbcc,
driverunknown,
encountered,
error,
following,
message,
microsoft,
microsoftodbc,
mysql,
oracle,
running,
server,
showcontig,
sql,
tableresults,
token
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment