| Event Id | 21120 |
| Source | MSSQLServer |
| Description | Only members of the sysadmin fixed server role and db_owner fixed database role can drop subscription %s to publication %s. |
| Event Information | CAUSE: 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 Links | Microsoft 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.