Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I have set up merge replication web sync to sync a publication from a SQL 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 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.

share|improve this question
I don't believe SQL Server tracks this by default. You could likely set something up to do it going forward using extended events (or trace). – Aaron Bertrand♦ Jun 12 '12 at 23:35

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.