As I understand it TRUSTWORTHY is new to SQL 2005.  What is the equivalent
in SQL 2000?

Or, more specifically, I cannot get a SQL Job to pull data from a Linked SQL
2000 server to an SQL 2005.  I've tried setting the 2K database's
trustworthy on.  Doesn't work.  I've tried using the impersonate in my
linked server setup using both the sa user and a domain admin user.  Neither
worked.  I've tried pushing the data from the 2K to the 2K5, doesn't work.
I'm sure there's an answer, but I can't find the correct authentication
combination.

Thanks,

Ross

(rcul***@ranger-systems.com) writes:
There is not any. It's a new concept, so there is on reason to expect
anything in earlier releases.

What error messages do you get? Can you access any database at all on
the linked server? How have you defined the linked server? Have you set
up any linked-server logins?

Trying to match lowercase
too long...
datetime between problem
SQL Join question - getting most recent value in a history table
Select problem Msg. 156