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
 SQL Server Administration (2005)
 Generating the DB script file in SQL Server 2005

Author  Topic 

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-04-25 : 02:08:05
Hi All,
Can any tell me how to generate the Script file in SQL 2005.
If i execute that script in another server all should be created automatically including the Database with the same name.
How to do this..

Ganesh

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-04-25 : 05:35:26
1 In SSMS Right click on Database
2 Select Tasks
3 Select Generate Scripts

and follow it

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -