Viewing 3 posts - 1 through 3 (of 3 total)
Thanks guys. I have told the devs that I will create an account for them to use and they have to stop using the sa account for their processes.
December 12, 2017 at 6:24 am
#1971731
The stored procedures are updating tables in the same database but does call a linked server. Does the Linked Server user need to impersonate the sa on both servers?
December 12, 2017 at 5:33 am
#1971718
It returns the following:
sysadmin1
December 12, 2017 at 5:13 am
#1971714