Hi , I have couple of questions and appreciate if some body can answer 1. In case of SQL 2000 once we click on replication thru EM ,it shows all 3 agents on right side and shows it is PULL or PUSH ,but where i can find the same in SQL 2005 to see if the subscription is PULL or PUSH? 2. for PUSH subscription , I can right click on agent thru replication monitor in SQL 2005 and can see the agent 'Profile' to change the query time out settings but for PULL i dont see 'Profile' where i can change the query time out in case of PULL subscription?
1) Nope, its not displayed. 2) I see them - what sort of clients do you have? "sacgar" wrote in message news:1B7D1F05-DC62-4479-96BF-310FD97B13DB@microsoft.com... > Hi , > > I have couple of questions and appreciate if some body can answer > > 1. In case of SQL 2000 once we click on replication thru EM ,it shows all > 3 > agents on right side and shows it is PULL or PUSH ,but where i can find > the > same in SQL 2005 to see if the subscription is PULL or PUSH? > > 2. for PUSH subscription , I can right click on agent thru replication > monitor in SQL 2005 and can see the agent 'Profile' to change the query > time > out settings but for PULL i dont see 'Profile' where i can change the > query > time out in case of PULL subscription?
Thanks Hilary 1)so what is the way to check for first question for PULL and PUSH subscription in SQL 2005? 2)also can you confirm if you are able to see the profile for 'distribution' agent thru replication monitor for PULL subscription where dist agent is sitting at subscriber end? "Hilary Cotter" wrote: > 1) Nope, its not displayed. > 2) I see them - what sort of clients do you have? > > "sacgar" wrote in message > news:1B7D1F05-DC62-4479-96BF-310FD97B13DB@microsoft.com... > > Hi , > > > > I have couple of questions and appreciate if some body can answer > > > > 1. In case of SQL 2000 once we click on replication thru EM ,it shows all > > 3 > > agents on right side and shows it is PULL or PUSH ,but where i can find > > the > > same in SQL 2005 to see if the subscription is PULL or PUSH? > > > > 2. for PUSH subscription , I can right click on agent thru replication > > monitor in SQL 2005 and can see the agent 'Profile' to change the query > > time > > out settings but for PULL i dont see 'Profile' where i can change the > > query > > time out in case of PULL subscription? > >
Hi, Can any body answers for below ,thanks much... "sacgar" wrote: > Thanks Hilary > > 1)so what is the way to check for first question for PULL and PUSH > subscription in SQL 2005? > > 2)also can you confirm if you are able to see the profile for 'distribution' > agent thru replication monitor for PULL subscription where dist agent is > sitting at subscriber end? > > "Hilary Cotter" wrote: > > > 1) Nope, its not displayed. > > 2) I see them - what sort of clients do you have? > > > > "sacgar" wrote in message > > news:1B7D1F05-DC62-4479-96BF-310FD97B13DB@microsoft.com... > > > Hi , > > > > > > I have couple of questions and appreciate if some body can answer > > > > > > 1. In case of SQL 2000 once we click on replication thru EM ,it shows all > > > 3 > > > agents on right side and shows it is PULL or PUSH ,but where i can find > > > the > > > same in SQL 2005 to see if the subscription is PULL or PUSH? > > > > > > 2. for PUSH subscription , I can right click on agent thru replication > > > monitor in SQL 2005 and can see the agent 'Profile' to change the query > > > time > > > out settings but for PULL i dont see 'Profile' where i can change the > > > query > > > time out in case of PULL subscription? > > > >
