SQL Server Performance

Email or Export entire table from SQL 2000

Discussion in 'SQL Server DTS-Related Questions' started by larryle, Sep 9, 2003.

  1. larryle New Member

    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
  2. Twan New Member

    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
  3. larryle New Member

    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



    quote:Originally posted by Twan

    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

    larryle
  4. Twan New Member

    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

Share This Page