There are some issues with the VB.NET code.

-- Steps onto soapbox

I suggest implementing some .NET best practices. Enclose every connection in a Using block, don't use Catch clauses without...

I think I said "stuff it into an update trigger." Yeah, right. Well, for anyone who's interested, these are the final triggers. I had to remove the cascade updates from...

Sometimes asking other people makes the answer show up in my mind. The posted code below works. I think I can stuff it into an INSTEAD OF UPDATE trigger with...

1998 New Beetle, yellowish-green (official color name was Cyber Green)

Attractive car, different, makes people think, fast and powerful engine for the car's size, gets to 90 mph before you realize...

Thanks for information on extended events. I don't have permission to view them, but I've sent an appropriate query to those who do.

It's not clear from your CASE statement what the intended result is.

The CASE statment isn't a Boolean expression, it's just an expression. The entire CASE ... END is like a...

I wonder why the ISNULL doesn't prevent State and City joins from using an index, but ISNULL on the Zip does?

If you remove the State and City joins, and provide...

BEGIN TRY DROP TABLE #AUM_Raw_Upload1 END TRY BEGIN CATCH END CATCH;

BEGIN TRY DROP TABLE #temp1 END TRY BEGIN CATCH END CATCH;

BEGIN TRY DROP TABLE #temp2 END TRY BEGIN CATCH END...

Thanks for the link. The site is blocked by my employer, so I'll take a look at it from home some time.

William Plourde (3/5/2012)

---

Without going into detail we store every version of every row for our primary entities. We also use this data to export any changes back to vendor systems...

venoym (3/2/2012)

---

Stephanie Giovannini (3/2/2012)

---

So, how would you fix the posted code so that the uncommittable transaction message isn't reported?

I'm curious which COMMIT statement is causing the error. There's a COMMIT...

So, how would you fix the posted code so that the uncommittable transaction message isn't reported?

I'm curious which COMMIT statement is causing the error. There's a COMMIT statement after the...

At one time I was a PowerBuilder developer. In 1996, PowerBuilder was a meal ticket. By 2001, the writing was on the wall for PowerBuilder. My employer used only PowerBuilder,...

No, no, no, it doesn't work at all.

The server I'm using is a named instance. The "successful link" was actually referrring to the default instance on the same box. It...

I've got this working, mostly. I used this script: (IP address replaced with zeros)

exec sp_addlinkedserver @server = 'LINK1',

@srvproduct = '',

@provider= 'SQLNCLI',

@provstr = 'Library=DMBSSOCN;ServerName=000.000.000.000,1433'

Now I have the...