sql server - How to find the names of recently dropped functions? -
apparently can find drop operations in log using:
select * sys.fn_dblog(null, null) [transaction name] in ('dropobj');
but need find out dropped (name of function, aggregate etc.) , log seems contain ids , binary data , not name. how names of dropped objects (ideally without use of 3rd party tools)?
Comments
Post a Comment