The Snapshot For This Publication Has Become Obsolete !

Hi,

I am in need of some help with this error - I am seeing on my PDA units. Here is my scenario:

I have 5 PDA units that use merge replication with SQL 2005. These PDA units replicate fine. But when I try to sync a 6th or 7th PDA unit, I see the following error:

Source    : Microsoft SQL Server 2005 Mobile Edition - The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized. -2147198698

I know that if I regenerate a new snapshot, I will be able to sync fine. But here are my concerns and questions:

What happens to the first 5 PDAs when I regenerate the a new snapshot.
Will they be able to sync without losing the data?
Does generating a new snapshot, relinitialize all the subscriptions?

Am I missing the whole picture with generating a new snapshot?

Thanks,

P

 

View Replies


ADVERTISEMENT

Obsolete Snapshot

Hi everybody,

We have merge replication between two servers with Sql Server 2000 Service Pack 2, and the Merge agent display the follow message :

The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized.

But i have changes at the suscriber, How can I do to Merge the last changes if the merge agentes is stopped.

I appreciate any help.

thanks

View Replies View Related

Snapshot Files Obsolete?

I recently had a problem with one of my publications that I haven't been able to figure out.  Hopefully someone can help me with it. 

 

I got this error last week:  You must rerun snapshot because current snapshot files are obsolete.  I assume this means the subscription needed to be re-initialized.  Is this correct?

 

If so, I don't understand why.   The publication was not changed.  The subscription did not expire.  The subscription was not marked for reinitialization.

 

Here are the specifics of my installation:

 

Merge publication with 1 pull subscription.

Subscriptions set to expire after 14 days.

Merge agent runs every day, every 5 minutes between 12:00:00A & 11:59:59P.

Snapshot agent was run once when publication was created and then disabled.

Publisher SQL ver: 2000 sp3

Publisher Win ver: 2003 sp1

Subscriber SQL ver: 2000 sp3

Subscriber Win ver: 2003 sp1

 

The subscription was successfully replicating every 5 minutes.  The data for 12:35 shows the first problem.  Here's the agent history at the time:

 










runstatus
start_time
comments
error_id

1
5/23/07 12:25
Initializing
0

3
5/23/07 12:25
Connecting to Publisher 'AASTAUSSQL01'
0

3
5/23/07 12:25
Uploaded 4 data changes (3 inserts, 1 updates, 0 deletes, 0 conflicts).
0

3
5/23/07 12:25
Downloaded 7 data changes (2 inserts, 5 updates, 0 deletes, 0 conflicts).
0

2
5/23/07 12:25
Merged 11 data changes (5 inserts, 6 updates, 0 deletes, 0 resolved conflicts).
0

1
5/23/07 12:30
Initializing
0

3
5/23/07 12:30
Connecting to Publisher 'AASTAUSSQL01'
0

3
5/23/07 12:30
Uploaded 4 data changes (3 inserts, 1 updates, 0 deletes, 0 conflicts).
0

3
5/23/07 12:30
Downloaded 20 data changes (14 inserts, 6 updates, 0 deletes, 0 conflicts).
0

2
5/23/07 12:30
Merged 24 data changes (17 inserts, 7 updates, 0 deletes, 0 resolved conflicts).
0

1
5/23/07 12:35
Initializing
0

3
5/23/07 12:35
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:35
You must rerun snapshot because current snapshot files are obsolete.
2

1
5/23/07 12:40
Initializing
0

3
5/23/07 12:40
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:40
You must rerun snapshot because current snapshot files are obsolete.
3

1
5/23/07 12:45
Initializing
0

3
5/23/07 12:45
Connecting to Publisher 'AASTAUSSQL01'
0

2
5/23/07 12:45
You must rerun snapshot because current snapshot files are obsolete.
4

 

Any help with this would be greatly appreciated.

 

Thanks!

View Replies View Related

The Initial Snapshot For Publication '' Is Not Yet Available.

I have a transaction replication on sql2005 sp2

pushing to 3 sql servers 1 sql2000 sp3a, 1 sp2000 sp4 and 1 sp2005 sp2

 

all the servers run fine except for the sql2000 sp4  which has

done this a least once a week,

The initial snapshot for publication 'nations' is not yet available.

 

 

The server that is having the issue has lots of locks

 

View Replies View Related

The Initial Snapshot For Publication 'Publicationxxx' Is Not Yet Available

When I am trying to synchronize my sql server ce database with sql server 2000, I am getting this error in the Replication Monitor and Synchronization gets fail.

How to Create initial snapshot or is there any step by step configuration document available for Merge Replication with SQL server 2000 and sql ce.

View Replies View Related

Merge Publication - Snapshot Agent Error - Help

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 Replies View Related

Trouble Getting Snapshot Agent To Initialize Publication

I have been trying to set up transactional replication between an OLTP SQL Server 2005 Standard edition server and a BI SQL Server 2005 Enterprise edition server. I am using a pull subscription. I was able to establish the replication from the developement server to the BI server however when I tried setting up the replication between the production environment and the BI server, using the same configuration settings, I ran into a problem. The production server had been renamed after it was initially set up. I used the sp_dropserver and sp_addserver to solve this issue and was able to run the replication wizard. However once the wizard finishes the snapshot agent doesn't initialize the publication. When I look at the replication monitor it has a status of "never run". I try to run it manually and it appears to run for a few seconds then stops and still has the status of "never run". I don't get any error messages and can't find anything in the log. I am wondering if this is related to the server rename? I am hoping to find a soultion that doesn't involve uninstalling SQL Server and reinstalling since this is a production environment.

Thanks.

View Replies View Related

Problem After Applying Snapshot Publication To Subscriber

Hello all,

I have a unusual problem with a snapshot publication that I am having a hard time troubleshooting. The servers in question are all SQL 05 Enterprise. Here is the scenario:

Staging Server - This server acts as the publisher of the snapshot
Production Server - This server is the subscriber of the staging snapshot
Cascade Servers - These servers receive transactional updates from the production server

The staging server applies the snapshot to production successfully. From there the production server has a transactional publication which the subscribers are the cascade servers.

This model worked for a long time where we would generate the snapshot apply it to production and the updates would be sent to the cascade servers. All of a sudden there is a problem with the transactional publication from production -> cascade. There are 7-10 tables that do not receive the updates and all data in the problematic tables is truncated. The other remaining tables in the subscription receive the updates as needed. Looking at replication monitor and all other logs shows that the transactions are being replicated, but yet the 7-10 problematic tables do not contain any data. The only solution I have found for this is to recreate the entire replication model from scratch.

Any advice on how to handle this scenario? Is my model for using a transactional publication to cascade changes to a subset of servers incorrect?

 

View Replies View Related

Snapshot Agent Fails For Merge Replication Publication

I'm trying to setup merge replication and get the following error from the snapshot agent after I've finished the 'New Publication Wizard'. This doesn't make sense to me as it is an automatic process. Also, it looks like it is complaining about a 'dbo.MSmerge_cont...' view which is a view created automatically for the merge publication.

 ERROR MESSAGE:
The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128.

FULL DETAILS:
Message: The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128.
Command Text: IF OBJECT_ID(N'[<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWCS464</ServerName><LoginName>NT AUTHORITYSYSTEM</LoginName><UserName>dbo</UserName><DatabaseName>liport2_gts</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90</ObjectName><ObjectType>VIEW</ObjectType><TSQLCommand><SetOptions ANSI_NULLS="OFF" ANSI_NULL_DEFAULT="ON" ANSI_PADDING="ON" QUOTED_IDENTIFIER="ON" ENCRYPTED="FALSE" /><CommandText>create view dbo.MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90 as select * from MSmerge_contents where 1 = 2</CommandText></TSQLCommand></EVENT_INSTANCE>]', 'V') IS NOT NULL DROP VIEW [<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWCS464</ServerName><LoginName>NT AUTHORITYSYSTEM</LoginName><UserName>dbo</UserName><DatabaseName>liport2_gts</DatabaseName><SchemaName>dbo</SchemaName><ObjectName>MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90</ObjectName><ObjectType>VIEW</ObjectType><TSQLCommand><SetOptions ANSI_NULLS="OFF" ANSI_NULL_DEFAULT="ON" ANSI_PADDING="ON" QUOTED_IDENTIFIER="ON" ENCRYPTED="FALSE" /><CommandText>create view dbo.MSmerge_contAE2EB588ABFA4C13825D4D44CB2D50CB_90 as select * from MSmerge_contents where 1 = 2</CommandText></TSQLCommand></EVENT_INSTANCE>]
Parameters:
Stack:    at Microsoft.SqlServer.Replication.AgentCore.ReMapSqlException(SqlException e, SqlCommand command)
   at Microsoft.SqlServer.Replication.AgentCore.AgentExecuteNonQuery(SqlCommand command, Int32 queryTimeout)
   at Microsoft.SqlServer.Replication.AgentCore.ExecuteDiscardResults(CommandSetupDelegate commandSetupDelegate, Int32 queryTimeout)
   at Microsoft.SqlServer.Replication.AgentCore.ExecuteAdHocQueryDiscardResults(String strQuery, SqlConnection connection)
   at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.GenerateSystemTableBcpFiles()
   at Microsoft.SqlServer.Replication.Snapshot.MergeSnapshotProvider.DoPostArticleFilesGenerationProcessing()
   at Microsoft.SqlServer.Replication.Snapshot.SqlServerSnapshotProvider.GenerateSnapshot()
   at Microsoft.SqlServer.Replication.SnapshotGenerationAgent.InternalRun()
   at Microsoft.SqlServer.Replication.AgentCore.Run() (Source: MSSQLServer, Error number: 103)
Get help: http://help/103
Server XF4SWCS464, Level 15, State 4, Procedure , Line 1
The identifier that starts with '<EVENT_INSTANCE><EventType>CREATE_VIEW</EventType><PostTime>2006-11-09T09:56:48.390</PostTime><SPID>152</SPID><ServerName>XF4SWC' is too long. Maximum length is 128. (Source: MSSQLServer, Error number: 103)
Get help: http://help/103

View Replies View Related

Snapshot Share Access Problems After Publication And Web Sync Wizard

Hi

I've big problems with my SQL Server 2005 Std. merge replication/snapshot share

I want to create a mobile application based on a ms sql 2005 mobile database running on a pocketpc 2003se.

for this task i installed iis, sql server 2005 std. and the sql server mobile tools.

i created a dedicated user for making snapshots in the new created and functionable publication, but when i start the web sync wizard, i alwas get the failurmessages

snapshot share "......" cannot be accessed, please specify a new share

the access permissions based on the share an based on the ntfs area are set right.

the user, i chose for the anonymus access (the same, as for creating snapshots), has enough rights on the folder. also when creating a new share, with different share name, and using another user for anonymus access (standard iusr_machine_name) i get the same message

 

do you have any suggestions for my problem??

 

please i need help as soon as possible

best regards

View Replies View Related

Unable To Re-create Snapshot Of Existing Publication Due To Missing Publisher's Identity Range Allocation Entry

I re-created a publication that was having problems and it gives this error when I start the snapshot agent from SQL Server Management Studio:  I am stuck on how to resolve - any ideas?

"The publisher's identity range allocation entry could not be found in MSmerge_identity_range table.  Transaction count after EXECUTE indicates that a commit or ROLLBACK TRANSACTION statement is missing.  Previous Count = 1, current count = 2."

select * from MSmerge_identity_range returns 19 entries but I don't know how to fix. 

I have tried deleting and re-creating but always get this error.

My other publications and subscriptions are working fine and I was able to create a new test publication that worked but can not get this one to work that worked fine up until today. 

 Any ideas?

 

View Replies View Related

This Publication Differs From The Publication To Which The Subscription Was Initially Created

I'm getting this error on the subsciber, what is correct,
because I removed the publication and recreated it.

But I wan't to catch this speccific error, so I can recreate the local subscription.

How should I do that?

Complete error:
-        ex    {"This publication differs from the publication to which the subscription was initially created. The original publication may have been deleted and replaced with a new publication with the same name. At the subscriber, delete the subscription and recreate it for the new publication. "}    Microsoft.SqlServer.Replication.ComErrorException

Some more info:
C# 2.0
And I'm doing Web Sync Pul subscription with
Microsoft.SqlServer.Replication;
Microsoft.SqlServer.Management.Common;

View Replies View Related

Obsolete Objects

 

Hello,
 
I need to find all of the SQL Server objects, (tables, procs, functions, etc.) that my application is NOT using, so they can be removed from the system. Does anyone know how to accomplish this?
 
Thank you,
 
Dave

View Replies View Related

SQLmaint Obsolete In SQL2005!?!

:mad: It seems that the SQLmaint is going to obsolete in SQL 2005, what happen to my "sophisticated" SQLmaint scripts!!!! Any help or comment?

View Replies View Related

Warning: Obsolete Page

Has anyone see this message before

Warning: Obsolete page _____, dbid _ found in page cache.

If so, what is it, and how does it happen, and how can I stop it from happening.

Thanks,

Doug

View Replies View Related

Obsolete Table Columns

When I find that a column should no longer be used because of design changes. ( Moved column to other table to correct design normalization etc.)

I added a check to make sure the column must be NULL.

The following list the obsolete columns

SELECT col.TABLE_NAME + '.' + col.COLUMN_NAME AS FULL_COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS col
JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
ON col.COLUMN_NAME = ccu.COLUMN_NAME AND col.TABLE_SCHEMA = ccu.TABLE_SCHEMA AND col.TABLE_NAME = ccu.TABLE_NAME
JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
ON ccu.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA AND ccu.CONSTRAINT_NAME = cc.CONSTRAINT_NAME
WHERE IS_NULLABLE = 'YES' AND cc.CHECK_CLAUSE = '([' + col.COLUMN_NAME + '] IS NULL)'
ORDER BY col.TABLE_NAME, col.COLUMN_NAME


In the past columns could not be set to null.
This script list those columns that I need to add null checks to.

SELECT col.TABLE_NAME + '.' + col.COLUMN_NAME AS FULL_COLUMN_NAME, cc.CHECK_CLAUSE
FROM INFORMATION_SCHEMA.COLUMNS col
JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
ON col.COLUMN_NAME = ccu.COLUMN_NAME AND col.TABLE_SCHEMA = ccu.TABLE_SCHEMA AND col.TABLE_NAME = ccu.TABLE_NAME
JOIN INFORMATION_SCHEMA.CHECK_CONSTRAINTS cc
ON ccu.CONSTRAINT_SCHEMA = cc.CONSTRAINT_SCHEMA AND ccu.CONSTRAINT_NAME = cc.CONSTRAINT_NAME
WHERE cc.CHECK_CLAUSE LIKE '([[]' + col.COLUMN_NAME + '] =%' AND
NOT cc.CHECK_CLAUSE LIKE '% OR %' AND
NOT cc.CHECK_CLAUSE LIKE '% AND %' AND
NOT cc.CHECK_CLAUSE LIKE '% IS %' AND
NOT cc.CHECK_CLAUSE LIKE '% IN %'
ORDER BY col.TABLE_NAME, col.COLUMN_NAME


Tim S

View Replies View Related

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

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 Replies View Related

User Defined Function Obsolete

Hi,


sometimes after modifying a UDF (for example adding a column to the output) the statements refer it raise an error like the function has never been modifying , than in the previous example sql server doesn't find the last added column.

If I reapply the "alter" statement script of the function all works fine.It seams there is a sort of internal cache that need to be updated ...

Nobody have never been founding a similar behavior? :confused:


Thx

View Replies View Related

Cube Has Been Updated By The Server, Data Is Now Obsolete

Client issues query which sends out individual requests to the 2 OLAP servers that are load balanced. The client evaluates the versions of the returned record sets to ensure the consist data being returned for one single query. Otherwise, this error will be seen:

The cube has been updated by the server the data is now obsolete.

These servers sit behind a cisco 11506 CSS with load balancing based on balance type: least busy server, also persistence based on cookies.

My developer says this worked fine for a long time then just 'started happening'.

any suggestions are appreciated.

View Replies View Related

Problem When Applying A Snapshot When Tables Have Been Updated During Snapshot Generation

Hi

   I seem to have a strange problem when applying a snapshot when the tables in the publication have been updated while the snapshot was being generated.

 

  Say for example there is a table called RMAReplacedItem in the publication. When the snapshot starts being applied to the subscriber, a stored procedure called sp_MSins_RMAReplacedItem_msrepl_css gets created that handles an insert if the row already exists (ie it updates the row rather than inserting it). However, after all the data has been loaded into the tables, instead of calling this procedure, it tries to call one called sp_MSins_RMAReplacedIte_msrepl_cssm - it takes the last letter of the table name and adds it to the end of the procedure name.

 

   The worst part is that this causes the application of the snapshot to fail, but it doesnt report what the error is, and instead it just tries applying the snapshot again. The only way i have managed to find which call is failing is to run profiler against the subscriber while the snapshot is being applied and see what errors.

 

   I have run sp_broswereplcmds and the data in there is what is applied to the subscriber - ie the wrong procedure name.

 

   All the servers involved are running sql 2005 service pack 2. The publisher and subscriber were both upgraded from sql 2000, but the distribution server is a fresh install of sql 2005.

View Replies View Related

Cannot Add Publication

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 Replies View Related

Publication

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 Replies View Related

Is DB Publication/subscription?

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 Replies View Related

How To Add New Article To Publication?

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 Replies View Related

Add A Table To A Publication

Hi,

Here is my Q: I already put in place a transactional replication, the subscribers are already in sync, but now a few more tables have been added to the published DB. I've managed to add the articles using sp_addarticle and sp_addsubscription, but the problem now is that I don't want to generate a full snapshot (published db has 100 GB and it takes a few hours to complete) but only the part corresponding to those I added lately...is thhat possible?
How SQL 2000 generates the .sch .idx and .bcp. files from the snapshot folder?

TIA,

S.

View Replies View Related

Publication Tables

Hello everyone,
Having a problem here that I hope someone can help with.

I am replicating a couple of databases to a remote MS SQL Server (6.5) from a MS SQL Server (6.5)
and need to replicate parts of the same two databases back here. I have installed publishing on both
machines and have the replication working fine to the remote site. The problem is that when I go
setup the publications no tables are listed in the "Articles for publication" area under "Database
tables." I am aware that you need primary keys w/unique values for a table to show up. I have
checked that and all the tables meet that requirement. Also of note, other databases on the same
remote server show their tables perfectly fine if I try to set up articles for them the only difference
seems to be that these other databases aren`t subscribing to any articals from any other servers.
I have tried removing the subscription to the tables in question and they still do not show up.
Any help / insight would be greatly appreciated.

Thanks
Levi Akers

View Replies View Related

Resetting Up A Publication

I ran through the wizard to get rid of a publication so I can redo it. When I run through the wizard to create the same publication, I receive the following error:

Could not create publication 'db1' on 'db1'
Error 14294 Supply either @job_id or @job_name to identify the job

and it won't let me create the publication. Can anyone help?

Alan

View Replies View Related

Modify Publication In SQL 7.0 . Please Help !!

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 Replies View Related

Error In Publication

I am trying to set up a replication scheme that can be scripted.
But, when I try to add the publication to the database, I get an error that says
"Supply either @job_id or @job_name to identify the job".

What's is the problem????

I'm hoping someone out there has already gotten past this roadblock and can offer
some help.

Thanks in advance...

View Replies View Related

Can Not Able To Create Publication

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 Replies View Related







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