Email a DB - supplementary question

Thanks guys
Thats really helpful.
What if I wanted to include data from some of the tables (such as lookup
tables).
Kind regards
Ross Petersen
"Chandra" wrote:
> hi
> you can generate the script and then e-mail the script to the destination
> please let me know if u have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>You can include INSERT Scripts for that table.
See http://vyaskn.tripod.com/code.htm#inserts
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:D6FD9EFA-59A4-4AA9-B46A-D62420A4AEBF@.microsoft.com...
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi Ross
You can add INSERT .. statement in the script file. once the script is
executed, you will have all the objects with data in lookup tables
please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Ross" wrote:
> Thanks guys
> Thats really helpful.
> What if I wanted to include data from some of the tables (such as lookup
> tables).
> Kind regards
> Ross Petersen
>
> "Chandra" wrote:
>|||Hi fellers
Many thanks for your help.
Kind regards
Ross Petersen
"Chandra" wrote:
> Hi Ross
> You can add INSERT .. statement in the script file. once the script is
> executed, you will have all the objects with data in lookup tables
> please let me know if you have any questions
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> http://groups.msn.com/SQLResource/
> ---
>
> "Ross" wrote:
>

Email a DB

Hi folks
If I wanted to email a database (not including any data - just the design),
is there a way it can be done?
Thanks in advance
Kind regards
Ross PetersenYou can script the database and send the script across,
so that the receiver can rebuild the database from the script.
--
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:DCEE4255-CC31-4D00-A02A-C04E5B36857F@.microsoft.com...
> Hi folks
> If I wanted to email a database (not including any data - just the
> design),
> is there a way it can be done?
> Thanks in advance
> Kind regards
> Ross Petersen|||"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:DCEE4255-CC31-4D00-A02A-C04E5B36857F@.microsoft.com...

> If I wanted to email a database (not including any data - just the
> design),
> is there a way it can be done?
Why not just script the whole database, save it to a file, and email that?
The recipient can then use the script to create an exact copy of your
database...|||Ross
You may want to look at
http://support.microsoft.com/defaul...b;en-us;Q320125
Also , you can script the database , zip or rar it and then send it to the
someone.
"Ross" <Ross@.discussions.microsoft.com> wrote in message
news:DCEE4255-CC31-4D00-A02A-C04E5B36857F@.microsoft.com...
> Hi folks
> If I wanted to email a database (not including any data - just the
> design),
> is there a way it can be done?
> Thanks in advance
> Kind regards
> Ross Petersen|||hi
you can generate the script and then e-mail the script to the destination
please let me know if u have any questions
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Ross" wrote:

> Hi folks
> If I wanted to email a database (not including any data - just the design)
,
> is there a way it can be done?
> Thanks in advance
> Kind regards
> Ross Petersen