Geeks With Blogs
Andy Morrison's BizTalk Blog Help, I've fallen and I can't BizTalk! December 2005 Entries
BizTalk SQL Scripts for Troubleshooting Deployments
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 ......

Posted On Sunday, December 18, 2005 5:14 PM

New Blog Location

I moved my BizTalk blog to this location.  My old blog can be found at

I'm not going to re-post anything at this point but I might at a later date. 

Posted On Sunday, December 18, 2005 5:11 PM

Copyright © Andy Morrison | Powered by: