SQL Server useful system stored procedures
sp_helprotect [object_name] Returns a report with information about user permissions for an object, or statement permissions, in the current database. sp_helptext [view_name] Prints the text of a rule, a default, or an unencrypted stored procedure, user-defined function, trigger, computed column, or view. Full list of System Stored Procedures