Since your pseudocode isn't in a Create Procedure format, we can't tell anything from what you've posted. For one, we don't even know if you've declared your input variables correctly.

Could...

Can you include Create Table statements and Insert statements with sample data? It would help us come up with a solution that works for you without it being broken.

Your problem is "Server ip".

An IP address has 3 periods (aka decimal points) in it. That is the 3 periods used by a linked server. Hence, the rest of...

I missed this when I looked earlier. Table sys.servers has a column called collation_name. Mine is NULL because we use the default, which is based on the OS collation. (Note:...

I haven't used Except yet, and I seldom use Not Exists. But now, I'm going to try and see what I come up with.

You're probably crazy, but that doesn't...

Okay, I do have a question. Is this query for a report?

You can't have line item detail and a summary together that will display correctly in SSMS. You get to...

Ignoring Celko's comment about best SQL programming practices (which he and I will always disagree on to some extent), he's correct that we need more information in order to assist...

Hence my edited comment.

I'm trying to figure this one out. I know that sys.databases has collation, but I'm not sure where the server information is or even if that's where...

Sorry, but Chris's solution is probably the best solution you will get without posting the code that's causing you this heartache. We need to see the problem in order to...

Have you tried running sp_helptext on the function?

EDIT: Nevermind. Apparently it doesn't work on this function.

A little funny for the day.

I was having problems with the internet yesterday (and SSC). Then, later, my SO was responding on another forum to someone else who was having...

There's a very specific set of articles on SQL Server and LUN setups somewhere that I cannot find or remember the titles of that could help you out. I'm going...

Do you have a 2k8 server in the domain that VS2k5 is in? Have you tested the connection that way?

I'm wondering if there's a problem with VS2k5 seeing SQL Server...

Glad we could help.

In an effort to not scare you off of full-text, I've called in reinforcements to offer alternatives. I have, unfortunately, reached the limit of my knowledge in this subject.