Delete Snapshot Replication


when try drop publication in order:

exec sp_dropsubscription @publication = @publicname, @subscriber = @servname, @article = n'all'

exec sp_droppublication @publication = @publicname

i getting following error after dropping publication

msg 16943, level 16, state 4, procedure sp_msrepl_changesubstatus, line 1271

could not complete cursor operation because table schema changed after cursor declared.

msg 16943, level 16, state 4, procedure sp_msrepl_changesubstatus, line 1271

could not complete cursor operation because table schema changed after cursor declared.

could give me suggestion how avoid error?

thanks!

which if above 2 stored procs raising error, , version of sql server running?


SQL Server  >  SQL Server Replication



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

RFC_ERROR_SYSTEM_FAILURE with SAP ECC 6 Unicode

hi all, i using biztalk 2006 r2, microsoft biztalk adapter v2.0 mysap business suite sp1 & sql server 2005 database server. we have developed orchestrations communicating sap version 4.7.   currently sap has been upgraded in ecc 6(unicode) system. i have configured new send port on dev server. orchestration can communicate sap ecc 6.0 (non- unicode) system while trying connect sap ecc 6.0 (unicode) getting error. a message sent adapter "sap" on send port "ecc 6 sendport" uri "sap://as:***.**.***.***/**/***/" suspended.   error details: rfc_error_system_failure   messageid:   {b7dd677e-0ef3-480b-835a-d389f2e24179} is there can configure setting unicode ?   thanks in advance     ajay dabhade problem solved: standard table data types appear not unicode compatible in sap ecc 6.0. make rfcgetfunctiondesc raise error. solution: used other data types scratch in rfcs in sap   ajay dabhad...
Read more

how to make datagridview combobox editable in c#

Image
hello all, i using c#.net create windows application, here use datagridview add new details , use combobox datagridview combobox coloum select items , want add new item here. i aslo set datasoure for datagridview coloum bind data base, i want edit datagridview combobox coloum, here color column want add new color cant , restrict enter number on column here design here code add datagridview combobox coloum on load               datagridviewcomboboxcolumn cmb1 = new datagridviewcomboboxcolumn();             cmb1.headertext = "color";             gvvd.columns.add(cmb1); private void gvvd_editingcontrolshowing(object sender, datagridvieweditingcontrolshowingeventargs e)         {             datagridviewcomboboxeditingcontrol combocontrol = e.control datagridviewcomboboxeditingcontr...
Read more