Results 1 to 3 of 3

Thread: system tables

  1. #1
    Join Date
    Jul 2002
    Posts
    7

    Unanswered: system tables

    Hello,

    yesterday i transferred all my tables from one server to another one, now I have 2 (dumb?) questions about it:

    1. Those irritating system tables show up again in the tables display,
    how do i hide those system tables again? can't seem to find the toggle anymore, on the other server it's not visible (the entire master db is hidden unless you connect from another computer to it)

    2. is it normal that all my tables that have ID fields with identity set to YES are set to NO after the expert (on the destination server)

    any info would be appreciated.

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    In EM, right click on server name and select "Edit SQL Server Registration Properties...", then uncheck "Show system databases and system objects.

    No, What method did you use to transfer the schema?
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jul 2002
    Posts
    7
    1. solved. thanx!

    2. i did a plain export from server A -> server B

Posting Permissions

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