There are a lot of scripts out there promising to create insert scripts. You pass in the name of the table, and the scripts create an insert statement for each record contained. Only problem they have: the more columns there are, the greater the chance of lines being cut off in the middle.
The only working & free solution I found up to now is called SSMS Tools. You can get it here: LINK.
It integrates into SQL Server Management Studio and offers a couple of functions. The most important: the creation of insert scripts, based on the result of any sql statement.
This is standard functionality in Oracle clients for years now. So MS, please tell me, why this wasn’t implemented into SQL Server 2008?