Download all tables and stored procedures to file

is it possible to开发者_如何学Python download in a file all the table definition(create Statements) and Stored

Procedures from a SQL Server 2008 database?

Thanks

yes, right click on the database-->tasks-->generate scripts

This will bring up the scripting wizard, pick the objects you want and specify output

See also: How To Script Out The Whole Database In SQL Server 2005 and SQL Server 2008