p********b
发帖数: 7 | 1 Hi,
Currently i am verifying a list of obsolet tables and stored procs coz
my boss is aware of some are still in use by applications on production side.
I am able to find all the dependencies from the obsolete object's
database. But i cant figure out a way to get dependencies inter-databases.
Is there any approach to do that? I use sybase, by the way.
Thanks a lot | m******y
发帖数: 588 | 2 Try to use sysdepends if you can.
If not, you could use sp_helptext like the below if you try to find the
depend object of a obsolete table or procedure in whatever database you want
to search:
CREATE TABLE #tmpObjResult(ObjText nvarchar(1000))
DECLARE @ObjName nvarchar(100)
DECLARE curObject CURSOR LOCAL READ_ONLY FOR
Select s.name from sysobjects s
where s.xtype<>'PK' AND s.xtype<>'F' AND s.xtype<>'IT' AND s.xtype<>'D'
AND s.xtype<>'C' AND s.xtype<>'U' AND s.xtype<>'S' AND s.xtype<>'UQ |
|
