Monday, March 26, 2012

Replication Dynamic Filter SQL SERVER 2005 June CTP and Mobile 200

I'm trying to filter an article by a Int field with the following
ID=CONVERT(int,HOSTNAME()), but ID=CONVERT(int,'1') works. This used to work
in previous versions.
Thanks Mike Smith
The CONVERT errors out with convertion from nvarchar to int not allowed.
Also, I know the function is HOST_NAME(). Typo.
Thanks Mike Smith
"msmith" wrote:

> I'm trying to filter an article by a Int field with the following
> ID=CONVERT(int,HOSTNAME()), but ID=CONVERT(int,'1') works. This used to work
> in previous versions.
> Thanks Mike Smith

No comments:

Post a Comment