question

I would suggest two way to you. Which you will choose depend on the reason why you want to backup a table. If you need just the data and you want it locally (on the same database/server) then you can use the first option, through T-SQL scripts. If you need to back up the table to prevent data loss for a disaster situation, there is oppotunity to use SSMS. Probably second way is more easy. There are few articles, you can find more details if you need [ http://sqlblog.com/blogs/greg_low/archive/2010/06/07/backup-a-single-table-in-sql-server-using-ssms.aspx][1] and [ http://sqlbak.com/blog/how-to-backup-a-table-in-sql-server/][2] Hope this will be useful [1]: http://sqlblog.com/blogs/greg_low/archive/2010/06/07/backup-a-single-table-in-sql-server-using-ssms.aspx [2]: http://sqlbak.com/blog/how-to-backup-a-table-in-sql-server/