Can Not Delet A Publication In SQL Server 2005: The Publication Does Not Exist [SQL Server Error: 20026]

Sep 21, 2007

Hi, everyone,
I am new in SQL server 2005. I had setup SQL server 2005 P2P replication. Somehow it did not work one of two way replication. I tried to delete the publication. However I could not do it. have the same problem. When I tried to delete the publication, I got the publication " " does not exist.[SQL server error: 20026]. I tried to use sp_droppublication, it gave me error "the database is not enabled for publication". Nevertheless, I can see the publication in MS SQL Management Studio and Publication monitor with OK status. I could not find the distribution database either.

Could you anyone has ideas to delete this publication? I am sorry I am not a programmer. Please give me more detail explanation if you can. Thanks.

View 6 Replies


ADVERTISEMENT

Error: The Publication Does Not Exist

Oct 31, 2006

I had a publication that I removed from the Local Publications folder but it still shows up in Replication Monitor (with a red 'X'). No jobs exist related to this publication either.

Everything is working ok, but I can't get rid of this from the Replication monitor.

Any help would be appreciated.

Thanks.

View 9 Replies View Related

Create A Publication In SQL Server 2005 Express

Nov 20, 2006

Hi,

is it possible to create a publication with SQL Server 2005 Express. I canīt seem to find it in Microsoft SQL Server Management Studio Express.

Do i have to install the full version? :(
Isnīt there any other option?

Thanks
SP

View 4 Replies View Related

SQL Server 2005 Workgroup - No Local Publication Tab

Oct 26, 2007

Hi

I've recently gone through installing and setting up merge replication on Server 2005 Standard. All working.

I am now setting up a different box with SQL 2005 Workgroup with SP2. When I go to the Replication tab in Management Studio there is only Local Subscriptions - No Local Publications.

I've re-run the installation but I can't see how Publications is not getting installed orwhy it is missing.

Any ideas much appreciated.

Thanks

Alistair


View 6 Replies View Related

Bug In MS Management Studio For SQL-Server 2005 While Creating A Publication!

Dec 21, 2006

Hello,

I found a bug in Management Studio, which can be reproduced with following steps:

1. Create a new publication with the 'New Publication Wizard'
2. Select a database which contains at least 2 tables.
3. Select 'transactional publicatioon'
4. Select at least 2 tables as articles
5. Set article properties for all table articles
6. Change 'Statement Delivery' to 'Insert statement', 'Update statement' and 'Delete statement' and save the article properties.
7. If you now check the properties for a single article you find that the 'Statement Delivery' is set to 'Do not replicate...'. If you generate this publication and create a subscritpion you will see, that actual no replication take place.

It took me a while to find out why my replication doesn't work! :-((

Wolfgang Kunk

PS : Management Studio version is 9.00.1399.00

View 6 Replies View Related

Transactional Publication With Updatable Subscriptions In SQL Server 2005, SvPk 2

Jul 31, 2007


Subscription to "Transactional Publication with Updateable Subscriptions" works only one way. Changes take effect on subscriber, but the subcriber is unable to update data on publisher.

I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.' All agents are running at the Distributor (Publishing Server.)

The subscriber is unable to connect to the Distributor using the SQL Server login.

Following is the error message I get:


Creating Subscription(s)...

- Creating subscription for 'SQL3' (Warning)



Messages

Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

MSDTC on server 'SQL3' is unavailable.
Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476


Please suggest procedure to end this dilemma. The link has no info available.

View 2 Replies View Related

The Subscription To Publication 'xxxx' Has Expired Or Does Not Exist

Dec 7, 2006

Hi,


Is there any way to find out if "subscription to publication has expired" in advance using RMO?

View 1 Replies View Related

Oracle 9i -&&> SQL Server 2005: Schema_option Parameter When Adding An Article To A Publication

Jul 13, 2006

First of all; My Oracle publication works fine when I don't explicit specify the shema_option parameter for the articles I'm adding to the publication. The reason why I then want to explicit specify the parameter is as following.

I'm developing a replication solution to get data from our production server (Oracle) to our Data Warehouse (SQL Server). The SQL Server (and the Data Warehouse code) uses the SQL_Latin1_General_CP1_CI_AS collation. When I don't explicit specify the schema_option, the nvarchar columns of the replicated tables are created using the SQL_Latin1_General_CP1_CS_AS collation and this results in some comparison errors, when for instance a select statement is trying to compare two nvarchar strings using different collations.

I've tried to specify the schema_option parameter as "@schema_option = 0x80" (Replicates primary key constraints.) to avoid the use of the SQL_Latin1_General_CP1_CS_AS collation when creating the destination tables - I'm not sure it's enough? No matter what, I'm getting an error when I'm doing it (see below).

Message
2006-07-13 12:00:15.529 Applied script 'ITEMTRANSLATION_2.sch'
2006-07-13 12:00:15.544 Bulk copying data into table 'ITEMTRANSLATION'
2006-07-13 12:00:15.544 Agent message code 20037. The process could not bulk copy into table '"ITEMTRANSLATION"'.
2006-07-13 12:00:15.591 Category:NULL
Source: Microsoft SQL Native Client
Number: 208
Message: Invalid object name 'ITEMTRANSLATION'.
2006-07-13 12:00:15.591 Category:NULL
Source:
Number: 20253

The questions are now whether I actually have a schema_option alternative for Oracle Publishing? If so, what is the solution, and eventually how can I avoid the error stated above?

If I'm not able to avoid the article columns getting created with the "wrong" collation, is there then any other obviously solution to the problem?

Thanks!
Best regards,

JB

View 5 Replies View Related

How To Reboot A Publication Server ?

Jul 16, 2004

We have to add some hardware and I was wondering if someone could provide a stepwise tip to do it .

It is a 3 Server Environment Pub/Dist/Sub
All three running under SQL2K
Here is what I am planning.

a. Uncheck the Enable in Distributed Agent for each replication
b. Wait for all replications to complete
c. Shut down Publisher ? Or do I have to do something else before that.

Please explain a little .

Thanks

View 2 Replies View Related

Publication Creating Bcp Files On Server

Mar 24, 2006

using publication from server one to server two. On server one, I have several directories with bcp files. Can the older files and directories be deleted?

View 1 Replies View Related

SQL Server 2008 :: Temporarily Stop Replication / What To Do When Publication Is Dropped

Aug 12, 2015

I have transactional replication configured where the publisher and subscriber are on two different servers. Yesterday a database upgrade was carried out, and the DBA dropped replication by issuing sp_removedbreplication on the published database. The subscription is still set up.

I have two questions:

1 - What is the safest way to temporarily switch off replication without losing the publication or subscription? As far as I was aware (my replication knowledge isn't great), simply disabling the relevant agents would do the job.

2 - I now have the task of creating the publication again (fortunately we have a saved script). If I recreate this publication, will I be able to point the existing subscription at it?

View 0 Replies View Related

Merge Publication Error

Mar 7, 2001

Hi,
I disabled a merge publication on my server. I then ran sp_removedbreplication to clean the system tables. Thats fine. When I recreate a new publication on my server now, I still get the red x on my publisher node in my replcation monitor from the error I was getting before. Evenm though this publication is error free. Is it saving an srror flag in one of the sytem tabbles

Any ideas on this?
Thanks

View 1 Replies View Related

Publication Configuration Error

Feb 7, 2006

Hey Everyone,

I am trying to setup publishing on SQL Server 2000 Enterprise. I will be subscribing from a SQL Mobile 2005 database so I have installed the SQL Server 2000 SP3a Replication Components, .NET Framework 2.0, and the SQL Server 2005 Mobile Edition Server Tools.

I was able to go through the 2005 Mobile Web Synchronization Wizard with no problems. However, when I try to run the Configure Publishing and Distribution Wizard, I get the following message at the end:

SQL Server Enterprise Manager could not configure 'GISSERV' as the Distributor for 'GISSERV'
Error 14114: '(null)' is not configured as a Distributor.

The first option I choose is Make 'GISSERV' it's own Distributor. Then, I select the snapshot folder that I shared. And on the third screen, I've tried going with the standard default settings and customizing those settings.

Has anyone else come across this error? Is there anyone else out there replicating from SQL Server 2000 to SQL Server 2005 Mobile?

Thanks in advance,

Lee

View 5 Replies View Related

Error On Creating Publication

Jul 19, 2006

Hi all, when I create publication with New Publication Wizard. I get the following errors. Did someone meet this before? Can you help me? Thanks!

===================================

SQL Server could not create publication 'JK'. (New Publication Wizard)

===================================

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand)
at Microsoft.SqlServer.Replication.ReplicationObject.ExecCommand(String commandIn)
at Microsoft.SqlServer.Replication.ReplicationObject.CommonCreate()
at Microsoft.SqlServer.Replication.Publication.Create()
at Microsoft.SqlServer.Management.UI.CreatePublicationWizard.CreatePublicationThreadMethod()

===================================

Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.
Changed database context to 'Test'. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=3933&LinkId=20476

------------------------------
Server Name: nxstudio-davidsql2k5_dc
Error Number: 3933
Severity: 16
State: 1
Procedure: sp_addmergepublication
Line Number: 1034


------------------------------
Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

View 2 Replies View Related

SQL Server 2008 :: Initialize Transactional Publication From Backup Loss Of Data

Mar 18, 2015

I have automated process, which synchronizes a transactional publication using initialize from backup approach. It drops subscriptions and puts them back again once the restore on the subscriber is completed.

Dropping the subscriptions causes a lot of blocking and deadlocking. I've decided to remove those steps, but it causes loss of data on the subscriber.

Is it a must to drop and re-create the subscriptions during such process? If not, how can I avoid the loss of data?

View 0 Replies View Related

SQL Server 2008 :: Tables Not Shown In Articles Window Of New Publication Wizard

May 26, 2015

We have restored a database on new server without keeping replication settings. Now while creating the publication no tables are shown in new publication wizard window. In fact we have hundred of tables in database and included in replication on source server from where backup was taken.

What may be the reason that tables are not appearing?

View 1 Replies View Related

Error 14294 - Can't Create Publication

Jul 1, 2003

When running the create publication wizard, I get:

"Error 14294 - Supply either @Job_id or @Job_Name to identify the job"

I had pubs & subs set up, but things were erroring, so I tried deleting everything and wanted to start from scratch, but the last step in the wizard gets me stuck.

Is it ok to clear the tables in the Distribution database that have info from earlier attempts at setting things up ?

Is there a way to delete the distribution database & really start from scratch ?

View 2 Replies View Related

Upgrade From 2000 &&> 2005 - Cannot Create Publication

Mar 30, 2007

have upgraded to SQL Server 2005 from 2000 ( to 9.0.1399).



The database seems to be functioning in order, however - I am unable to crerate a publication in order to replciate the database.



I am using the New Publication Wizard and see the follwoing error:



TITLE: New Publication Wizard
------------------------------

New Publication Wizard encountered one or more errors while retrieving the list of articles on 'nld_tradeinvoicing'. The list of articles may not be complete.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.PubWizardErrorSR&EvtID=CantInitArticleList&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Invalid column name 'options'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------



Could anyone help to pinpoint the casual factor behind this?

View 3 Replies View Related

Merge Publication - Snapshot Agent Error - Help

Apr 19, 2007

Hi all,



I have a merge publisher with Snapshot agent for that scheduled to run everyday morning, This was runnning till yesterday. But it is not running today and giving the below error.



Can anyone help me out to solve this error? This is occuring in production environment, i really need a solution as fast as possible.


Error messages:
· Message: Failed to read column data
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strDataFile)
at Microsoft.SqlServer.Replication.Snapshot.MergeContentsBcpOutWorkItem.DoWork(MergeSnapshotProvider snapshotProvider, IBcpOutProvider bcpOutProvider)
at Microsoft.SqlServer.Replication.Snapshot.MergeContentsBcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.WorkerThread.NonExceptionBasedAgentThreadProc()
at Microsoft.SqlServer.Replication.WorkerThread.AgentThreadProc()
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0
· Message: Shared Memory Provider: No process is on the other end of the pipe.
Stack: (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
· Message: Communication link failure
Stack: (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
· Message: Shared Memory Provider: No process is on the other end of the pipe.
Stack: (Source: MSSQLServer, Error number: 233)
Get help: http://help/233
Message: Communication link failure
Stack: (Source: MSSQLServer, Error number: 233)



Thanks,

Thams

View 16 Replies View Related

Error: 14151, Severity: 18, State: 1. Error When Reinitialising A Publication

Jan 23, 2007

Hi,

I have three publications on a dev server. All are sql 2005 merge replication (push) with replication running to subscribers on the same instance of sql server (note this is just dev testing).

However, I have just marked one for re-initialisation / create new snapshot / don't upload changes but when I kick off the synchronisation it says it has insufficient permission to run the snapshot.

When I do this for the other two there is no problem.

SQLAgent is running (using LocalSystem) so I don't know why my reinitialisation won't work.

Any help would be greatly appreciated.

View 1 Replies View Related

Publication Error ODBCBCP/Driver Version Mismatch

Aug 3, 2005

Hi.I'm trying to setup a publication but I received an error:The process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.I used the log to get more specific info and I got the following:Microsoft SQL Server Snapshot Agent 8.00.760Copyright (c) 2000 Microsoft CorporationMicrosoft SQL Server Replication Agent: MyServer-MyMainDatabase-MyMainDatabase2MyTargetDatabase-4Connecting to Distributor 'MyServer'Connecting to Publisher 'MyServer.MyMainDatabase'Server: DBMS: Microsoft SQL ServerVersion: 08.00.0760user name: dboAPI conformance: 2SQL conformance: 1transaction capable: 2read only: Nidentifier quote char: "non_nullable_columns: 1owner usage: 31
max table name len: 128max column name len: 128need long data len: Ymax columns in table: 1024max columns in index: 16max char literal len: 524288max statement len: 524288max row size: 524288[8/3/2005 4:43:30 PM]MyServer.MyMainDatabase: sp_MSgetversionInitializing the publication 'MyMainDatabase2MyTargetDatabase'*** [Publication:'MyMainDatabase2MyTargetDatabase'] Publication view generation time: 201 (ms) ****** [Publication:'MyMainDatabase2MyTargetDatabase'] Make generation time: 100 (ms) ***Generating schema script for article '[ContactsCategories]'Generating conflict schema script for article '[ContactsCategories]'Generating referential integrity script for article '[ContactsCategories]'Generating trigger script for article '[ContactsCategories]'*** [Article:'ContactsCategories'] Time generating all schema scripts: 1762 (ms) ***Generating schema script for article '[Contacts]'Generating conflict schema script for article '[Contacts]'Generating referential integrity script for article '[Contacts]'Generating trigger script for article '[Contacts]'*** [Article:'Contacts'] Time generating all schema scripts: 1292 (ms) ****** [System table:'MSmerge_contents'] .SCH script generation time: 10 (ms) ***
*** [System table:'MSmerge_tombstone'] .SCH script generation time: 20 (ms) ***
*** [System table:'MSmerge_genhistory'] .SCH script generation time: 21 (ms) ***
*** [System table:'sysmergesubsetfilters'] .SCH script generation time: 30 (ms) ***
[8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[ContactsCategories] (TABLOCK HOLDLOCK) where 1=2 [8/3/2005 4:43:34 PM]MyServer.MyMainDatabase: select 1 from [dbo].[Contacts] (TABLOCK HOLDLOCK) where 1=2 Bulk copying snapshot data for system table 'MSmerge_contents'select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2[8/3/2005 4:43:35 PM]MyServer.MyMainDatabase: select * from cont20684C64E88B424BBBBE84921DEDFF77 where 1 = 2SourceTypeId = 4SourceName = MyServerErrorCode = 0ErrorText = ODBCBCP/Driver version mismatchThe process could not bulk copy out of table 'cont20684C64E88B424BBBBE84921DEDFF77'.Disconnecting from Publisher 'MyServer'
I have also found in another forum tha this is related with the files sqlsrv32.dll, sqlsrv32.rll and odbcbcp.dll. The versions of these drivers in my server are:sqlsrv32.dll: 85.1025sqlsrv32.rll: 81.9001odbcbcp.dll: 81.9031Is it really the problem in the versions of these files? Anyone knows how to update them and if there any risks by doing it?Thanks in advance... 

View 1 Replies View Related

URGENT::Oracle To SQL 2005 Replication ( Drop Coulmn From Publication)

Jul 9, 2007



I'm in a middle of a project where replication established between Oracle 8i and SQL server 2005. Now we need to drop one column from on of the tables replicated from Oracle side. My question : Is there anyway I can do this in Oracle and automatically reflected on SQL server? If not what is the proper steps to do it. Realy appreciate your fast response.



Regards

View 1 Replies View Related

Linked Server 2000 To 2005: Error 17 Sql Server Does Not Exist Or Access Denined.

Aug 30, 2006

I'm trying to link SQL Server 2000 sp3 to SQL 2005 64 bit. I keep getting Error 17 sql server does not exist or access denined. I tried adding remote user mapping and chaning the linked server properties to "Be made using this security context" without any success.
Any help is appreciated.

View 4 Replies View Related

In SqlServer Management Studio Express, Server Type Option Is Greyed Out, Also Publication Option Missing

Apr 27, 2008

Hi everyone In my SqlServer Management Studio Express, on start up it shows the server type option, but greyed.So that value is fixed to database engine. ( I'm trying to work on an SqlServer Compact Edition database through the SSMStudiothat's why I'm trying to get this to change.)Besides, after I connect i go to the Object Explorer, expand the server node, and go to Replication.When i expand replication, i get the "Local Subscription" option, but nothng for Publication.( I want to work on Merge Replication, that's why I desparately need Publication to work)Am i missing something here? I did not install SqlServer separately, I only have what comes bundled with the Visual Studio  2005 Setup.

View 2 Replies View Related

Oracle Publication Error:The Permissions Associated With The Administrator Login For Oracle Publisher 'test1' Are Not Sufficient

Jan 12, 2006

Hi,

I am trying to make an oracle publiching from sql server 2005 enterprise final release, i installed the oracle client  10.2 (10g) on the same server where sql server already installed, i made different connection to oracle database instance and it was  ok.

 

from sql server : right click on publication -New oracle publication-Next-Add Oracle Publisher-Add button-Add Oracle Publisher-i entered server insttance test1 and their users and passwords--connect --->

the oracle publisher is displayed in the list of publisher but when press ok i got the following error :

TITLE: Distributor Properties
------------------------------

An error occurred applying the changes to the Distributor.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=ErrorApplyingDistributor&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

SQL Server could not enable 'test1' as a Publisher. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The permissions associated with the administrator login for Oracle publisher 'test1' are not sufficient.
Changed database context to 'master'. (Microsoft SQL Server, Error: 21684)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21684&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Any idea about this error ?

Thanks

Tarek Ghazali
SQL Server MVP.


 

View 2 Replies View Related

Publication

Jun 20, 2006

I have a publication on my SQL Server.

The first time my application syncs with the server it works fine.

If I try to sync again I get "Permission Denied Number 80040E09 NativeErr: 0"

Other publications work fine, it just seems to be this one.

Any ideas?

View 5 Replies View Related

Cannot Add Publication

Oct 30, 2006

Hi!

I have a strange error, when I try to create publication

Msg 3933, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1222
Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.

What is it?

P. S. The error arise with all types of replication.

View 6 Replies View Related

Modify Publication In SQL 7.0 . Please Help !!

May 14, 2002

Hello ,

I have a problem with a publication which is a transactional replication on SQL Server 7.0 .
I want to add stored procedure to the existing publication along with the tables . But the Enterprise manager does not allow to select or check the box
against the required stored procedure although it displays when i right click on the publication and select proeprties .

Can i have some help in this regard ? Does anybody knows to add a stored procedure by means of a query .

Is there any other way to modify publication in SQL Server 7.0 although it is possible in SQL Server 2000 .?

Many thanks in advance.
Sandra .

View 1 Replies View Related

Is DB Publication/subscription?

Jul 26, 2004

Because of problems trying to alter databases used
for replication my software would need to find out
if a database is a publisher or was repliated (using
T-SQL). Is this possible?

View 1 Replies View Related

How To Add New Article To Publication?

Dec 23, 2004

Hi,
I'm use MSSQL2000 SP3 with replication.
I want to know that Can i add new article to existing publication by
Enterprice Manager ?

someone told me that we can do that in older version but not now,right? :confused:

View 1 Replies View Related

Can Not Able To Create Publication

Feb 28, 2008

Hi guys.



i had configured a merge replication betwen 2 server and i was running fine. but due to network problems my network admin has changed the ip address and name of the publisher, distributor and subscriber.



what i did. i just drop the publication and now i m trying to create a new one. but i cannt' able to create. i dont' know y.. this is the error i m facing..



Msg 208, Level 16, State 1, Procedure sp_addmergepublication, Line 239

Invalid object name 'dbo.sysmergepublications'.

Msg 21040, Level 11, State 1, Procedure sp_MSaddmergepub_snapshot, Line 65

Publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 20026, Level 16, State 1, Procedure sp_grant_publication_access, Line 176

The publication 'DIS_MASTER_Merge' does not exist.

Msg 208, Level 16, State 1, Procedure sp_changemergepublication, Line 205

Invalid object name 'dbo.sysmergepublications'.

View 1 Replies View Related

Unable To Add New Publication

Jun 2, 2006

I have been wrestling with this one all day and cannot find anything on MSDN, google, etc.... I have configured replication, but cannot create a new publication either programmatically or using the wizard.
I programmatically did the following:
1. I set up my local server as a distributor, and created a distribution database (@distributor set to server sysname)
execute sp_adddistributor @distributor = @distributor
execute sp_adddistributiondb @database = @distributionDB, @security_mode=1;
2. I registered my local server also as a Publisher (@publisher set to server sysname, @distribution = 'distributor')
SELECT @sql = 'sp_adddistpublisher @publisher = ''' + @publisher +
''', @distribution_db = ''' + @distributionDB +
''', @working_directory = ''' + @directory + ''', @security_mode = 1'
SELECT @sp_executesql = quotename(@distributionDB) + '..sp_executesql '
EXEC @sp_executesql @sql
3. I enabled my local database for transactional replication (@replicationDB)
exec sp_replicationdboption
@dbname = @replicationDB,
@optname = 'publish', @value = 'true
4. I added a logReaderAgent on the ReplicationDB
SELECT @sql = 'sp_addlogreader_agent @publisher_security_mode = 1'
SELECT @sp_executesql = quotename(@replicationDB) + '..sp_executesql
EXEC @sp_executesql @sql

All is well up to this point, no problems, all looks great. When I check the status of things using sp_help repl stored procedures to check on publisher, distributor all looks healthy. Also looks good when I use the SSMS replication interface to check on distributor, publisher, etc. . HOWEVER...... I cannot create any publications.

I tried programmatically, and also by using the wizard.
I keep getting the same error :'Cannot insert the value NULL into column 'pubid', table'.
This is the sql I try to run:
EXEC sp_addpublication
@publication = 'test3333',
@status = N'active',
@allow_push = N'true',
@allow_pull = N'true'
This is the error:
Msg 515, Level 16, State 2, Procedure sp_MSrepl_addpublication, Line 1320
Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Msg 14018, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 1348
Could not create the publication.
If I use the wizard instead of trying to create the publication programmatically, I get this error (just about the same content, but a little different wording):
Creating Publication
- Creating Publication 'NewPublication' (Error)
Messages
* SQL Server could not create publication 'NewPublication'. (New Publication Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot insert the value NULL into column 'pubid', table 'CypressMaster.dbo.IHpublications'; column does not allow nulls. INSERT fails.

Could not create the publication.
Object 'NewPublication' does not exist or is not a valid object for this operation.
Changed database context to 'CypressMaster'.
The statement has been terminated. (Microsoft SQL Server, Error: 515)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=515&LinkId=20476



- Adding articles (Stopped)

- Starting the Snapshot Agent (Stopped)

- Generating a script file (Stopped)

View 4 Replies View Related

Creating A Publication

May 22, 2006

hi
I was following the walkthrough "Creating a Mobile Application with SQL Server Mobile" and when I got to the point where you create a "local publication" I couldn't find the link "Local Publication" in my Object Explorer.

I read all the help in books online however id did not tell me how to bring that link there.

I did install the replication component using the CD installation. I have SQL Server 2005 Standard Edition and Visual Studio 2005


I also found the help "Using the Publication Wizard to Create a Publication" but did not know where to locate or start the wizard.

any help will be appreciated.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved