can't drop login
icrosoft SQL Server, Error: 15141
The server principal owns an event notification and cannot be dropped.
notification services do not show anything, where else could it be ?
Did you opened up the Service Broker node in the database node ? There might be a Queue open for that principal that you want to delete.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||
Have you checked sys.server_event_notifications? Is there any notification there owned by the login?
Queues are owned by database principals, so this error is not caused by the presence of a queue.
Thanks
Laurentiu
thanks a lot
sys.server_event_notifications showed a row related to user.
I droped notification and and was able to drop login
No comments:
Post a Comment