BUG: Incomplete Display of Some System Roles

SYMPTOMS

Some of the permissions such as BULK INSERT, RESTORE DATABASE, RESTORE LOG, DBCC SHRINKDATABASE, and DBCC SHRINKFILE are missing from the system administrator role description when you view it in SQL Enterprise Manager or when you use the sp_srvrolepermission stored procedure.

This is only an information display issue. The system administrator does have these permissions, but they are not displayed.

Similarly, permissions such as RESTORE DATABASE and RESTORE LOG are missing from the database creator role description, although they also possess these permissions.