how do i export my database into a Text file

Hi Mahmoodm7,

If you are doing this from SQL Server query editor then you would need to run the below command

EXEC xp_cmdshell 'bcp "select col1, col2,col3 from table_name" queryout "C:\results.txt" -S<servername\Instance_name> -U<enter_user_name> -P<enter_password> -t,'


If you want to run this from the command prompt on the server/client/remote server then run this at the command prompt

go to start menu --->run ---type cmd hit enter and copy paste this command and change parameters as per your server and tables/column names and hit enter.

'bcp "select col1, col2,col3 from table_name" queryout "C:\results.txt" -S<servername\Instance_name> -U<enter_user_name> -P<enter_password> -t,



-t is used to specify what is the column delimiter and in this case its ,

The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.

The Quomon Team