Viewing 2 posts - 1 through 2 (of 2 total)
yes, 15 seconds for
select hashbytes('sha2_256',o1.name)
from sys.all_objects o1,sys.all_objects o2
i agree in advance sha2_256 (and 512) needs sql 2012
kr/Werner
October 7, 2013 at 7:42 am
#1656332
nice solution yes,
but not only objects in dynamic sql are ignored, also simple called routines from different databases like
"OtherDB.dbo.usp_whatever" . Of course this would require to parse the t-sql...
regards
Werner
October 30, 2012 at 3:13 am
#1554044