Unanswered: show permissions of db object causes high CPU load
I've got a problem with SAP databases on MSSQL 2000. When I select manage permissions for a db object in Enterprise Manager, the process mmc.exe allocates ~50 % CPU for about 10 - 20 minutes.
On system databases or other user databases this error doesn't occur. On SAP databases on MSSQL 7 it doesn't occur, too. With T-SQL the object permissions can be displayed and administered without high CPU load SAP databases on MSSQL 2000, too.