Loading...

[neumann]

SELECT B.NAME AS OWNER, A.NAME, A.TYPE FROM sysobjects A JOIN sysusers B ON A.UID = B.UID WHERE A.TYPE IN('U', 'IF', 'TF', 'V', 'P') AND A.STATUS >= 0 ORDER BY A.TYPE, A.NAME