I'm not longer managing the installation mentioned in the original post, but to be clear...

AUTOGROW was enabled on all databases for that instance. 

The issue I experienced was that...

Yep, if others will be inserting data into these tables at the same time you're migrating data, then I'd suggest using the insert stored procedures in a while loop thru...

It depends... Are your target tables 'live', i.e., receiving data from other sources while you are doing these inserts?

If the tables are not live, then you could do INSERT...

DDL is data stored in the system tables within a database...

Have you tried

http://www.sqlteam.com/publish/scriptio/ 

or

http://www.sqlservercentral.com/products/bwunder/archiveutility/

Leda

I'm in a similar situation... I'm the first DBA for a small organization and, while much of the database design has been done well, there are areas that they have...

Eric:

What are you trying to do with the INFORMATION_SCHEMA.COLUMNS?

It is a view, so you should have no issue with doing a select

SELECT * FROM SecondarySQL.Billing.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME...

Yes, synonyms can be used with linked server, but the need to be defined on the calling (I'm guessng you'd call it 'Primary') server...

create SYNONYM cust