I was interested in finding out where the references are for the dll(s) our developers have created and installed, but now I am a bit confused.
I did a query for the assemblies we loaded, select * from sys.assembly_files, but I can only do that query on a database where the assemblies are installed. If I "use master" or "use msdb" and do my select statement, I get nothing????
Are assemblies DB specific? Or are the loaded at the "Server Engine" level? BOL was a bit cryptic on this...
The reason I ask is that we have a newer set of assemblies/dll(s) that are available but, as of yet, untested.
Can one DB use assemblies/dll(s) in one file location and other db(s) use the same-named assemblies/dll(s) in a different location?
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)