urgent!!! change in object ownership -
06-10-2004
, 11:46 PM
HI
when copy sql server objects task is performed. the owner ship of few stored procs are converted to dbo from "xxx" owner. this happens to procedures that created with out explicitly giving "owner.procname" during creation. In the source server all procs has got same owner that is "xxx". the issue comes when these objects are copied to destination server
i feel is there any problem in setuser command which is used in the script
regard
raj |