Book on Merge Replication

I need to learn Merge Replication inside and out. Can someone please suggest
a book/websites etc on Merge Replication?
Thanks.
AdamAdam
If you are lucky Hillary will jump in ,so you are going to get the right
direction
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>I need to learn Merge Replication inside and out. Can someone please
>suggest
> a book/websites etc on Merge Replication?
> Thanks.
> Adam|||Unfortunately, I think Hilary is still finishing his book on the topic --
I'm not aware of any currently available titles
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Adam
> If you are lucky Hillary will jump in ,so you are going to get the right
> direction
>
> "Adam" <Adam@.discussions.microsoft.com> wrote in message
> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>|||There aren't any books published on it at the moment. There are several in
the works though.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Adam
> If you are lucky Hillary will jump in ,so you are going to get the right
> direction
>
> "Adam" <Adam@.discussions.microsoft.com> wrote in message
> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>|||Do you have any more information? Who is writing them and for what
publishers? I don't see any that have been registered with Amazon, except
this one:
http://www.amazon.com/gp/product/06...5Fencoding=UTF8
(incidentally, this one looks like it's going to be pretty good)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uFucMYWdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> There aren't any books published on it at the moment. There are several
> in the works though.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
>|||That's one of them. I'm working on a set of 3 replication books, 1 solely
on merge replication. But, JC and I have to finish the 443 Training Kit for
MSPress first.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23um9DGddGHA.4128@.TK2MSFTNGP05.phx.gbl...
> Do you have any more information? Who is writing them and for what
> publishers? I don't see any that have been registered with Amazon, except
> this one:
> http://www.amazon.com/gp/product/06...5Fencoding=UTF8
> (incidentally, this one looks like it's going to be pretty good)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:uFucMYWdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>

Book on Merge Replication

I need to learn Merge Replication inside and out. Can someone please suggest
a book/websites etc on Merge Replication?
Thanks.
AdamAdam
If you are lucky Hillary will jump in ,so you are going to get the right
direction
"Adam" <Adam@.discussions.microsoft.com> wrote in message
news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>I need to learn Merge Replication inside and out. Can someone please
>suggest
> a book/websites etc on Merge Replication?
> Thanks.
> Adam|||Unfortunately, I think Hilary is still finishing his book on the topic --
I'm not aware of any currently available titles :(
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Adam
> If you are lucky Hillary will jump in ,so you are going to get the right
> direction
>
> "Adam" <Adam@.discussions.microsoft.com> wrote in message
> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>>I need to learn Merge Replication inside and out. Can someone please
>>suggest
>> a book/websites etc on Merge Replication?
>> Thanks.
>> Adam
>|||There aren't any books published on it at the moment. There are several in
the works though.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
> Adam
> If you are lucky Hillary will jump in ,so you are going to get the right
> direction
>
> "Adam" <Adam@.discussions.microsoft.com> wrote in message
> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>>I need to learn Merge Replication inside and out. Can someone please
>>suggest
>> a book/websites etc on Merge Replication?
>> Thanks.
>> Adam
>|||Do you have any more information? Who is writing them and for what
publishers? I don't see any that have been registered with Amazon, except
this one:
http://www.amazon.com/gp/product/0672327805/sr=8-1/qid=1147444522/ref=pd_bbs_1/104-6385614-0075127?%5Fencoding=UTF8
(incidentally, this one looks like it's going to be pretty good)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
news:uFucMYWdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> There aren't any books published on it at the moment. There are several
> in the works though.
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
>> Adam
>> If you are lucky Hillary will jump in ,so you are going to get the right
>> direction
>>
>> "Adam" <Adam@.discussions.microsoft.com> wrote in message
>> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>>I need to learn Merge Replication inside and out. Can someone please
>>suggest
>> a book/websites etc on Merge Replication?
>> Thanks.
>> Adam
>>
>|||That's one of them. I'm working on a set of 3 replication books, 1 solely
on merge replication. But, JC and I have to finish the 443 Training Kit for
MSPress first.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:%23um9DGddGHA.4128@.TK2MSFTNGP05.phx.gbl...
> Do you have any more information? Who is writing them and for what
> publishers? I don't see any that have been registered with Amazon, except
> this one:
> http://www.amazon.com/gp/product/0672327805/sr=8-1/qid=1147444522/ref=pd_bbs_1/104-6385614-0075127?%5Fencoding=UTF8
> (incidentally, this one looks like it's going to be pretty good)
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Michael Hotek" <mike@.solidqualitylearning.com> wrote in message
> news:uFucMYWdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>> There aren't any books published on it at the moment. There are several
>> in the works though.
>> --
>> Mike
>> http://www.solidqualitylearning.com
>> Disclaimer: This communication is an original work and represents my sole
>> views on the subject. It does not represent the views of any other
>> person or entity either by inference or direct reference.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:%235x7KPEdGHA.1656@.TK2MSFTNGP02.phx.gbl...
>> Adam
>> If you are lucky Hillary will jump in ,so you are going to get the
>> right direction
>>
>> "Adam" <Adam@.discussions.microsoft.com> wrote in message
>> news:2EC78112-3A15-484D-A0ED-965DC7E33FD9@.microsoft.com...
>>I need to learn Merge Replication inside and out. Can someone please
>>suggest
>> a book/websites etc on Merge Replication?
>> Thanks.
>> Adam
>>
>>
>

Blocking behavior of trigger and sp_send_dbmail

Hi Folks
I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
short: sp_send_dbmail inside of trigger results in blocked process and never
ends.
I wanted to code something simple the get notified if new rows were inserted
or updated in table.
create table t1 (col1 int, col2 int)
go
create table t2 (col1 int, col2 int)
go
create trigger tr_ins_t1 on t1 for insert, update
as
set nocount on
truncate table t2
insert t2
select * from inserted
exec msdb.dbo.sp_send_dbmail
@.recipients = 'gene_golub@.hotmail.com'
, @.subject = '!! sql1..t1 db : inserted new rows'
, @.query = 'select * from queries.dbo.t1'
go
insert t1 values(1,1)
go
side comment: inserted table was not recognized inside of query sql string
which would be executed by sp_send_dbmail so I had to use another table to
insert rows first and then to send them over.
When I insert simple row, my query hangs forewer.
What i see in sp_who: some process which is blocked by insert statement.
And this block does not resolve itself untill I go and kill process which is
bloced by insert stm.
I had no problem before using xp_sendmail inside of the triggers. Why it
become a problem with sp_send_dbmail?
Can anybody explain me what am I doing wrong?
thank you, Gene.
Hi Gene,
I have seen that behavior too. Would this work for you?
select * from queries.dbo.t1 with (nolock)
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Gene." wrote:

> Hi Folks
> I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
> short: sp_send_dbmail inside of trigger results in blocked process and never
> ends.
> I wanted to code something simple the get notified if new rows were inserted
> or updated in table.
> create table t1 (col1 int, col2 int)
> go
> create table t2 (col1 int, col2 int)
> go
> create trigger tr_ins_t1 on t1 for insert, update
> as
> set nocount on
> truncate table t2
> insert t2
> select * from inserted
> exec msdb.dbo.sp_send_dbmail
> @.recipients = 'gene_golub@.hotmail.com'
> , @.subject = '!! sql1..t1 db : inserted new rows'
> , @.query = 'select * from queries.dbo.t1'
> go
> insert t1 values(1,1)
> go
> side comment: inserted table was not recognized inside of query sql string
> which would be executed by sp_send_dbmail so I had to use another table to
> insert rows first and then to send them over.
> When I insert simple row, my query hangs forewer.
> What i see in sp_who: some process which is blocked by insert statement.
> And this block does not resolve itself untill I go and kill process which is
> bloced by insert stm.
> I had no problem before using xp_sendmail inside of the triggers. Why it
> become a problem with sp_send_dbmail?
> Can anybody explain me what am I doing wrong?
> thank you, Gene.
|||Hi Ben
Thank you for looking into this issue.
My example was simplification of real situation. Real table has about 1500
rows and wider.
nolock option does not help in that case.
Thank you, Gene.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Hi Gene,
> I have seen that behavior too. Would this work for you?
> select * from queries.dbo.t1 with (nolock)
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Gene." wrote:

Blocking behavior of trigger and sp_send_dbmail

Hi Folks
I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
short: sp_send_dbmail inside of trigger results in blocked process and never
ends.
I wanted to code something simple the get notified if new rows were inserted
or updated in table.
create table t1 (col1 int, col2 int)
go
create table t2 (col1 int, col2 int)
go
create trigger tr_ins_t1 on t1 for insert, update
as
set nocount on
truncate table t2
insert t2
select * from inserted
exec msdb.dbo.sp_send_dbmail
@.recipients = 'gene_golub@.hotmail.com'
, @.subject = '!! sql1..t1 db : inserted new rows'
, @.query = 'select * from queries.dbo.t1'
go
insert t1 values(1,1)
go
side comment: inserted table was not recognized inside of query sql string
which would be executed by sp_send_dbmail so I had to use another table to
insert rows first and then to send them over.
When I insert simple row, my query hangs forewer.
What i see in sp_who: some process which is blocked by insert statement.
And this block does not resolve itself untill I go and kill process which is
bloced by insert stm.
I had no problem before using xp_sendmail inside of the triggers. Why it
become a problem with sp_send_dbmail?
Can anybody explain me what am I doing wrong?
thank you, Gene.Hi Gene,
I have seen that behavior too. Would this work for you?
select * from queries.dbo.t1 with (nolock)
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Gene." wrote:

> Hi Folks
> I came accross very strange behavior of trigger utilizing sp_send_dbmail.
In
> short: sp_send_dbmail inside of trigger results in blocked process and nev
er
> ends.
> I wanted to code something simple the get notified if new rows were insert
ed
> or updated in table.
> create table t1 (col1 int, col2 int)
> go
> create table t2 (col1 int, col2 int)
> go
> create trigger tr_ins_t1 on t1 for insert, update
> as
> set nocount on
> truncate table t2
> insert t2
> select * from inserted
> exec msdb.dbo.sp_send_dbmail
> @.recipients = 'gene_golub@.hotmail.com'
> , @.subject = '!! sql1..t1 db : inserted new rows'
> , @.query = 'select * from queries.dbo.t1'
> go
> insert t1 values(1,1)
> go
> side comment: inserted table was not recognized inside of query sql string
> which would be executed by sp_send_dbmail so I had to use another table to
> insert rows first and then to send them over.
> When I insert simple row, my query hangs forewer.
> What i see in sp_who: some process which is blocked by insert statement.
> And this block does not resolve itself untill I go and kill process which
is
> bloced by insert stm.
> I had no problem before using xp_sendmail inside of the triggers. Why it
> become a problem with sp_send_dbmail?
> Can anybody explain me what am I doing wrong?
> thank you, Gene.|||Hi Ben
Thank you for looking into this issue.
My example was simplification of real situation. Real table has about 1500
rows and wider.
nolock option does not help in that case.
Thank you, Gene.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Hi Gene,
> I have seen that behavior too. Would this work for you?
> select * from queries.dbo.t1 with (nolock)
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Gene." wrote:
>

Blocking behavior of trigger and sp_send_dbmail

Hi Folks
I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
short: sp_send_dbmail inside of trigger results in blocked process and never
ends.
I wanted to code something simple the get notified if new rows were inserted
or updated in table.
create table t1 (col1 int, col2 int)
go
create table t2 (col1 int, col2 int)
go
create trigger tr_ins_t1 on t1 for insert, update
as
set nocount on
truncate table t2
insert t2
select * from inserted
exec msdb.dbo.sp_send_dbmail
@.recipients = 'gene_golub@.hotmail.com'
, @.subject = '!! sql1..t1 db : inserted new rows'
, @.query = 'select * from queries.dbo.t1'
go
insert t1 values(1,1)
go
side comment: inserted table was not recognized inside of query sql string
which would be executed by sp_send_dbmail so I had to use another table to
insert rows first and then to send them over.
When I insert simple row, my query hangs forewer.
What i see in sp_who: some process which is blocked by insert statement.
And this block does not resolve itself untill I go and kill process which is
bloced by insert stm.
I had no problem before using xp_sendmail inside of the triggers. Why it
become a problem with sp_send_dbmail?
Can anybody explain me what am I doing wrong?
thank you, Gene.Hi Gene,
I have seen that behavior too. Would this work for you?
select * from queries.dbo.t1 with (nolock)
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Gene." wrote:
> Hi Folks
> I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
> short: sp_send_dbmail inside of trigger results in blocked process and never
> ends.
> I wanted to code something simple the get notified if new rows were inserted
> or updated in table.
> create table t1 (col1 int, col2 int)
> go
> create table t2 (col1 int, col2 int)
> go
> create trigger tr_ins_t1 on t1 for insert, update
> as
> set nocount on
> truncate table t2
> insert t2
> select * from inserted
> exec msdb.dbo.sp_send_dbmail
> @.recipients = 'gene_golub@.hotmail.com'
> , @.subject = '!! sql1..t1 db : inserted new rows'
> , @.query = 'select * from queries.dbo.t1'
> go
> insert t1 values(1,1)
> go
> side comment: inserted table was not recognized inside of query sql string
> which would be executed by sp_send_dbmail so I had to use another table to
> insert rows first and then to send them over.
> When I insert simple row, my query hangs forewer.
> What i see in sp_who: some process which is blocked by insert statement.
> And this block does not resolve itself untill I go and kill process which is
> bloced by insert stm.
> I had no problem before using xp_sendmail inside of the triggers. Why it
> become a problem with sp_send_dbmail?
> Can anybody explain me what am I doing wrong?
> thank you, Gene.|||Hi Ben
Thank you for looking into this issue.
My example was simplification of real situation. Real table has about 1500
rows and wider.
nolock option does not help in that case.
Thank you, Gene.
"Ben Nevarez" wrote:
> Hi Gene,
> I have seen that behavior too. Would this work for you?
> select * from queries.dbo.t1 with (nolock)
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Gene." wrote:
> > Hi Folks
> >
> > I came accross very strange behavior of trigger utilizing sp_send_dbmail. In
> > short: sp_send_dbmail inside of trigger results in blocked process and never
> > ends.
> >
> > I wanted to code something simple the get notified if new rows were inserted
> > or updated in table.
> >
> > create table t1 (col1 int, col2 int)
> > go
> > create table t2 (col1 int, col2 int)
> > go
> > create trigger tr_ins_t1 on t1 for insert, update
> > as
> > set nocount on
> > truncate table t2
> > insert t2
> > select * from inserted
> >
> > exec msdb.dbo.sp_send_dbmail
> > @.recipients = 'gene_golub@.hotmail.com'
> > , @.subject = '!! sql1..t1 db : inserted new rows'
> > , @.query = 'select * from queries.dbo.t1'
> > go
> > insert t1 values(1,1)
> > go
> >
> > side comment: inserted table was not recognized inside of query sql string
> > which would be executed by sp_send_dbmail so I had to use another table to
> > insert rows first and then to send them over.
> >
> > When I insert simple row, my query hangs forewer.
> > What i see in sp_who: some process which is blocked by insert statement.
> > And this block does not resolve itself untill I go and kill process which is
> > bloced by insert stm.
> >
> > I had no problem before using xp_sendmail inside of the triggers. Why it
> > become a problem with sp_send_dbmail?
> > Can anybody explain me what am I doing wrong?
> > thank you, Gene.