Undocumented commands !!! | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Undocumented commands !!!

Hi! From what I know, I think there are several UNDOCUMENTED COMMANDS in SQL Server 2000, for ex. " DBCC LOGINFO ". How do we get hold of these commands ie., where can we come across these commands? Thanks & Regards Amer Mohammed Jamal
SQL DBA,
Wipro Technologies,
Hyderabad, India
email: [email protected]
Hi, It’s better not to use those undocumented command as well as undocumented sp’s as microsoft is not gonna provide support for that and microsoft can stop the use of them in future release without any notifications.
Dear Amar, You can check these links. Sometimes you may get something from this. http://www.extremeexperts.com/sql/articles/ListDBCCCommands.aspx
http://www.sql-server-performance.com/ac_sql_server_2000_undocumented_dbcc.asp
http://www.databasejournal.com/features/mssql/article.php/1442251 -Johnson
@Johnson….Thnx for the links….sure are very helpful….<br /><br />@Ranjit….i shall keep your advice in mind….but these commands sure are tempting as they do quite a good job… <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /><br /><br />Thanks & Regards<br /><br />Amer Mohammed Jamal<br />SQL DBA,<br />Wipro Technologies,<br />Hyderabad, India<br />email: [email protected]
As has been mentioned, don’t rely on undocumented features in SQL Server!
MS won’t help you when your issue is related to such a feature. They also claim the right to discontinue or change their functionality on a Service Pack level. If you insist to find out, I would have a look at the source code of the system procedures, look at the scripts in your SQL Server directory and, last but not least, you can use Profiler to see what command is executed. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Yes I also think it very much advisable NOT TO USE undocumented SPs. —————————————-
http://spaces.msn.com/members/dineshasanka

But I wonder why some are not documented? Madhivanan Failing to plan is Planning to fail
I was under the impression that most of the undocumented SPs were old and had often been superseded… ‘I reject your reality and substitute my own’ – Adam Savage
Some are old, some are maybe not stable enough to be used by the end-user, some can cause severe damage to your installation if used improperly and I believe some just didn’t make it into BOL… —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Sometimes these undocumented stored procedures comes very handy to diagnose the SQL system, but as referred above do not rely completely on them and you may never know during next hotfix or service pack release they will not be available, you will be bemused. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
what’s a BOL ??? Thanks & Regards Amer Mohammed Jamal
SQL DBA,
Wipro Technologies,
Hyderabad, India
email: [email protected]
BOL = Books Online is SQL Server’s exceptionell good help documentation. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

The more you participate in forums you will get used to that slang [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />].<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
]]>