Here is a simple method of exporting all the data from SQL Server table to a Text File CREATE Procedure BCP_Text_File ( @table varchar(100), @FileName varchar(100) ) as If exists(Select * from information_Schema.tables where table_name=@table ) Begin...