Post reply

Maintaining dbo as owner of transferred SPROCS

  • October 2, 2006 at 3:05 am

    #172914

    How do I move SPROCs from one machine to another but have the new owner of the SPROCs on the new machine as dbo.  ie.  I want to maintain the owner property as dbo despite the fact that a new account has control of these SPROCS.

  • October 2, 2006 at 9:36 am

    #663654

    you could use a replication snaphot. or script them and do a find and replace. or change the owner using the provided sp_sproc

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 2, 2006 at 9:41 am

    #663657

    I find that it works when I get the reciepient PC to pull the data in rather than get the host PC to push the data out.

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

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