Post reply

system tables and user tables

  • September 4, 2006 at 7:46 am

    #114777

    hi Im woking on a couple of production servers.

    The msdb database on the servers has two typs of tables..user tables and system tables.

    All the tables in the system databases are one and the same. In the user table also I find the same tables on both the servers..

    Y is that so?? What are those.

    Harris/

     

  • September 5, 2006 at 3:34 pm

    #658654

    My first reaction is that anyone asking "What are those?" (and we were all there at some point) should be chained to a Northwind or AdventureWorks database on a development server, not allowed anywhere near a production server.

    The system databases have mostly the same tables on every server because the system databases are used for the same functions on every server.  All the system databases and tables are described in the online SQL Server documentation (Books Online).

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply