CLR and SQL Function
Posted on 2013-01-24
Not my background at all
There is a clr process that was built and loaded on our sql server
In the database on that server is a function that consumes that clr.
When we try and do a select using the cfl(based) function, it just runs and runs.
Is there any way we can trace that and see at what point it stops?
After a while it just times out.
I see that I can look at the assemblie information with these selects
SELECT * FROM sys.assemblies WHERE assembly_id IN (66092,66093)
SELECT * FROM sys.assembly_files WHERE assembly_id IN (66092,66093)
SELECT * FROM sys.assembly_modules WHERE assembly_id IN (66092,66093) ORDER BY assembly_method