How to generate script of db using sp 
Author Message
 How to generate script of db using sp

Hi
Anyone knows how to generate script of a database through QueryAnalyer(Any
Sp).I don't want to use Enterprise Mngr.
Faiz Ahmed



Mon, 10 Mar 2003 03:00:00 GMT
 How to generate script of db using sp

Faiz,

I'm not aware of any SP's to do the job, but you can call SQL-DMO (SQL
Server's object interface) to script out database objects.

sp_helptext will give you the source code of stored procedures and triggers,
if they are not compiled with the encryption option.

Ron
--
Ron Talmage
SQL Server MVP


Quote:
> Hi
> Anyone knows how to generate script of a database through QueryAnalyer(Any
> Sp).I don't want to use Enterprise Mngr.
> Faiz Ahmed



Mon, 10 Mar 2003 03:00:00 GMT
 How to generate script of db using sp

As Ron mentioned, you cannot do this using stored procedures or QA directly.

But, the DOS utility SCPTXFR will do what you want.  It should be installed
on your SQL Server.  Run SCPTXFR /? to get a list of options.

Keith


Quote:
> Hi
> Anyone knows how to generate script of a database through QueryAnalyer(Any
> Sp).I don't want to use Enterprise Mngr.
> Faiz Ahmed



Mon, 10 Mar 2003 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Generate MS-ACCESS table using SQL Script generated by SQL Server

2. SP to generate table script

3. sp for generating sql scripts?

4. How to generate all existing SP scripts automatically?(not by E.M.)

5. SP To Generate SQL Scripts

6. Strange situation after renaming SP and generating SQL Script

7. Using an SP to generate a Resultset

8. generate db script

9. generating all objects from db via script

10. auto-generate db change script ?

11. Generating a Compare/Synch-DB script

12. Generating SQL DB Scripts


 
Powered by phpBB® Forum Software