dbTalk Databases Forums  

urgent!!! change in object ownership

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss urgent!!! change in object ownership in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Raj
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.