Given a database, dumps each table in the database to a tab delimited file.

build_batch_file.sql

declare @server_name varchar(40)
declare @db_name varchar(40)
select @server_name = 'win7b', @db_name='io'

select '
BCP "DECLARE @colnames VARCHAR(max);DECLARE @tab char(1);SELECT @tab=char(9);SELECT @colnames = COALESCE(@colnames + @tab, '''') + column_name from ' + @db_name + '.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME=''' + name + '''; select @colnames;" queryout HeadersOnly.csv -c -T -S ' + @server_name + '
BCP '+@db_name+'.dbo.'+name+' out TableDataWithoutHeaders.csv -c -T -S ' + @server_name + '
copy /b HeadersOnly.csv+TableDataWithoutHeaders.csv '+name+'.txt
del HeadersOnly.csv
del TableDataWithoutHeaders.csv
'

from sys.objects
where type = 'U'