Hi Everybody,

In SQL Server 2005, I have some data in an SQL table. Now is there a way
that I can automatically generate the insert scripts which loads the data ,
just like I can automatically create the CREATE , DELETE scripts etc using
the SQL Management Studio. Is there a way I can achieve this ?

The reason I am doing this is probably this is a good way to generate test
data or for testing purpose. Any thoughts or suggestions would be appreciated.

Thanks