Dependencies across databases 
Author Message
 Dependencies across databases

Does anyone know of a way to identify triggers which cross databases?



Sun, 27 Aug 2000 03:00:00 GMT
 Dependencies across databases

Quote:

> Does anyone know of a way to identify triggers which cross databases?

It is not foolproof, but something like

select distinct object_name(com.id) from syscomments com, sysobjects obj
where com.id = obj.id
and obj.type = 'T'
and com.text like "%..%"

will catch the vast majority of them.
--
Bret Halford                    Imagine my disappointment
Sybase Technical Support        in learning the true nature            
3665 Discovery Drive            of rec.humor.oracle...
Boulder, CO 80303



Sun, 27 Aug 2000 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. dependencies across databases

2. Determining stored procedure dependencies across databases

3. Show Dependencies - across multiple databases

4. setting up databases and relationships across databases

5. Database joins across databases.

6. Database Link across 2 databases.

7. Database - Database Comparison Across Servers !

8. How to find cross database dependencies?

9. Dependencies between databases

10. Tool to script database in order of dependencies?

11. Dependencies between databases

12. Java Databases, Platform Dependency/Scalability


 
Powered by phpBB® Forum Software