Do enabling/disabling xp_cmdshell has effect on replication setup?
We have transactional replication setup with our SQL Sever 2014.
1 Answer
Do enabling/disabling xp_cmdshell has effect on replication setup?
No. They are independent features.
Also, it's recommended to generally keep xp_cmdshell disabled, from a security best practice standpoint:
xp_cmdshellis a powerful feature and disabled by default.
-
Yes sir. I too was thinking of the same until I came across the following articles as below, mssqltips.com/sqlservertip/4912/… pythian.com/blog/technical-track/… sqlservercentral.com/forums/topic/… Attaching a screenshot depicting usage of xp_cmdshell within our DB and I am seeing results with 'repl' 'distribution' subscription' 'publisher' kind of words. So thought to check with it.– Meera KCommented Jul 24 at 12:37