Event Id15142
SourceMSSQLServer
DescriptionCannot drop the role '%s'.
Event InformationAccording to Microsoft

Cause:
sp_droprole cannot be used to drop a fixed server role or the public role.
Resolution:
Specify a valid user-defined role from the current database in your sp_droprole command.
Reference LinksEvent Id:15142 of Source Id:MSSQLServer


  Did this information help you to resolve the problem?
  Yes: My problem was resolved.
  No: The information was not helpful / Partially helpful.
  Comments:

Captcha  Refresh