Results 1 to 4 of 4

Thread: hide system tables [Resolved]

  1. May 7th, 2004, 02:50 PM #1
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945

    hide system tables [Resolved]

    Does anyone know how to hide all the system tables in SQL Server 2000 Enterprise Manager?
    Last edited by ober0330; May 11th, 2004 at 07:27 AM.
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
  2. May 7th, 2004, 02:52 PM #2
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611
    I don't think you could hind them. You could prevent a user from accessing them when using authorisation
    VB6 & C# (WCF LINQ) mostly


    If you need help with a WPF/WCF question post in the NEW WPF & WCF forum and we will try help the best we can

    My site

    My blog, couding troubles and solutions

    Free online tools
    Reply With Quote Reply With Quote
  3. May 7th, 2004, 02:53 PM #3
    vb_dba
    vb_dba is offline
    Fanatic Member vb_dba's Avatar
    Join Date
    Jun 2001
    Location
    Somewhere aloft between the real world and insanity
    Posts
    1,016
    Right click on the Server name and select "Edit Server Registration Properties". De-select the checkbox labeled "Show System Databases and System Objects"
    Chris

    Master Of My Domain
    Got A Question? Look Here First
    Reply With Quote Reply With Quote
  4. May 11th, 2004, 07:27 AM #4
    ober0330
    ober0330 is offline

    Thread Starter
    Frenzied Member ober0330's Avatar
    Join Date
    Dec 2001
    Location
    OH, USA
    Posts
    1,945
    I know this is late, but THANK YOU!
    format your code!! - [vbcode] [/vbcode]

    ANSWERS CAN BE FOUND HERE!!

    my personal company
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width