http://www.eggheadcafe.com/articles/20040913.asp

Nice article. The SQLAdmin.dll is very interesting

Interesting. After looking at this I scouted around the 'net a bit and found some stored procs for generating insert statements.

http://www.databasejournal.com/img/DataAsInsertCommand.sql http://vyaskn.tripod.com/code/generate_inserts.txt

And there are probably others. These could be very useful. I like to script my SQL Server databases from scratch, but sometimes I need to move a lot of Access data into them afterwards. DTS sucks, but I could use that to just dump them into another database in SQL Server, then generate these insert statements and clean them up and put them into a seed script. Then everything is in text files ready to run.

I posted something earlier: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=1544

But this article looks way more comprehensive