Post reply

view ownership

  • February 5, 2007 at 12:29 pm

    #68700

    Hi all you helpfull experts,

          Anyone tell me how to change the owner of an existing

          View?

          Thanks for everyone being there to help.

          SQL 2K Standard SP4

        

  • February 5, 2007 at 12:44 pm

    #687862

     

    exec sp_changeobjectowner '[oldowner].[viewname]','[newowner]'

     

  • February 5, 2007 at 12:49 pm

    #687864

    Thanks. Wouldn't survive w/o all of you.

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

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