25.07.2023
12:38
Hi,
I have a problem with the execution of SQL queries in different environments using a Default connection (after moving the system to AZUR-e servers).
SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that causes the execution of TEST SQL may be different than the rest of the environments?
Test server query execution:
declare @cookie************************************** varbinary(8000);
execute as user = 'bps_user' with cookie into @cookie**************************************;
begin try
exec('select top 100 * from (
select * from ZZ_Działy_PIT
) as nnn
');
end try
begin catch
revert with cookie = @cookie**************************************;
throw;
end catch;
revert with cookie = @cookie**************************************;
Dev / Prod query execution
select top 100 * from (
select * from ZZ_Dostawca
) as nnn
