469,632 Members | 1,730 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,632 developers. It's quick & easy.

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

2
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
Sep 6 '07 #1
1 1037
ck9663
2,878 Expert 2GB
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...
Sep 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Karsten | last post: by
1 post views Thread by moncelh | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.