RE: How to list the version number of an assembly and in which database it exists

Lowell

SSC Guru

Points: 323504

June 6, 2012 at 12:58 pm

#1497859

you could query sys.assemblies;

i'm sticking the results in a global temp table for ease of reporting, for example:

CREATE TABLE [dbo].[##RESULTS] (

[DBNAME] NVARCHAR(128) NULL,

[ASSEMBLYNAME] SYSNAME NOT NULL,

[ASSEMBLYVERSION] NVARCHAR(4000) NULL)

EXECUTE sp_msForEachdb 'INSERT INTO ##RESULTS select ''?'' As dbName,name As AssemblyName,clr_name as AssemblyVersion from [?].sys.assemblies '

SELECT * FROM [##RESULTS]

ORDER BY [ASSEMBLYNAME],[ASSEMBLYVERSION],[DBNAME]

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!