(Ben Miller) Below is the final code that I used to script off my Tables, Views and the data using sp_generate_inserts from Vyas. This is something that I have needed to do, and I found that using SMO for this is a great tool. Mind you, that the data file that gets output to me is 22 MB from this
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help