• Skip to primary navigation
  • Skip to content
  • Skip to footer
Highly Distinguish IT solution & education
  • About
  • Tags
  • Sitemap
    Treasure Bowl for SQL, helpful for your daily database jobs

    Treasure Bowl for SQL, helpful for your daily database jobs

    less than 1 minute read

    On this page

    • SQL Server
      • To check permissions of database objects
      • To show sql source of a stored procedure

    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–

    Updated: January 31, 2023

    Share on

    Twitter Facebook LinkedIn
    Previous Next

    You may also enjoy

    看完《夜王》,我终于理解了:AI 焦虑不是技术问题,而是价值证明问题

    less than 1 minute read

    “君子不器。” — 孔子

    What AI Anxiety Really Means: The Fight to Prove Your Value in an Automated World

    8 minute read

    “The past is never dead. It’s not even past.” — William Faulkner

    排查的终点,是让排查消失:一夜四次 GPU 翻车实录

    6 minute read

    “The first principle is that you must not fool yourself — and you are the easiest person to fool.” — Richard Feynman,《Cargo Cult Science》,1974 年加州理工毕业演讲

    The Goal of Troubleshooting Is to Make Troubleshooting Unnecessary

    14 minute read

    “The first principle is that you must not fool yourself — and you are the easiest person to fool.” — Richard Feynman, Cargo Cult Science, Caltech commence...

    • Follow:
    • Feed
    © 2026 Highly Distinguish. Powered by Jekyll & Minimal Mistakes.