SQL 7.0 Generate SQL Scripts with Dependent Objects 
Author Message
 SQL 7.0 Generate SQL Scripts with Dependent Objects

I want to generate SQL Scripts in SQL server 7.0 for all views and
stored procedures from my development server into my production server.
The problem I have is I have nested views. If I generate a script for
all views and run the script I get 'invalid object errors' because the
dependent object wasn't created yet. I tried checking the box
for 'generate scripts for all dependent objects' in the formatting tab
of generating sql scripts from Enterprise manager. When I run this
script it appears to alter ref. integrity and my whole database gets
messed up. Is there a way to generate SQL scripts for all views/stored
procedures and get the dependent objects?

Sent via Deja.com http://www.***.com/
Before you buy.

Fri, 10 Jan 2003 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Dependent objects script is empty although many dependent objects exist

2. Generate SQL script for all objects in a database - but using ADO,not SQL-DMO

3. IN SQL 7.0 Generate SQL Script not working

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

5. SQL Server Copy Object Task: include dependent objects

6. SQL Script to generate SQL Scripts???

7. Generating scripts in SQL 7.0

8. Error 20585: [SQL-DMO]/****** Encrypted object is not transferable, and script cannot be generated.******/

9. Generate SQL creation script for all objects in a database using ADO

10. Generate SQL Script with depended objects

11. generating schema scripts programetically in SQL 7.0

12. Generate SQL Script for all objects in a database programmatically using TSQL

Powered by phpBB® Forum Software