Post reply

Change table type to System

  • July 15, 2005 at 10:39 am

    #88085

    Somehow one of my sysdtspackages tables has turned into a "user" table. Does anyone know how to change this back to a "system" table?

    Thanks,

    George

  • July 15, 2005 at 11:21 am

    #574967

    That's strange.

    sp_configure 'allow updates', 1

    reconfigure with override

    update the table

    reverse the first two statements.

  • July 15, 2005 at 11:26 am

    #574974

    There is also the undocumented stored procedure sp_MS_marksystemobject.

    K. Brian Kelley
    @kbriankelley

  • July 15, 2005 at 11:41 am

    #574980

    Thanks Brian. Sounds like it might be exactly what I am looking for!

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

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