Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Angry Unanswered: weird sysobjects

    Is there any occassion when you can have entry in the sysobjects table but no corresponding object in the database.

    Cheers

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Such as?

    It's possible for there to be entries in a system table for objects that your login does not have permission to see.

    blindman

  3. #3
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149

    Smile

    sussed it ,

    forgot to put the object owner in

    what a dumb ass I am ...

    cheers

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Bah! How many times have I done that? I just know how to cover up the mistake quicker ;-)

  5. #5
    Join Date
    Nov 2003
    Location
    Edinburgh
    Posts
    149
    get rid of all users then all you would have is dbo owned objects

    bliss

Posting Permissions

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