Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Linked Server Stored Proc. in service program.
1 view
Skip to first unread message
s...@nospamxyz.com
Feb 8, 2009, 10:12:45 PM2/8/09
to
I have stored proc which is a service program for the target que. This proc
executes linked server queries.
i was reading "Pro SQL Server 2005 Service Broker, by Klaus" it says we have
to sign the stored procedure with a certificate and map a user to this
certificate to be able to execute on other database.
executes linked server queries.
i was reading "Pro SQL Server 2005 Service Broker, by Klaus" it says we have
to sign the stored procedure with a certificate and map a user to this
certificate to be able to execute on other database.
Our sql server runs with domain account. if i create a domain user and map
the user in linked server and grant appropriate access
to linked server database do i still need to sign the stored procedure.?
Thx!
0 new messages