creating a back up [create and insert statement] for a table in mssql server 2005

hi all,
i have a php application connecting to mssql server 2005. i want to generate sql script for backing up a table with create statement and complete inserts. i dont want to use data publishing wizard. how can i do it.

Thanks

Quote:

Originally Posted by bhakti

hi all,
i have a php application connecting to mssql server 2005. i want to generate sql script for backing up a table with create statement and complete inserts. i dont want to use data publishing wizard. how can i do it.

Thanks

or you can do a SELECT ... INTO NewTableName from MyTable...