BCP OUT all table data in your Database

CREATE  procedure DBATools_bcp_backup__tables as 


/*************************************************//*  Purpose: Creates the BCP files for the PRSL  *//*  schema  and places them in their respective  *//*  day parts.  It will also overwrite the table *//*  data each week. Need to create 7 directories */ 
/*  called day1, day2,day3, day4, day5, day6 and *//*  day7                                         *//*************************************************/
begin

declare @table_name varchar(255),
@statement varchar(512),
@dw tinyint

select @dw = datepart(dw,getdate())

declare tables cursor for 
select name from sysobjects where type = 'u' order by name

open tables
fetch tables into @table_name
while @@fetch_status = 0
begin

--need to replace [DBName]
--need to replace FILESPEC with UNC Path to 
--the days directories

set @statement = 'bcp DBName..' + @table_name + 
        ' out ' + 'FILESPEC\day' + 
        cast(@dw as varchar(1)) + '\' + @table_name 
        + ' -T -c' 
print @statement
exec master..xp_cmdshell @statement , no_output
fetch next from tables into @table_name
end
print @@fetch_status
close tables
deallocate tables
end

GO