Post reply

Stored Procedure Owner

  • May 11, 2005 at 3:36 am

    #164489

    How can I change the owner of a stored procedure using T-SQL? I have a list of stored procedures that need to have their owner changed so would rather not have to do it manually.

    Thanks

  • May 11, 2005 at 3:56 am

    #557994

    Have a look at sp_changeobjectowner in BOL. I would also bet, you'll find something useful in the script section here.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

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

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