Gurus needed for SessionProperty

Last Post 08 Sep 2004 12:51 PM by NurySword. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
NurySword
New Member
New Member

--
08 Sep 2004 12:51 PM
Hi All,

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

SELECT SESSIONPROPERTY('replication_agent')
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..
Regards,
Nury SWORD
You are not authorized to post a reply.

Acceptable Use Policy