How to check newly create SQL Server objects

select
–distinct so.type objType —
so.name, su.name, so.crdate, so.type objType
from
sysobjects so
join
sysusers su on so.uid = su.uid
where su.name not like ‘sys’
order by
so.crdate

Leave a Reply

Your email address will not be published. Required fields are marked *