Home Forums SQL Server 2005 Administering 1 sp out of 4 not executing even though user has execute permissions on all 4 RE: 1 sp out of 4 not executing even though user has execute permissions on all 4
lptech
Hall of Fame
Points: 3188
More actions
January 7, 2013 at 1:42 pm
#1574519
Have you tried running the linked server query from SSMS both as yourself and with the EXECUTE AS USER = ? It could be a permissions issue with the other DBMS that is sending back a return code that SQL Server is mis-interpreting.