Hi,
It is really difficult from the description of the problem to give any good advice.
I looked at your MSDN forum post and found that to be just as vague.
Can you provide code samples for both the .NET application and the SQL stored procs that shows exactly how you create, intialise and use the SQL Connection, transaction and commands.
At the moment, I cannot see how you are doing these and so cannot possibly know what is happening.
I did, however, spot one thing that looked odd on your MSDN posts - you are passing the SQLTransaction BYVAL to the routine:
Public Function DoInitialInsert(byval CustomerID as string, byval Input as String, [highlight="#ffff11"]byval[/highlight] tran as SqlTransaction) as Int64
This strikes me as wrong - it should be ByRef - and may be part of the issue, but as I said, without a clear view of your code, I am guessing.
MM
select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);