Sample Header Ad - 728x90

How to tell what user has synced

2 votes
1 answer
264 views
I have set up merge replication web sync to sync a publication from a SQL Server 2012 database. I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME(). When I do a sync is it possible to find somewhere what the values of SUSER_SNAME() and HOST_NAME() actually were for that sync? E.g. in the system tables. I will need to experiment with security to work out what settings will affect these values, but I will need to find out what these values actually are to verify my settings.
Asked by peter (2187 rep)
Jun 12, 2012, 11:08 PM
Last activity: May 26, 2025, 01:08 PM