Results 1 to 2 of 2

Thread: Identifying Difference Btwn System and User objects??

  1. 03-17-2000, 06:36 PM #1
    Adam Brown Guest

    Identifying Difference Btwn System and User objects??

    Does anyone know the logic that Enterprise Manager/SQL Server uses to distinguish system objects from user objects. I've looked through all the sysobjects in the database and there doesn't seem to be any unique logic for seperating all objects. User tables are easily distinguished from system tables (U/S) but thats not the case with stored procedures and views. I'm looking for suggestions...
    Thanks,
    Adam
    Reply With Quote Reply With Quote
  2. 03-20-2000, 07:16 AM #2
    Adrian Sims Guest

    Identifying Difference Btwn System and User objects?? (reply)

    Adam,
    Indeed enterprise manager only distinquishes system and user tables by the type in sysobjects. However the system stored procedures are stored in the master database and not the user databases.

    Adrian


    ------------
    Adam Brown at 3/17/00 6:36:23 PM

    Does anyone know the logic that Enterprise Manager/SQL Server uses to distinguish system objects from user objects. I've looked through all the sysobjects in the database and there doesn't seem to be any unique logic for seperating all objects. User tables are easily distinguished from system tables (U/S) but thats not the case with stored procedures and views. I'm looking for suggestions...
    Thanks,
    Adam
    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