11-Jun-03 (Created: 11-Jun-03) | More in 'CS-SQLServer'

How to use sp_help?

1. Sp_help "system object name" // has to match an exact name 
2. sp_helptext "system object name" // details 
3. sp_stored_procedures "%objectname%" // takes wild cards 
4. sp_columns "%name%" 5. sp_tables "%name%"