Hi All,
i want to generate the SQl script which should also contain the insert statement of the data... is there a way in SQL serve for this.. or i have to use some third party tool, if any plz recomend any tool..

thanks

zee

Not sure what you are looking for, can you elaborate more on what you are trying to achieve?

_________________________
- Vijay G
Strive for Perfection

Using Generate Script Wizard u can only generate DDL not DML.

If u want all these then u should go for DTS Scripts. U can create DTS Package which u can create in for of VB code also. I m not sure how much u r familiar with VB and ActiveX.

Hope u can dig out futhre details on SQL Server DTS Tool. If u r a programmer then u can design your tool for such operations. U can read the table and keep the data in Text file in Form of "Insert Into" statements.

Gud luck

B. Anant