Replication enhancement in Yukon

Hi ,
Some info is required related to the same .
Any article please .
Thanks
ARR
Have a look here. This is where you can find a lot of 2005 related
information.
http://www.microsoft.com/sql/2005/default.asp
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:O5D0lE4BFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi ,
> Some info is required related to the same .
> Any article please .
>
> Thanks
> ARR
>

Replication enhancement in Yukon

Hi ,
Some info is required related to the same .
Any article please .
Thanks
ARRHave a look here. This is where you can find a lot of 2005 related
information.
http://www.microsoft.com/sql/2005/default.asp
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:O5D0lE4BFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi ,
> Some info is required related to the same .
> Any article please .
>
> Thanks
> ARR
>

Replication enhancement in Yukon

Hi ,
Some info is required related to the same .
Any article please .
Thanks
ARRHave a look here. This is where you can find a lot of 2005 related
information.
http://www.microsoft.com/sql/2005/default.asp
--
Andrew J. Kelly SQL MVP
"Aju" <ajuonline@.yahoo.com> wrote in message
news:O5D0lE4BFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hi ,
> Some info is required related to the same .
> Any article please .
>
> Thanks
> ARR
>sql

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

Replication does not work properly

Hi,
I have a problem with rows deleted at subscriber could not get deleted at
publisher in particular case where article published say table1 has row
filter like
"SELECT <published_columns> FROM [dbo].[TABLE1]
WHERE ([FILED1]='XYZ ' OR [FIELD4]= 'XYZ ') and FIELD3 in(select
[FIELD3] from [TABLE2] A where A.[FIELD1]=[FIELD1] and A.[FIELD2]=[FIELD2] )"
Rest of the Articles published with simpler row filter works perfectly.
Please Reply,
Thanking You
fatiya
are both Table1 and Table2 published? are there any constraints between teh
two tables? Are you enforcing these constraints for replication? Cascading
Updates/Deletes?
Have you used the conflict viewer to see if there are any conflicts?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
news:6A20CE4B-7D05-4202-BCEE-79AC26E28326@.microsoft.com...
> Hi,
> I have a problem with rows deleted at subscriber could not get deleted
at
> publisher in particular case where article published say table1 has row
> filter like
> "SELECT <published_columns> FROM [dbo].[TABLE1]
> WHERE ([FILED1]='XYZ ' OR [FIELD4]= 'XYZ ') and FIELD3 in(select
> [FIELD3] from [TABLE2] A where A.[FIELD1]=[FIELD1] and
A.[FIELD2]=[FIELD2] )"
> Rest of the Articles published with simpler row filter works perfectly.
> Please Reply,
> Thanking You
> fatiya
>
>
|||Dear Hilary
Thanks for reply
Yes both table 1 and table2 are published No there are no contrainst between
them
we have not used any cascading
We are getting replicaion conflicts that the row was inserted at subscriber
but
at publisher we are getting primary key constrains.
Please advice
Fatiya
"Hilary Cotter" wrote:

> are both Table1 and Table2 published? are there any constraints between teh
> two tables? Are you enforcing these constraints for replication? Cascading
> Updates/Deletes?
> Have you used the conflict viewer to see if there are any conflicts?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Fatiya" <Fatiya@.discussions.microsoft.com> wrote in message
> news:6A20CE4B-7D05-4202-BCEE-79AC26E28326@.microsoft.com...
> at
> A.[FIELD2]=[FIELD2] )"
>
>
sql