Too Many!!!

Why does everyone think their third party applicaiton needs its own dedicated SQL Box? The vast majority of these sql boxes do virtually nothing.

Terry

ERROR_PROCEDURE() returns the stored procedure OR trigger name where an error occurred

Good to hear

This is when logged into to sql05 box. It is not a "double hop" situation.

FYI...to get double hops to work, you need to set up servers and accounts running...

Join the club!

Your case sound like you need to enable named pipes on the server you are linking to. If that is already enabled (and it requires a restart)...

If you...

First, run the query through SMS to get better error messages. There are several potential issues, including the one Frank talks of.

Terry

Bhushan,

Thank you for the feedback

Using instcat solves schema binding issues only. This is not what I am experiencing and I have run instcat on the 2000 boxes.

Terry

Brian,

It is good to know that someone is proofreading. Sometimes I wondered...

I do think that corrections/clarifications should be part of the SSC site. Many ppl rely on this site, often...

Some progress but no solution.

A work around is to create an alias with the same name as the remote server, and force it to use named pipes (important that...

Are you sure that this applies to SQL2005 as the question states. The statement "Once allocated, AWE-mapped memory cannot be released until SQL Server shuts down" is specific to SQL2000.

Terry

The servers accept windows and sql logins.

The linked servers need to use the secruity context of the logged in user, and therfore must be made with windows authentication. Audidting...

Thanks for the personal reflection.

I just want to say it is not sad to contemplate your own death. It can be a very powerful force in your spirituality. Everyone...

Especially with 2005, there are fewer and fewer reasons why you would need Enterprise over Standard. I am surprised not more is being written about this. Many of us have...

Another bogus question and answer, and I don't want to even spend the time elaborating...

Where is the QA in QOD?

Terry

It gets a little old having to second guess the QOD. I knew the syntax was incorrect, so (D) None of the Above was the only true correct answer, but I...