Tag Archives: export query results into text file in SQL Server

Save Select query result into Textfile

Here I am explaining how to export query results into text file. Please follow below steps to archive this thing. Step 1: Enabled the xp_cmdshell By default disabled in SQL 2005 for security reasons. To enable it, use the Surface Area Configuration tool or sp_configure To enable xp_cmdshell using sp_configure, use below query : EXEC […]