Treasure Bowl for SQL, helpful for your daily database jobs

Don’t be greedy. Half of something is better than all nothing.

SQL Server

To check permissions of database objects

sp_helprotect ‘dbo.spname’

To show sql source of a stored procedure

sp_helptext ‘dbo.spname’

–HTH–