View Complete Post
can i srink msdb sys database using dbcc , is there any affect to the production server (which is running currently) or any other production databases. please respond
I am getting the following error when I execute an SSRS report.
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.
The report is executing a stored proc. Which in turn is running an Agent Job.
When I run this report through BIDS it works fine. It is only when I run it though Report Manager I get a problem.
Can anybody help?
I do like to find the query to list out all the available database role membership identities for msdb database. For other database i pull out the list of database role membership from sys.database_principals whose
principal_id ranges between 16384-16393. For msdb database there seems to be much of database roles and it is not available in sys.database_principals. Kindly help me out in pulling out all the database roles for msdb database alone.