Event ID - 15142

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

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

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.