Post reply

Object Ownership Script

  • June 29, 2006 at 11:36 am

    #112692

    Does anyone have a t-sql script that will give me a list of all objects in the database (tables, stored procs, etc..) and who owns the object?

     

    Thanks,

    Michael

  • June 29, 2006 at 12:26 pm

    #646813

    SELECT SU.Name + '.' + SO.Name

    FROM SysObjects SO

        INNER JOIN SysUsers SU

        ON SO.uid = SU.uid

     

    Use a WHERE clause to limit type of object on xtype. 

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • June 29, 2006 at 1:20 pm

    #646823

    Thanks.

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

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