Microsoft KB Archive/203824

= BUG: Incomplete Display of Some System Roles =

Article ID: 203824

Article Last Modified on 10/16/2002

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q203824



BUG #: 52217 (SQLBUG_70)



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.



WORKAROUND
Contact Microsoft Product Support Services if the display of this information is important to you.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: prodsql

Keywords: kbbug kbpending KB203824

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.