.comment-link {margin-left:.6em;}

Ben Cops

Tuesday, May 20, 2008

BizTalk 2006 R2: Troubleshooting Problems with MSDTC

Troubleshooting Problems with MSDTC

Finally, an authoritative treatment of the DTC configuration required to install and operate BizTalk in a multi-server environment.

Note the provided table of recommended values for various DTC security settings in different scenarios - e.g. Incoming caller authentication, not mutual when MSDTC is running on a cluster.

Monday, May 19, 2008

BAM Setup and Configuration : Troubleshooting in BAM Portal Configuration

BAM Setup and Configuration : Troubleshooting in BAM Portal Configuration: "IIS is not 32-bit enabled"

IIS 6.0+ must be enabled to run 32-bit Web applications on 64-bit machines in order for the BAM Portal to function. You can enable by running the command:

cscript.exe %windir%\Inetpub\AdminScripts\adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 1

Thursday, May 01, 2008

mattberther.com » Drop all stored procedures

mattberther.com » Drop all stored procedures:

A useful script to drop all sprocs (prior to updating them all, for example)

USE myDatabase

declare @procName sysname

declare someCursor cursor FOR
SELECT name FROM sysobjects WHERE type = 'P' AND objectproperty(id, 'IsMSShipped') = 0

open someCursor
fetch next FROM someCursor INTO @procName
while @@FETCH_STATUS = 0
exec('drop proc ' + @procName)
fetch next FROM someCursor INTO @procName

close someCursor
deallocate someCursor