Post reply

mailing parts of the DB

  • October 9, 2004 at 5:37 am

    #163438

    HI

    I want to mail just the updated part of an sql server db (the .mdf file) for example a new table or a achange in a store procedure insteade of sending all of the DB

    is it possible ?

  • October 9, 2004 at 10:36 am

    #526049

    If you are talking about sending the definitions of the table and stored procedure, there is an easy manual process.  By expanding Enterprise Manager until you get to the table you can right click on the table name, select "All Tasks" and click "Generate SQL Script".  You can then create a text file that can be emailed with scripts to create the objects.

    If this isn't what you meant, please give more information.

    Hope this helps,

    Kathi

     

     

    Aunt Kathi Data Platform MVP
    Author of Expert T-SQL Window Functions
    Simple-Talk Editor

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply