Database Admin

long, bad story here is the brief:

sql: 6.0 w/ fixes
platform: intel NT 4 sp3+

our "dba", i use that term loosly as the person who filled that position had little expertiese in managing sql, found a new job and has left; i worked with him on periphery matters so i'm less effective than he. unfortunatly ..."he with the most experience..." becomes "the man" so now i'm working to become a good dba and require some assistance.

we had a contractor come in and work out a method for archiving data using bcp, some batch files, and sql scripts; prior to this he assisted us in porting from one platform to another, digital alpha running NT to intel platform running NT.

in brief the procedure is as follows:
using options of EM create scripts to create all objects except indexes, again use EM to create sql scripts to create all objectes including indexes.

obtain sizing information and create a device and database, including log etc.

use the create objects script to create objects in the newly created database

use a custom script to create a batch file to bcp data from the primary database into flat files.

use a custom script/batch file to create a batch file to bcp data into the newly created database.

use the create indexes sql script to re-create indexes. we have to modify the sql create all objects including indexes script. i've worked up a batch file using for /f and if == to do this.

do some row counts and spot checks of tables stored procedures to verify conversion.


so now my questions:

using the information supplied causes problems, the tables end up being created but are owned by the wrong user. is there a way to change table, stored procedure, or object ownership? i create the database and objects as sa, then populate with bcp and re-create the indexes as the desired owner. my understanding is that sa has the special permissions needed to create objectes and the create objects script should make the appropriate users, logins, and changes to the db objects... where am i going wrong?