generate SQL scripts from a script or stored procedure 
Author Message
 generate SQL scripts from a script or stored procedure
Is there a way to automate the Generate SQL scripts options from the
Enterprise manager
that it can be used through the query analyzer, vb scripts or stored
procedure ?

Thanks
David



Sun, 26 Oct 2003 09:51:40 GMT
 generate SQL scripts from a script or stored procedure

David,
You can use the SQLDMO object in VB all object(Table, Views SP) have a
script method that returns the text to rebuild the object

regards
Greg


Quote:
> Is there a way to automate the Generate SQL scripts options from the
> Enterprise manager
> that it can be used through the query analyzer, vb scripts or stored
> procedure ?

> Thanks
> David



Sun, 26 Oct 2003 12:39:00 GMT
 generate SQL scripts from a script or stored procedure
DMO will do this but its a bit tricky.  I am working on this now in VB but
will
move the code to vs. when its debugged.
try it.

Quote:
> Is there a way to automate the Generate SQL scripts options from the
> Enterprise manager
> that it can be used through the query analyzer, vb scripts or stored
> procedure ?

> Thanks
> David



Sun, 26 Oct 2003 21:55:44 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Generate sql script for encrypted stored procedures

2. SQL Script to generate SQL Scripts???

3. How to Generate Scripts for System Stored Procedures from master table

4. Generating scripts of stored procedures

5. Script to generate stored procedures

6. Generating Stored procedures script

7. HELP-Generate script of Stored procedures

8. Generating CREATE TABLE script through a stored procedure

9. Generate scripts for stored procedures in database?

10. VB Script to script all stored procedures

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

12. Generate Script Wizard (Scripting Views)


 
Powered by phpBB® Forum Software