How to disable check dependent object ? 
Author Message
 How to disable check dependent object ?
I've to create stored procedures that used temporary tables which don't
exist when I launch the script.
How to do to force the creation without verifying if dependent objects
exist ?

Thanks



Tue, 29 Jan 2002 03:00:00 GMT
 How to disable check dependent object ?

See 'Deferred Name Resolution and Compilation' in books online.

It is probably due to the database being in 65 compatibility mode.

--
Tony Rogerson MCP, SQL Server MVP
Torver Computer Consultants Ltd.

www.sql-server.co.uk [Code/Examples library + Neil Pike's FAQ]


Quote:
> I've to create stored procedures that used temporary tables which don't
> exist when I launch the script.
> How to do to force the creation without verifying if dependent objects
> exist ?

> Thanks



Tue, 29 Jan 2002 03:00:00 GMT
 How to disable check dependent object ?
Sorry but it works with SQL 7 but I 've to use SQL 6.5
So no compatibility level could be set

Tony Rogerson a crit :

Quote:

> See 'Deferred Name Resolution and Compilation' in books online.

> It is probably due to the database being in 65 compatibility mode.

> --
> Tony Rogerson MCP, SQL Server MVP
> Torver Computer Consultants Ltd.

> www.sql-server.co.uk [Code/Examples library + Neil Pike's FAQ]



> > I've to create stored procedures that used temporary tables which don't
> > exist when I launch the script.
> > How to do to force the creation without verifying if dependent objects
> > exist ?

> > Thanks



Tue, 29 Jan 2002 03:00:00 GMT
 How to disable check dependent object ?
do something like this in your SQL script:

create table #x
(...)
go

if exists drop proc...
go

create proc x
as

do something with #x
go

drop table #x
go

--
Thanks,
Dave
(Please respond to the newsgroup.)


Quote:
> I've to create stored procedures that used temporary tables which don't
> exist when I launch the script.
> How to do to force the creation without verifying if dependent objects
> exist ?

> Thanks



Tue, 29 Jan 2002 03:00:00 GMT
 How to disable check dependent object ?
The only way to do this in 6.5 would be to use dynamic sql ie. execute( '
' )

--
Tony Rogerson MCP, SQL Server MVP
Torver Computer Consultants Ltd.

www.sql-server.co.uk [Code/Examples library + Neil Pike's FAQ]


Quote:
> Sorry but it works with SQL 7 but I 've to use SQL 6.5
> So no compatibility level could be set

> Tony Rogerson a crit :

> > See 'Deferred Name Resolution and Compilation' in books online.

> > It is probably due to the database being in 65 compatibility mode.

> > --
> > Tony Rogerson MCP, SQL Server MVP
> > Torver Computer Consultants Ltd.

> > www.sql-server.co.uk [Code/Examples library + Neil Pike's FAQ]



> > > I've to create stored procedures that used temporary tables which
don't
> > > exist when I launch the script.
> > > How to do to force the creation without verifying if dependent objects
> > > exist ?

> > > Thanks



Tue, 29 Jan 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

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

2. SQL Server Copy Object Task: include dependent objects

3. Finding dependent objects in different DB

4. SQL 7.0 Generate SQL Scripts with Dependent Objects

5. DTS Dependent Objects

6. Dependent Objects in scripts

7. How To List the dependent objects of defaults

8. Update from object types with type or table dependents

9. Update from object types with type or table dependents

10. SP_DEPENDS not showing all dependent objects

11. Access right inheritance (for dependent objects)

12. Provisionally Disable Check Constraint


 
Powered by phpBB® Forum Software