Most of the time we need to script data of a table which holds configuration Values or Date Dimension Tables for later use....obvious that its a waste of space to take a entire database backup !....SQL Server provides a functionality to export table data (Insert Values script) to a .SQL file...
Here is a Step by Step Guide to do the same..
Step 1 : Go to Tasks -->Generate Scripts
Step 2 : Click on Advanced -->Types of Data to Script-->Select Data only
Save the file in the required Location and open it in SSMS and you can view the insert scripts !!!
Will be back with more posts !! bye bye for now :) ...
