Hi all
when i use SELECT HOST_NAME() in query editor the result is the host name of client this is true result
but when i put HOST_NAME() as default value of column the result value i server name not client this is false value
i want client host name not server host name in default value of column
Thanks Khatn.
There is no trigger, the problem was in CDC system.
the default value of column in CDC table that execute the even from server not client server.
when i try to do host_name in default column in my table not CDC table it works fine
Note: CDC = Change Data Capture.
thanks you.