Hi Kyle,

Yeah this is exactly what I've done to get around this issue. I've now got one transactional publication for the tables and indexed views, and one snapshot publication for...

If it's not an extended SP then you could try something around capturing the results of sp_helptext in a temp table, then querying that for 'filegroupid', and basing your logic...

I'm having the exact same issue! (see my latest reply on http://www.sqlservercentral.com/Forums/Topic1291326-291-1.aspx). If you send me the link to your connect bug report I'll gladly vote it.

Did you...

Hi I've now narrowed it down to an issue that means the distributed transactions are NEVER gettting cleaned up for a particular publisher database. The one in question has two...

I can't increase the frequency of the job as currently its taking on average 5-6 minutes to complete.

Any ideas why it may be so long & causing these blocking issues?

thanks

Yeah they do resolve without intervention, I've not had to manually kill any processes but I'd still like to know if there's any way I can avoid them entirely? I...