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)?

please see below images hope enter image description here


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -