sql server replication: problems with merge replication subscriber validation -- sql server replication

problems with merge replication subscriber validation

Darren
10/31/2003 8:40:17 AM

sql server replication: I've noticed some strange behaviour when validating a subscriber against
SUSER_SNAME().
Users have been noticing the following error:

Merge Replication Provider: The merge process detected a mismatch while
evaluating the subscriber
partition validation expression. The problem can be resolved by
reinitializing the subscription.

In the sp_addmergepublication call I set the @validate_subscriber_info =
N'SUSER_SNAME()'

It seems the SUSER_SNAME() function does not return the account name as it
is defined but
exactly what is passed to authentication.

ie: if I login as darren SUSER_SNAME() returns darren, if I login as DARREN
it returns DARREN

problem is that @validate_subscriber_info is case sensitive.

All examples of using @validate_subscriber_info use either SUSER_SNAME or
HOST_NAME so
either this is a bug with SUSER_SNAME() (I think it is a bug) or the
documentation needs to be
clear.

My complaint is SUSER_SNAME() should be equalavent to
SUSER_SNAME(SUSER_SID())

Re: problems with merge replication subscriber validation

TSVK [MSFT]
11/2/2003 3:52:48 PM

Thanks Darren. Let me verify what you say and take it up.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
[quoted text, click to view]