Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 How to e-mail a table structure with data

Author  Topic 

mikeallenbrown
Yak Posting Veteran

72 Posts

Posted - 2014-06-27 : 10:27:56
I need to e-mail a specific SQL table with the data it contains to another developer....how do I do that?? I know how to send just the table structure using Script Table -> Create To -> File but sending the data too eludes me ...

Thank you in advance

Mike Brown

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2014-06-27 : 10:34:05
There is an option what to script. Default is Schema Only. Change it to Schema And Data.


Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

mikeallenbrown
Yak Posting Veteran

72 Posts

Posted - 2014-06-27 : 11:18:05
I think I found it ...thanks!

Mike Brown
Go to Top of Page
   

- Advertisement -