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)
 Generate Script

Author  Topic 

Sachin_Sharma
Starting Member

3 Posts

Posted - 2008-02-26 : 08:06:49
I need a sql query that generate sql script(.sql) of all the databases at once.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-02-26 : 08:09:40
right click on your database, go to Tasks, Generate SQL Scripts and then pick the options you want.
Go to Top of Page
   

- Advertisement -