If its enabled...verify you have the right password...still strongly recommend against using the sa account. 🙂

Yes I did, it did not return any data. I did figure it out though from another source... I was making it incredibly more difficult than it had to...

I suppose of there was another way to loop through the original data structure by issue_num and find all instances where the column_value was all 0's or all -'s for...

Hi thanks for the reply, I guess I wasn't entirely clear... I already have the data formatted how I want it which is the concatenated result set that I listed....

I use linked servers a lot and I would generally advise against using an SA account for a linked server. Just a little too dangerous in my opinion. ...

Thanks! I will try that.

And yea I know the naming thing isn't anything special. I just did it mostly cause I liked having it named... 😛 But...

Ok, so I did some more digging cause I kept thinking about what you said that removing the name of the transaction should have made the error go away.... however...

Sorry let me clarify, removing the name changes the error to something else. I can do it again and provide the exact one when I'm back at my computer.

Also...

Removing the transaction name does not rectify the situation.

The only thing that I could think of was we do have an if statement that calls another stored procedure with...

Well ok, I guess neccessity is the mother of invention and I finally got this to work myself after days of frustration. 🙂

I finally figured out that in order to...

Nobody has any ideas?

LOL, Lowell got to it first... took me a few minutes to type all that up... 😛 At least we both said the same thing hehe!

How big are the tables on the other server?

I use linked servers quite extensively between SQL and also Oracle and sometimes you have to play around with how you do...

I still haven't figured this out. 🙁

Right right, I get ya... for us, the "direct" part is doing it directly from database to database. But yea, different topic. 😉

No, the views are not using multiple...