Hello, Is there anyway I can specify that maximum number of subscriptions cannot be more than 10 on a report? I have heard horror stories about people setting 100s of subscriptions on the same report at the same time and jamming the entire report processing. MSDNStudent Knows not much!

Hi, Basically from front end there is nothing as such with provides this facility. So, to address your concern, you can set value to MaxQueueThreads in the RsReportServer.config file, which set a maximum limit on the number of process threads the report server will dedicate to subscriptions and notifications. Now, you can also use caching. For more details on this kindly visit http://msdn.microsoft.com/en-us/library/ms155927%28v=sql.105%29.aspx Although, there is no such facility from front end, you can use triggers on Report server catalog table to prevent this from happening. But, this is not recommendable thing to do. Kindly revert if you need any more details.- Chintak (My Blog)

This may have undesired results. If I set the maxqueuethreads to say 20. its possible that 20 subscriptions of the same report start running. This creates even bigger problem for me. What I want is that "per report" there should be more than 5 subscriptions.MSDNStudent Knows not much!

Hi, In this case you need to write your own subs mgmt website or app. Take a look on the CreateSubscription method. I hope it helps. JanosThere are 10 type of people. Those who understand binary and those who do not. My Blog

wow! that's good! However how to suppress the existing UI options in many places to stop people from going to the default subscription creation mechanism?MSDNStudent Knows not much!

Hi, In this case you need to write your own subs mgmt website or app. Take a look on the CreateSubscription method. I hope it helps. JanosThere are 10 type of people. Those who understand binary and those who do not. My Blog

Hi, In this case you need to write your own Subscription module which takes care of everything http://msdn.microsoft.com/en-us/library/ms154699%28v=sql.105%29.aspx- Chintak (My Blog)

Hi, In this case you need to write your own Subscription module which takes care of everything http://msdn.microsoft.com/en-us/library/ms154699%28v=sql.105%29.aspx- Chintak (My Blog)