Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Script a DB

Author  Topic 

starnold
Yak Posting Veteran

83 Posts

Posted - 2008-10-15 : 09:33:52
Is there a Stored procedure to create a script for a database and save it to a file on your machine?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-15 : 09:37:39
You can generate the script from management studio

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/
Go to Top of Page
   

- Advertisement -