"Hassan" <fatima_ja@hotmail.com> wrote in message
news:urmmAnR7EHA.3076@TK2MSFTNGP15.phx.gbl...
> When i refresh the publication in EM, and look at all my subscriptions.. I
> see the last action column changing..i.e from
>
> 100 transaction(s) with 100 command(s) were delivered to
> 45 transaction(s) with 50 command(s) were delivered and so on..
>
> Is all this information stored someplace that I can query with a date
> time...
>
> Also if i wanted to increase the time all the history information is
> retained in these tables , where can I do it ?
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:O1jJ$CS7EHA.2876@TK2MSFTNGP12.phx.gbl...
> select * from MSdistribution_history
>
> However you will have to change your distribution agents to run with the
> HistoryVerboseLevel setting of 2 otherwise this information will be
> overwritten.
>
> There is a performance price to pay for this.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "Hassan" <fatima_ja@hotmail.com> wrote in message
> news:urmmAnR7EHA.3076@TK2MSFTNGP15.phx.gbl...
> > When i refresh the publication in EM, and look at all my subscriptions..
I
> > see the last action column changing..i.e from
> >
> > 100 transaction(s) with 100 command(s) were delivered to
> > 45 transaction(s) with 50 command(s) were delivered and so on..
> >
> > Is all this information stored someplace that I can query with a date
> > time...
> >
> > Also if i wanted to increase the time all the history information is
> > retained in these tables , where can I do it ?
> >
> >
>
>

"Hassan" <fatima_ja@hotmail.com> wrote in message
news:eq8bw0T7EHA.2012@TK2MSFTNGP15.phx.gbl...
> Correct.. I have seen this table but it only had the last transaction in
> there.. So setting historyverboselevel to 2 will log all that ? And for
> how
> long will the information be stored ?
>
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:O1jJ$CS7EHA.2876@TK2MSFTNGP12.phx.gbl...
>> select * from MSdistribution_history
>>
>> However you will have to change your distribution agents to run with the
>> HistoryVerboseLevel setting of 2 otherwise this information will be
>> overwritten.
>>
>> There is a performance price to pay for this.
>>
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> "Hassan" <fatima_ja@hotmail.com> wrote in message
>> news:urmmAnR7EHA.3076@TK2MSFTNGP15.phx.gbl...
>> > When i refresh the publication in EM, and look at all my
>> > subscriptions..
> I
>> > see the last action column changing..i.e from
>> >
>> > 100 transaction(s) with 100 command(s) were delivered to
>> > 45 transaction(s) with 50 command(s) were delivered and so on..
>> >
>> > Is all this information stored someplace that I can query with a date
>> > time...
>> >
>> > Also if i wanted to increase the time all the history information is
>> > retained in these tables , where can I do it ?
>> >
>> >
>>
>>
>
>