I am trying to find out how can I set undocumented SET options in a SQL session context. For example there is replication_agent session option. I can get the value of that option
but I don't know how to set it.
As we all know there are lots of other SESSION options which are set like that for example :
SET CONCAT_NULL_YIELDS_NULL ON
SET NOCOUNT ON
SET ROWCOUNT 10
But the question is how can I set replication_agent session option in T-SQL? Or can I set it? Moreover can I set other named options as I like, let's say : my_option
Is there any syntax or system stored procedure for setting customized SET Options??
Thanks in advance..