Here's a sql script I use against the BizTalkMgmtDb when I'm debugging issues that I think are caused by botched deployments: SELECT nvcName AS AssemblyName, nvcVersion AS Version, DATEADD(hh, DATEDIFF(hh, GetUTCDate(), GETDATE()), dtDateModified) AS DateModified, nvcModifiedBy AS ModifiedByFROM bts_assemblyWHERE (nSystemAssembly = 0)ORDER BY AssemblyName It returns the assembly name, version, the date it was modified (deployed) and who deployed it. The DATEADD stuff is to put the dates into the...

• Share This Post:
• 
• 
• 

I moved my BizTalk blog to this location. My old blog can be found at http://blog.magenic.com/andym I'm not going to re-post anything at this point but I might at a later date.

• Share This Post:
• 
• 
•