Got it. Thanks! The HTML you seen was the beginning of my string to delete, and the end of my string to delete. This was a piece of code that...

Thank you sir!

Thanks a lot! I am a little miffed as to where I insert this code into my current query... just so you know here is my query:

SELECT ...

Steve Jones - Editor (7/7/2008)

---

A couple of things.

Be sure the remote connection is using TCP/IP on both sides. It must be enabled on the server and set to be used...

Let me elaborate a little. I apologize for the lack of information...

This is MS SQL Server 2005 Standard edition. Surface Area Configuration shows that remote connections are allowed and that...

Thanks for the feedback guys. I was able to write a simple SP/cursor that would write the infected tables/columns in a specific database to a table that I created (temporarily)....

Well, if at first you don't succeed... I got it working. I had put the trigger on the wrong table's insert. Put it on the right table and BLAMO! It...

Okay, well I got the trigger to fire with no errors, however it doesn't actually do anything. Here is the code.. let me know if I am missing something. Thanks!

...

Ok I figured out the first thing I did wrong. The tables I was calling on were not right. To simplify things I wanted to use the filtered views because...

I had just given you generic names. The table that has the column that needs to be updated (the currentbudgetbalance column) is on a table called new_budgets. Full string would...

OKAY so I updated your code to put all of my literal table/column names in where I thought they would go, and I got an error. The error is:

Msg...

I understand to an extent how those tables work, I just having some trouble figuring out the actual code for the trigger to make it do what I would like...

If I include an ELSE in my CASE statements then all of those 'empty' rows return whatever is in my ELSE. I still get back 2 seperate rows. The ones...

Select YouGotAPrettyMouth

from SquealLikeAPig

Where Mouth like '%pretty%'

That is the SEQUEL to Deliverance... bad pun...

I have made a few changes using the information you have supplied. I will try it out for a day and see what happens. Thanks!