• 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

    拆解大模型交付深水区:如何用 Schema 推理构建高确定性的 AI 工程体系

    3 minute read

    “Imagination is the key ingredient to a happy life.” — Unknown

    Taming the Chaos: The Hidden Power of Schema Reasoning in Production AI

    7 minute read

    “Imagination is the key ingredient to a happy life.” — Unknown

    为什么你的 RAG 永远读不懂财报?

    less than 1 minute read

    “Whatever is worth doing is worth doing well.” —— 某位不愿透露姓名的硅谷架构师(作者早期文章)

    Schema Validation: The Cost of Missing the Visibility Layer

    8 minute read

    “Whatever is worth doing is worth doing well.” – John Ruskin

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