• Skip to primary navigation
  • Skip to content
  • Skip to footer
Todd Zhang Engineering notes on AI systems, data platforms & cloud
  • 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

    别再用正则过滤代码了!带你彻底搞懂 AST 沙箱的必要性

    4 minute read

    “Goals tell you where you want to go. Systems determine what you actually do every day.” — Terry J. Govier

    Stop Patching, Start Parsing: Why Regex Is Not Enough for Security

    3 minute read

    How to build a hardened AST sandbox that handles messy financial notations without exposing your system to arbitrary code execution.

    大模型“幻觉”不是 Bug,而是概率模型的固有特性:全生命周期工程治理与 SME 进阶实战

    34 minute read

    “凡是可以说的,都可以清楚地说;凡是不能说的,就应该沉默。” — 路德维希·维特根斯坦《逻辑哲学论》

    Hallucination Isn’t a Bug, It’s a Feature: The Full-Lifecycle Systems Engineering Playbook

    18 minute read

    “Whereof one cannot speak, thereof one must be silent.” — Ludwig Wittgenstein, Tractatus Logico-Philosophicus

    • Follow:
    • Feed
    © 2026 Todd Zhang — Notes on AI in Production. Powered by Jekyll & Minimal Mistakes.