Post reply

Objects created as System for every user

  • September 2, 2005 at 1:53 am

    #87471

    HI,

    Have this strange problem. all my objects in any database are being created as system and i cant figure out why. I have tried using diffrent login with permission ranging from sys admin to db_owner for a newly created Db.

    Please help!!!

    P.

  • September 2, 2005 at 7:30 am

    #587185

    Try firing up profiler and then create an object. The trace should be able to tell you what is happening.

    /Kenneth

  • September 2, 2005 at 7:37 am

    #587190

    Hi Kenneth,

    I figured the problem. Some one had run

    dbcc traceon  (1717)

    which had resulted in all objects being created as system objects.

    This can be corrected by running the sp_MS_upd_sysobj_category 2

    sp_MS_upd_sysobj_category  @pSeqMode integer

    Enables/disables a special system mode wherein newly created objects are automatically system objects. Setting @pSeqMode to 1 enables this mode; setting it to 2 disables it. Among other things, sp_MS_upd_sysobj_category allows the creation of user-defined INFORMATION_SCHEMA views.

    sp_MS_upd_sysobj_category 1

    this is given in the book Guru's Guide to SQL Server Stored Procedures, XML, and HTML By Ken Henderson

    Thanks,

    Puneet

  • September 2, 2005 at 8:52 am

    #587250

    Useful bit of information that

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

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