Silly question

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Captain Nemo

    Silly question

    Hi

    I've not used SQL Server for a while, and I've forgotten how you hide all
    those system procedures (beginning with dt_) in Enterprise Manager.

    Could some kind person please refresh my memory?

    Thanks

    Captain Nemo


  • Erland Sommarskog

    #2
    Re: Silly question

    Captain Nemo (Captain@NoSpam .com) writes:[color=blue]
    > I've not used SQL Server for a while, and I've forgotten how you hide all
    > those system procedures (beginning with dt_) in Enterprise Manager.[/color]

    Right-click the server, and choose Edit Registration Properties. There
    is a checkbox for system databases and system objects.


    --
    Erland Sommarskog, SQL Server MVP, sommar@algonet. se

    Books Online for SQL Server SP3 at
    Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

    Comment

    • Captain Nemo

      #3
      Re: Silly question

      Many thanks! That tidies things up no end!


      Comment

      Working...