hi

 did u try this

REPLACE(REPLACE([A-MSG],'"',''),'''','')

[A-MSG] not enclosed in quotes

Thank you for your explanations..

Is there any tool to find out how memory is allocated for different caches...for example how much memory allocated for buffer cache...

Thank You

Thank you for your explanations..

Is there any tool to find out how memory is allocated for different caches...for example how much memory allocated for buffer cache...

Thank You

Thank you for your reply..

actually my intention was not to make SQL Server use less than 2GB.. but the problem is that memory usage is getting increased all the way......

No.. I did not dettach the subscriber databases.. the problem was network connectionn was broken between publisher and the subscriber for a while(about 1 day) ..

Thank You

Andrew,

Can you please tell me the job name which is monitoring the subscribers expiration..

Thank You

Chandra Shekar

Thanx for your reply... but I have already choosen the NEVER EXPIRES radio button only.. even then also I am getting this frequently..

  where I need to drop the subscription...

Thank you for replies...

I will try those suggestions..

Shekhar

The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.

I am getting this error frequently .. and it requires me to...