The Wayback Machine - https://web.archive.org/web/20100724202958/http://sqlserver2000.databases.aspfaq.com:80/how-can-i-learn-more-about-undocumented-sql-server-stored-procedures.html
   //  home   //  advanced search   //  news   //  categories   //  sql build chart   //  downloads   //  statistics
 ASP FAQ 
Home
ASP FAQ Tutorials
Image
Image   8000XXXX Errors
Image   ASP.NET 2.0
Image   Classic ASP 1.0
Image   Databases
   Image   Access DB & ADO
   Image   General SQL Server & Access Articles
   Image   MySQL
   Image   Other Articles
   Image   Schema Tutorials
   Image   Sql Server 2000
   Image   Sql Server 2005
Image   General Concepts
Image   Search Engine Optimization (SEO)

Contact Us
Site Map

Search

Web
aspfaq.com
tutorials.aspfaq.com
sqlserver2000.databases.aspfaq.com

ASP FAQ Tutorials :: Databases :: Sql Server 2000 :: How can I learn more about undocumented SQL Server stored procedures?


How can I learn more about undocumented SQL Server stored procedures?

I have often used undocumented stored procedures, such as sp_msForEachTable and sp_msForEachDatabase, for quickly scripting out admin tasks. However, their usage is not documented in Books Online, so it can sometimes be very much a hunt and peck exercise. 
 
The following articles should help you to learn more about these stored procedures, including their syntax, benefits, and pitfalls: 
 
    SQL Server 7.0 Useful Undocumented Store... 
 
    SQL Server 2000 Useful Undocumented Stor... 
 
Of course, use undocumented stored procedures with caution, and never in production code. Remember that these procedures are undocumented for a reason — their behavior could change in a future version or service pack, or they could disappear completely. So, you should be prepared to test all of your scripts and applications that rely on these procedures, every time you make any kind of change to your SQL Server installation(s).

Related Articles

Image Are there tools available for auditing changes to SQL Server data?
Image Can I create an index on a BIT column?
Image Can I have optional parameters to my stored procedures?
Image Can I implement an input mask in SQL Server?
Image Can I make SQL Server format dates and times for me?
Image Can I start IDENTITY values at a new seed?
Image Can SQL Server tell me which row was inserted most recently?
Image How can I make my SQL queries case sensitive?
Image How do I audit changes to SQL Server data?
Image How do I connect to a non-default instance of SQL Server?
Image How do I connect to SQL Server on a port other than 1433?
Image How do I create a cross-tab (or "pivot") query?
Image How do I determine if a table exists in a SQL Server database?
Image How do I drop a SQL Server database?
Image How do I find all the available SQL Servers on my network?
Image How do I get a list of SQL Server tables and their row counts?
Image How do I get rid of Named Pipes / DBNMPNTW errors?
Image How do I get the correct date/time from the msdb.sysjob* tables?
Image How do I get the nth row in a SQL Server table?
Image How do I get the result of dynamic SQL into a variable?
Image How do I handle REPLACE() within an NTEXT column in SQL Server?
Image How do I hide system tables in SQL Server's Enterprise Manager?
Image How do I know which version of SQL Server I'm running?
Image How do I limit the number of rows returned in my resultset?
Image How do I load text or csv file data into SQL Server?
Image How do I manage changes in SQL Server objects?
Image How do I monitor SQL Server performance?
Image How do I prevent linked server errors?
Image How do I reclaim space in SQL Server?
Image How do I recover data from SQL Server's log files?
Image How do I search for special characters (e.g. %) in SQL Server?
Image How do I start SQL Server Agent from ASP?
Image How do I time my T-SQL code?
Image How do I upsize from Access to SQL Server?
Image How do I upsize my MSDE database to full-blown SQL Server 2000?
Image How do I use a variable in a TOP clause in SQL Server?
Image How do I use GETDATE() within a User-Defined Function (UDF)?
Image How should I store an IP address in SQL Server?
Image Schema: How do I find all the foreign keys in a database?
Image SQL Server & MSDE
Image What are reserved Access, ODBC and SQL Server keywords?
Image What are the capacities of Access, SQL Server, and MSDE?
Image What are the main differences between Access and SQL Server?
Image What do I need to know about SQL Server 2000 SP4?
Image Where else can I learn about SQL Server?
Image Where is SP4 for SQL Server 2000?
Image Why am I having problems with SQL Server 2000 SP3 / SP3a?
Image Why can't I install SQL Server on Windows Server 2003?
Image Why can't I install SQL Server on Windows XP?
Image Why can't I use LIKE '%datepart%' queries?
Image Why do I get "Login failed for user '\'."?
Image Why do I get 'object could not be found' or 'invalid object name'?
Image Why do I get errors about master..spt_values?
Image Why do I get script errors in Enterprise Manager's 'taskpad' view?
Image Why do I get SQLSetConnectAttr Failed errors?
Image Why do I have problems with views after altering the base table?
Image Why does EM crash when I get an error in a stored procedure?
Image Why does Enterprise Manager return 'Invalid cursor state'?
Image Why does my DELETE query not work?
Image Why does sp_spaceused return inaccurate values?
Image Why is Enterprise Manager slow at expanding my database list?
Image Why is my app slow after upgrading from SQL Server 7 to 2000?
Image Why is tempdb full, and how can I prevent this from happening?
Image Why should I consider using an auxiliary calendar table?
Image Why should I consider using an auxiliary numbers table?

 

 

Created: 7/7/2003 | Last Updated: 7/7/2003 | broken links | helpful | not helpful | statistics
© Copyright 2006, UBR, Inc. All Rights Reserved. (191)

 

Copyright 1999-2006, All rights reserved.
Finding content
Finding content.  An error has occured...