SQL Server Performance Forum – Threads Archive

Email or Export entire table from SQL 2000

HI all: Is anyone know how to email or export table, which created in SQL 2000 Server? This project requires more then one person works on it. Thanks Larry larryle

---

Hi Larry, exporting can be done using bcp or DTS, both are described in Books Online emailing can be done either via SQLMail, by setting up a job the select the data from the table and email the output to a operator(s) What is it you are hoping to achieve? Cheers
Twan

---

Hi Twan: Thanks for the information that you shared. Basically, I responsible for create one database and two tables within that database on my machine at home. Then, I have to either export or email only one table to my friend, whom is responsible for filling the table (entering data into table). You mentioned SQLMail in this message. Can you please tell me how to set it up? Thanks Larry
larryle

---

Hi Larry,<br /><br />looking at what you are trying to achieve, it seems that what you want to do is email the table definition to your friend. The easiest way to do this is to use Enterprise Manager to Generate a SQL Script for your table.<br /><br />Open Enterprise Manager<br />Navigate to the table you want to extract<br />Right-click<br />Click on All Tasks<br />Click on Generate SQL Script…<br /><br />By default it will export a simple create statement with no indexes, constraints and foreign keys. If you want those then you can change the options on the Generate SQL Script dialog<br /><br />SQLMail is not the easiest to set up, and I’ve not found it particularly stable in our environment… and for this requirement is not going to help either <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />Cheers<br />Twan

---

]]>