Hi,

we had a similar issue and seemed to have been caused by the security patches mentioned above. we even logged a service request with microsoft who could not help us...

Hi,

make sure both the config_value and run_value for the max server memory are same.. , seems like the config_value is set to only 6.4 gb while run_value is 20..

Have you tried using the Database roles under MSDB ??

In SQL 2000 there are indexed views and non-indexed views , in other words indexed views are materialised and non-indexed are not they are materialised when the view is referred to...