Event ID - 21120

Event Id21120
SourceMSSQLServer
DescriptionOnly members of the sysadmin fixed server role and db_owner fixed database role can drop subscription %s to publication %s.
Event InformationCAUSE:
A snapshot or transactional push subscription can only be dropped by the login used to create the subscription or by a member of the sysadmin fixed server role or the db_owner fixed database role in the current database context.

RESOLUTION:
To drop the snapshot or transactional push subscription, log in with the login account used to create the subscription or as a member of the sysadmin fixed server role or the db_owner fixed database role in the current database context. To see which login was used to create the subscription, check the login_name column of syssubscriptions on the publication database.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 21120

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.