a question on the same line...I have been trying to do the same exact thing

When I turn the audit level do I have to restart the server??

Also where does the...

Hi Andreas,

Here are the changes I did, as per your last reply, to the code...still getting the same access denied error..

Any permissions that I need to check?

SET @Query = 'Select...

Here is the code that I added to the stored proc that calls the proc on the remote server:

===

Select @user_ssn

From OPENROWSET('provider','server_name';sa;pswd,

'Exec sp_executesql EXEC db.dbo.proc_name @parameter1,

@parameter1 varchar(20),

@parameter1')

AS a

=====

The calling...

I tried the OPENROWSET option.

Is there any particular permission that the user needs to have to execute it??

I keep getting the "server does not exist or access denied error"

I know...

I am going to try OPENROWSET with dynamic sql as I do need to pass parameters. Thanx for the help. Will let you know how it works shortly.

The way these servers are set up we do not have permission to set up link servers. Is there any other way....