Friday, February 24, 2012

DBCC Commands

Anyone knows of any good source of DBCC commands (not the usual ones
... the hindden commands), and TRACE flags?
TIA
PabloPablo,
Two copies of the same article, I believe.
http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
sp
From 6.5 days:
http://www.winnetmag.com/Article/ArticleID/14186/14186.html
http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
Etc, etc, from Google.
Russell Fields
"PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> Anyone knows of any good source of DBCC commands (not the usual ones
> ... the hindden commands), and TRACE flags?
> TIA
> Pablo|||Hi,
Just go to SQL Server books online and in Index type "DBCC", there you get
all the DBCC commands with explanation.
Thanks
Hari
MCDBA
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:evUydA15DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
>
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/ArticleID/14186/14186.html
> http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> > Anyone knows of any good source of DBCC commands (not the usual ones
> > ... the hindden commands), and TRACE flags?
> >
> > TIA
> > Pablo
>|||Be very careful using undocumented (and hence unsupported) DBCC commands -
many of them can damage or destroy your database if used incorrectly. They
are there for use by PSS in the field - I don't recommend experimenting with
them.
What are you trying to do?
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:evUydA15DHA.1636@.TK2MSFTNGP12.phx.gbl...
> Pablo,
> Two copies of the same article, I believe.
> http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocDBCC.htm
>
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.a
> sp
> From 6.5 days:
> http://www.winnetmag.com/Article/ArticleID/14186/14186.html
> http://www.extremeexperts.com/sql/articles/DBCCTraceFlags.aspx
> Etc, etc, from Google.
> Russell Fields
> "PAblo E. Colazurdo" <rael@.singularidad.com.ar> wrote in message
> news:uVajpx05DHA.2392@.TK2MSFTNGP11.phx.gbl...
> > Anyone knows of any good source of DBCC commands (not the usual ones
> > ... the hindden commands), and TRACE flags?
> >
> > TIA
> > Pablo
>|||Paul S Randal [MS] wrote:
> Be very careful using undocumented (and hence unsupported) DBCC
> commands - many of them can damage or destroy your database if used
> incorrectly. They are there for use by PSS in the field - I don't
> recommend experimenting with them.
> What are you trying to do?
I know all that but on real situations some of them had really helped
me a lot, so being able to know more about them can help me more in the
future.
No that I'm going to live using them but you know ... they are really
useful sometimes

No comments:

Post a Comment