Viewing 6 posts - 1 through 6 (of 6 total)
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...
February 19, 2003 at 7:41 am
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...
December 4, 2002 at 9:28 am
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...
December 4, 2002 at 7:33 am
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...
December 3, 2002 at 1:08 pm
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.
December 3, 2002 at 11:20 am
The way these servers are set up we do not have permission to set up link servers. Is there any other way....
December 2, 2002 at 12:11 pm
Viewing 6 posts - 1 through 6 (of 6 total)