Hi,

I have a stored procedure that transfers some data to a remote database
(same server). The sp is fired on user activity with an application.

The issue I have is that the users access the local database via a unique
login, which is not present in the remote db - and thus the sp fails when
run under any account other than sa.

I know I could permission all the users to acces the other db, but I hve my
reasons for not wanting to do that.

So, how can I ensure this sp (or the internal data transfer) happens under a
single account (sa will do)

Thanks

Jane

I am not usre how you are accessing the remote server, but you might be
able to accomplish the same thing using a linked server and set the
security to a specific SQL login.

Other than that I do not believe there is another way to do this.

Rand


This posting is provided "as is" with no warranties and confers no rights.