Export data from an MS SQL server to an SQL script of insert statements
It appears that there is no built in option for performing such a simple a task. After all, SQL is the common protocol for SQL based databases.
What i did manage to find is a script (stored procedure) for SQLServer 2000 and SQLServer 2005
The original post and instructions are available here.