generate sql script

[dadahetal]

I have created Database. table and procedure inside that. I want to generate sql script for this. How can I do that in .Net 2005?

also after generating script, how can i run that to create tables in another computer?

[achristov]

Maybe you mean Visual Studio 2005? You can't - use SSMS (SQL Server Management Studio).

[greeny_1984]

Hi,

Do you want to generate sql script for a database table in sql server 2005 ,then follow these steps
1.open microsoft sql sever 2005
2.open management studio express
3.go to your database
4.right click on the table you want to generate script
5. go to option "script table as"
6. select option "create to"->"new query editor"
7.it will generate script
8.copy this query and execute in the database you want to have this table.