Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

is there any way to export a table to a file without any additional tools? I can't install anything on that server.

share|improve this question

2 Answers 2

Many ways to do this. i dont know exactly how you wanted your results but I will throw some options.

If it is a one time thing you can run a query(select * from YourTable if you need all the data in the table) using SSMS and then right click on the results and save it as text/csv file. If you want to do this programatically you can use bcp utility. You can also use integration services to export data; if you dont have SSIS on the target machine you can build your package inside another machine that do have SSIS and point it to your table as long as you have access to the table in the source.

share|improve this answer
He specified Express, which iirc doesn't come with integration services. But +1 for the other parts. – Joel Coel Dec 2 '10 at 3:01

Would the results to text or results to file function work for you? The option to do this is located in the toolbar above the query window.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.