You can easily create .sql scripts in sql server 2008. Following are the steps involved
1. Start Microsoft Sql server management studio
2. Select database and right click on the database.
3. Select Tasks >> generate scripts..
4. Save .sql script.
To import this script, open a query browser and execute the script.
Filed under: SQL Server, database, Generate script, SQL Server 2008
