SQL Help Query

Returning information about all objects. The following example lists information about each object in the master database. EXEC sp_help;

Returning information about a single object. The following example displays information about the Contact table. EXEC sp_help Contact;

The following example reports on the types of indexes on the Customer table.
EXEC sp_helpindex 'Customer';

EXEC sp_helplogins 'sa'

Who are the users for database sp_who2

For get Stored Procedure Query sp_helptext ProcedureName