InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:53:56 GMT20http://www.sqlservercentral.com/Forums/Topic1352783-2893-1.aspxFYI: DMUSER is also a db_owner for the source and destination dbs....also, I apolgize for my frequent use of emoticons, I just think they help me get my point across! ;-)Fri, 31 Aug 2012 07:26:55 GMTlisa.randleshttp://www.sqlservercentral.com/Forums/Topic1352783-2893-1.aspxDue to database corruption (see my other posts), I am attempting to transfer all objects and data out of one database into another using SSIS. I've encountered and fixed numerous errors, and now I have a new issue. I have 2 different schemas, dbo and DMUSER. When the DMUSER stored procedures transfer, *some* of them successfully have the DMUSER schema and *some* come over incorrectly as dbo because of how the stored procs were originally scripted: CREATE PROCEDURE CheckAS400DealerCode VS. CREATE PROCEDURE DMUSER.CheckAS400DealerCodeAs a result, it was my intent to transfer over all objects *except* for the DMUSER stored procs (this part works correctly) - and then, in a second transfer, change my authentication to the SQL DMUSER user (who has a default schema of DMUSER and is a member of sysadmin) to pull them over. However, the second transfer completes *successfully* (turns green and all) but the stored procs are not transferred to the destination database. No errors or anything! :w00t:Has anyone else encountered this or have any suggestions?! If you could provide any sort of help, I'd love you forever and be your best friend! :-PFri, 31 Aug 2012 07:05:48 GMTlisa.randles