subscription should not be an issue also i am using PULL subscription but the issue i am concerned with publication how it will be taken care without dropping and re-creating?

it looks like i am stuck with dbcc shrinkfile , any idea how i can use the database name in the stored procedure for dbcc shrinkfile with specific db?

Thanks , do we have combination of above two to give exact in same query?

Guys you rock ,thnx

Hey , any body have query that will work on multiple subscriptions , this does not work on multiple subscription , i am looking like

publisher , subscriber , publisher_db ..

i...

Thanks , but in x64 bit this AWE setting will be used as "locked pages" , so 14 gigs is still being used by SQL Server as locked pages on...

posting the latest version i just wrote and worked for me ,if it helps for somebody....

SELECT distinct MM.Publisher as [Publisher Server],MI.subscriber as [Subscriber Server],MM.publisher_db as [Publisher DB],

datediff(mi, TT.publisher_commit,TH.subscriber_commit)...

I could able to get what i was looking

SELECT distinct MM.Publisher as [Publisher Server],MI.subscriber as [Subscriber Server],MM.publisher_db as [Publisher DB],

datediff(mi, TT.publisher_commit,TH.subscriber_commit) AS [Latency in Minutes]

FROM MSTracer_tokens TT(nolock)

...

Experts , Just wondering if some body have clue on this?

Thanks , for first case ,do i need to drop the existing snapshot or i can just overwrite the previous snapshot with new one ?

Thanks all for your valuable inputs , so i am thinking that while generating the snapshot daily night it has no disconnect for users to generate reports during snapshot generation,...

i got the soln to insert tracer token after each interval of time through sql agent job on each subscriber and now i am quering the data like

SELECT publication_id,...

Requirement is for SSRS reporting , we are thinking to create DB snapshot on mirror database ,but not sure when weekly we take new db snapshot from Mirror does it...

Appreciate for the link , actually i am looking some practical problems for this soln if any ,more with the above point 2.

Great , thank you both for the links , that helps...