Thursday, March 22, 2012

DBCC Showcontig

Does anyone know why i get this answer:
DBCC execution completed. If DBCC printed error messages,
contact your system administrator. when i do a dbcc
showcontig ofa table? BUt another table gives me results..
Any explanation?
ThanxsPerhaps that table doesn't have any indexes? Use sp_helpindex to check which indexes each table has.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"smiley" <anonymous@.discussions.microsoft.com> wrote in message
news:059601c3adcc$d57d2cf0$a401280a@.phx.gbl...
> Does anyone know why i get this answer:
> DBCC execution completed. If DBCC printed error messages,
> contact your system administrator. when i do a dbcc
> showcontig ofa table? BUt another table gives me results..
> Any explanation?
> Thanxssql

No comments:

Post a Comment