Viewing 3 posts - 1 through 3 (of 3 total)
Thank you for the response, but no. The user logged in is Userx. The stored procedure executes as UserX. Not exactly the same situation
I can create this...
July 27, 2015 at 11:46 am
#1815223
User is in both databases.
July 24, 2015 at 6:40 am
#1814723
DECLARE @SN NVARCHAR(128);
EXEC master.dbo.xp_regread
'HKEY_LOCAL_MACHINE',
'SYSTEM\CurrentControlSet\services\MSSQLServer',
'ObjectName',
@SN OUTPUT;
SELECT @SN;
July 23, 2015 at 11:45 am
#1814482