Hi,
Try out this in Query Analyzer: SELECT 'exec sp_changeobjectowner [bmssa.' + TABLE_NAME + '], '''+ 'dbo' +'''' FROM INFORMATION_SCHEMA.TABLES Thanks and Regards, SUBHASH MENDAKUDURU | Technical Consultant | Systems Advisers Group Tel : +91 80 5132 0164 Fax: +91 80 2558 5863 Mob: +91 9900 240413 Web: www.systemsadvisers.com <http://www.systemsadvisers.com/> Systems Advisers Group: "Systems Advisers Group" provides global solutions and services around Microsoft Dynamics(tm) AX, Microsoft Dynamics(tm) GP and SunSystems. As one of the fastest growing Microsoft Dynamics partners globally we are currently 1 of only 3 global "power vendors" to Microsoft. With experience in implementations in over 40 countries world-wide the group has Centres of Excellence in Asia Pac, Europe and Latin America for Onshore and Offshore capabilities to suit the needs of your organisation. For more information visit us at www.systemsadvisers.com <http://www.systemsadvisers.com/> or write [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Fidler Sent: Wednesday, April 11, 2007 5:07 PM To: [EMAIL PROTECTED] Subject: [Axapta-Knowledge-Village] sql Hi, Anyone have a script to change the db owner? [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]