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–
