Or you can write a program in you're language. for example C# or build a query like this.. EXEC master.dbo.sp\_configure 'show advanced options',1 RECONFIGURE EXEC master.dbo.sp\_configure 'xp\_cmdshell', 1 RECONFIGURE declare @query varchar(500) set @query = 'BCP "SELECT \* FROM YourTable" queryout "C:\\YourTable.txt" -c -T -C850 -S(local)\\SQLEXPRESS -Usa -Psa' EXEC master..xp\_cmdshell @query EXEC master.dbo.sp\_configure 'xp\_cmdshell', 0 RECONFIGURE EXEC master.dbo.sp\_configure 'show advanced options', 0 RECONFIGURE Be sure you're sql server has rights to write on the HD. (set local system account of you're SQL service) greetz Kurt