Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

can delete publication

0 views
Skip to first unread message

som...@js.com

unread,
Nov 18, 2009, 11:52:10 AM11/18/09
to
Hi, when trying to delete a publication, error: could not delete
publication '\publicationname'
Addition information:
An exception occurred while executing a Transact-SQL statement or batch.
cannot execute as the database pricipal becausae the pricipal 'dbo' does not
exist, this type of changed database content to 'publicationname'.
please advice and thanks.

Hilary Cotter

unread,
Nov 19, 2009, 9:03:41 AM11/19/09
to
From the query window can you try this?

sp_droppublication 'MyPublicationname'

<som...@js.com> wrote in message
news:O20g59Ga...@TK2MSFTNGP05.phx.gbl...

som...@js.com

unread,
Nov 19, 2009, 10:17:11 AM11/19/09
to
Yes, works. GUI commands not good?

Thanks...

"Hilary Cotter" <hilary...@gmail.com> wrote in message
news:FD2F0BB6-A430-4BE4...@microsoft.com...

Hilary Cotter

unread,
Nov 20, 2009, 7:46:13 AM11/20/09
to
GUI normally works. You have a mis-configuration somewhere which prevents
the GUI from being successful.

<som...@js.com> wrote in message
news:OJHPYDTa...@TK2MSFTNGP02.phx.gbl...

0 new messages