Generating a dynamic SQL Script from SQL

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

General SQL Server Forums

New to SQL Server Programming

Generating a dynamic SQL Script from SQL

Author

Topic

Cyberwolf
Starting Member

1 Post

Posted - 2005-08-17 : 07:18:30

Hello,

in Oracle I can generate a script with the Spool Option ( Generating a Script for dropping all Tables with belongs to a specific schema )

Can I do the same in MSQL ?
If thats the case , please tell me how

Best regards Cyberwolf

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-08-17 : 07:23:11

Goto Enterprise Manager
Right Click on the Database
Select All tasks
Select Generate SQL Script

Madhivanan

Failing to plan is Planning to fail

X002548
Not Just a Number

15586 Posts

Posted - 2005-08-17 : 09:30:41

They are asking how to create a file.

The short answer is to use Query analyzer, execute a sql statement and save the reults to a file.

Do you have sql server client tools installed?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources