[Resolved] Design question and suggestion

I have a table that resides on a MS server 2003. This table is a job table and contains job number and job description. I have been asked to develop an inquiry application (plan to use gridview). When a user enters the application he will see all the jobs that he autorized to view. The actual authorization table resides on a db2 platform (AS/400). This leads to my question:

Will I be able in a single stored procedure combine data from db2 and server 2003? When user logs on I will show only jobs from the job list table that matches authorized jobs from the db2 table. Is it better to create a permanent table on the server (based upon db2 data) that contains authorization?

The server 2003 does not allow me to create linked server that would solve this issue.

Suggestions please. Thank you.

You mentioned that it doesn't allow you to create a linked server.

I found this link where someone asks a simlar question and it has 2 replies to it.

Might be worth a look.

http://www.dbforums.com/archive/inde...t-1192120.html

You are right, it is possible. Thank you.