SELECT "OWNERID","OWNER","BASEOBJECT","DEFINITION","WHENCLAUSE","ACTION","ENABLED","TPROPERTY","NAME","BASENAME","BASETYPE","PROPERTY","BTOWNER","BTOWNERID","SYS_EVTS","SQLVER","ACTIONSIZE"
FROM sys.exu816tgr
WHERE (ownerid, basename) IN (
SELECT ownerid, name
FROM sys.exu81tabi)
UNION ALL
SELECT "OWNERID","OWNER","BASEOBJECT","DEFINITION","WHENCLAUSE","ACTION","ENABLED","TPROPERTY","NAME","BASENAME","BASETYPE","PROPERTY","BTOWNER","BTOWNERID","SYS_EVTS","SQLVER","ACTIONSIZE"
FROM sys.exu816tgr
WHERE (ownerid, basename) IN (
SELECT ownerid, name
FROM sys.exu8vinfi)
SELECT "OWNERID"
, "OWNER"
, "BASEOBJECT"
, "DEFINITION"
, "WHENCLAUSE"
, "ACTION"
, "ENABLED"
, "TPROPERTY"
, "NAME"
, "BASENAME"
, "BASETYPE"
, "PROPERTY"
, "BTOWNER"
, "BTOWNERID"
, "SYS_EVTS"
, "SQLVER"
, "ACTIONSIZE"
FROM SYS.EXU816TGR
WHERE (OWNERID
, BASENAME) IN (
SELECT OWNERID
, NAME
FROM SYS.EXU81TABI)
UNION ALL
SELECT "OWNERID"
, "OWNER"
, "BASEOBJECT"
, "DEFINITION"
, "WHENCLAUSE"
, "ACTION"
, "ENABLED"
, "TPROPERTY"
, "NAME"
, "BASENAME"
, "BASETYPE"
, "PROPERTY"
, "BTOWNER"
, "BTOWNERID"
, "SYS_EVTS"
, "SQLVER"
, "ACTIONSIZE"
FROM SYS.EXU816TGR
WHERE (OWNERID
, BASENAME) IN (
SELECT OWNERID
, NAME
FROM SYS.EXU8VINFI)
|
|
|