And when you get that answer, what is the next question?

Now, what have you tried in order to solve your problem?

Also look at the connection settings for the users, there may be difference between the users there.

It looks to me like the problem is on the SQL Server side since all the users you try are using the same credentials on the Oracle side.

I would start...

interesting part is that this only happens when I run that query under SA user.  When execute that query under different name, then everything ok. I decided to firstly...

Gee...

Grant just told you:

So, capturing sp_statement_completed or sql_statement_completed would, in fact, capture the trigger.

Also, let's give some context to the whole thing by hopping in the wack machine and revisit the two threads here on SSC.

https://www.sqlservercentral.com/forums/topic/bankers-rounding

https://www.sqlservercentral.com/forums/topic/round-to-even-aka-bankers-rounding-the-final-function

Also, if you do the research you will also find the banker's round, also called round to even is used in signal processing as well.

There are numerous articles on the...

If you are going to use my name, please make sure you spell correctly.

Okay, I am not going to try to write any code until I have a good understanding of what you are attempting to accomplish.

First you are converting from Oracle to...

I hate to say it, but this looks like a set up for failure. The old joke about how do you eat an elephant comes to mine, one bite at...

Out of curiosity, what have you tried to solve this problem?

I ask because I already see one possible solution.

Yesterday my work announced that they were extending the work from home policy at least through Labor Day.  With me living in one state and working in another,...

The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00...

The U.S. Congress decided (wisely for once) that they wanted people to want to stay home without worrying about the bills. So they authorized an extra $600.00 per (I...