GAC referencing incorrect version of dll.

[fguihen]

not sure if this is an SQL issue or a development issue, but as im using c# and visual studio so il place this here for now.

 

 

 

I wrote a small app to script out jobs from sql server. it worked fine, and then , without any changes it stopped working. I got the error:

 

 

 

Could not load type

 

'Microsoft.SqlServer.Managment.Smo.AgentJobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, publicKeyToken=89845dcd8080cc91'.

 

 

 

 

I checked the version of the Microosft.SqlServer.Managment.Smo Dll installed in sql server installation dir, and its version 9.00.1399.00, so i try to update the gac . The version in the gac is 9.0.242.0. I cannot delete it via the gac MMC plugin as it tells me it is required by another app. I cannot delete it via GacUtil for the same reason. I went to the windows directory to the assemblies folder and tried deleteing it there, but also could not as it is required by another application.

 

 

 

How do i delete the old version from the gac and install the new version?

 

I was going to try editing the registry, but when i searched for that specific assembly "Microsoft.Sqlserver.Managment.Smo, i find thousands of entries, and i am not editing each one. that would take me days.

 

 

 

Any help would be greatly appriciated.

[PlausiblyDamp]

What version of SQL / Service pack have you got / had installed? It might be worth re-installing the latest service pack and see if that fixes the problem.