Problems With Sync_type 'replication Support Only'

Jun 30, 2006

Hi,
I try to setup a transactional push replication from MS SQL Server 2005 to Sybase ASE 12.5.3. ASE is known to MS SQL Server as a linked server using OleDB.
As table schema and data are valid at subscriber site I don't need a initial snapshot for the replication.
So I do some tests with sync_type (sp_addsubscription). First I tried 'none'. That works fine.
But the documentation says that it is depricated an I should use 'replication support only'.
But with this syn_type replication stops because is sends the following commands to the subscriber:

--
-- Transactional replication custom procedures for publication 'kunktable_pub' from database 'kunktest2':
--
----
---- Replication custom procedures will not be scripted for article 'kunktable' because the auto-generate custom procedures schema option is not enabled.
----

IF (@@microsoftversion >= 0x09000000) BEGIN EXEC sys.sp_MSrepl_setNFR @schema = N'dbo', @object_name = N'kunktable' END

Of cause Sybase ASE throws an error 137 'Must declare variable '@@microsoftversion' because it has no system variable @@microsoftversion. Furthermore a procedure sys.sp_MSrepl_setNFR is not known at ASE site.

So it seems, that sync_type ''replication support only' only works for MS subscriber but not for ODBC or OLEDB based subscriber like SYBASE.

Question:
Do I miss something ?
Is this a bug ?
Which sync_type should I use ?


Regards
Wolfgang

View 7 Replies


ADVERTISEMENT

Problem Dropping Replication Support

Jan 14, 2006

I am working on establishing a merge replication process between SQL Server 2005 and SQL Mobile 2005. I started with a new SQL Server 2005 instance and went through the Sample for SQL Mobile merge replication. So far so good.

Today, I tried to drop all support for replication on my current SQL 2005 test instance, so that I can start from a fresh instance and do another. I used Management Studio to drop all publisher and distribution settings and had several errors occur, where some roles were not allowed to be dropped because they had membership in them.

I dropped all the users that I added to the SQL logins and tried again.

Now I am trying to run the following script:

use AdventureWorks
exec sp_replicationdboption @dbname = N'AdventureWorks', @optname = N'merge publish', @value = N'false', @ignore_distributor = 'true'

-- Dropping the distribution publishers
exec sp_dropdistpublisher @publisher = N'XP-MIKED-LAPTOP'
GO

-- Dropping the distribution databases
use master
exec sp_dropdistributiondb @database = N'distribution'
GO

/****** Uninstalling the server XP-MIKED-LAPTOP as a Distributor. Script Date: 1/14/2006 2:16:29 PM ******/

use master
exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1
GO

The error I am getting from the first batch (sp_replicationdboption) is this:

Msg 208, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 103
Invalid object name 'dbo.sysmergesubscriptions'.

To me it looks like all the publication objects have been already removed from AdventureWorks, but in sysdatabases, the category column still says 4 (merge publication). Since I can't just do this anymore:

UPDATE MASTER.DBO.SYSDATABASES
set category = 0
where dbid=8

I just don't know what I can do at this point. I can't even create a new publication in AdventureWorks because it thinks there is a sysmergepublications table in there and fails when there isn't.

 

View 3 Replies View Related

Support For 3.5 Merge Replication Under SQL 2005

Dec 3, 2007

Been fiddling with SQL 2008 Nov CTP but now looking to deploy a 3.5 .sdf project using Merge replication. The 3.1 install sets up a web endpoint with sqlcesa30.dll and I have been running subscriptions just fine with that. But now I want to be able to create and manage my 3.5 publicatoin/subscriptions under SQL 2005 management console. I don't see how to create 3.5 sql ce databases there or to use 'configure web synchronization' to get a 3.5 web endpoint for syncing.

Am I missing something simple like registering the SQL CE 3.5 dlls to work with SQL management studio?
I want to install to this a production server with the smallest possible footprint and I do NOT want to inject SQL 2008 Nov CTP bits into that production server at all! So, how to deploy SQL CE 3.5 to production and set up 3.5 merge replication under SQL 2005?

View 9 Replies View Related

Sync_type Parameter In Subscription

Jun 12, 2006

Hi,



I tried to change the subscription property "sync_type" whith a system procedure but I was not able to do it, because sp_changesubscription does not support this property.



Is there any chance to change this property by procedure?



So I decided to drop the subscription and define it new with sp_addsubscription. I chose to set this to "replication support only" as the value "none" is depricated based on the online help. Unfortunately using this value results in an error message "only none or automatic is allowed".



How can I set this value now to "replication support only"?



I need to set the value to "replication support only" as this value leads into the generation of the stored procedures used for insert, update and deletes.



The purpose behind this, to restart a transactional push replication, doing all the initialization stuff by myself and not with reinitialize subscirption. I would like to decide, if I do the initialisation.

Regards

Nobsay

View 5 Replies View Related

Merge Replication: Does It Support UDTs && Defaults

Feb 27, 2003

Hi Everyone,

Can anyone help me with this little problem that im stuck with.
As part of the initial snapshot using merge replication, i am creating the initial schema on the subscriber database however it seems as though it does not like UDDTs or defaults and hence does not create them on the subscribers.

Its looking likely that I may have to create a script which executes on the subscriber which creates the initial schema then use merge replication to transfer data.

Does Merge Replication support UDTs/Defaults? If so how does it work?

Ive search many places though have come up with nothing.

Please help. = (

View 2 Replies View Related

SqlServer2005 Can Support Merge Replication With SqlCe2.0??

Sep 20, 2005

Hi guys,

View 29 Replies View Related

SqlServer2000 Can Support Merge Replication With SqlCe3.0??

Feb 23, 2006

I am developping a pocket pc windows application, using VS 2005. The SQL Ce that VS 2K5 uses is the mobile SQL CE 2005 (3.0). I uses SQL Server 2000 as the publisher. Is it possible to replicate SQL Ce 3.0 with SQL Server 2000?

View 1 Replies View Related

Sp_addmergereplication And @sync_type='None': Snapshot Is Still Delivered

Mar 20, 2007

Hello,

I'm hoping someone can help me with this. We use t-sql scripts to install merge replication and we have run into a bit of a problem. Sometimes the subscriber already has a database with data and we don't want to apply the snapshot. I thought that if you call sp_addmergereplication with the @sync_type set to 'none' then for that subscriber it will forgo the initial snapshot. It looks like it is still applying it and I'm getting foreign key constraint errors. This occurs on both 2k and 2k5. What's more we could swear that this used to work...

Anyway, any advice would be greatly appreciated. Thanks for reading!

Scott

View 4 Replies View Related

Changing The Sync_type Option Of A Subscription

Sep 15, 2006

If I create a subscription with a sync_type set to 'replication support only' is it possible to change that option to 'automatic' down the road without destroying and recreating the
subscription?

-mike

View 4 Replies View Related

VB Express SQL Expert Needed For Merge Replication Support.

Sep 3, 2006

I have done a couple of little projects in VB express and was pleased with the results. Now I have something bigger in mind and need to know if VB express version of SQL will support merge replication. If not will the full version support it?
Thanks
Dave

View 3 Replies View Related

Replication :: Current Transaction Cannot Be Committed And Cannot Support Operations That Write To Log File

Nov 4, 2015

After I watch a video for how to create MS SQL Replication, I configure distribution and create the publication. The problem comes from subscription. If I create a "PUSH" subscription, it works fine. However, when I create a "PULL" subscription, I got the following error. Where I should look for solution for this error.

View 5 Replies View Related

Support For SQL Express2005 My Host Provider Does Not Provide Support?

Dec 5, 2005

Reader Community
I've just started hosting my newly created Microsoft Visual Web Developer 2005 Express Edition web site.  Unfortunately the Login group membership functions will not function correctly.  Having contacted the web service hosting provider, They replied: "We do not support SQL express2005.  The only way to use the extra functions of ASP.NET2 such as group membership is if it is using an SQL 2000 database to connect to. "
Is it possible to design web sites with Microsoft Visual Web Developer 2005 Express Edition that store membership details on an SQL 2000 database?
I've just paid £88 approx. $140 for a years subscription, have I chosen the wrong web service hosting provider?
Should I have designed the web site with a better web site design software tool that also makes designing membership login functionality easy, just as Microsoft Visual Web developer 2005 express edition?
Look forward to all comments?
Regards
 
Philip

View 1 Replies View Related

Does SQL Server 2005 Express Support Web/Internet Replication To Other SQL Server Express Clients?

Jan 22, 2007

HI

Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?

Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?

Regards

View 5 Replies View Related

CE Support From ASP.Net 2.0

Dec 29, 2006

MS states that CE does not work with ASP.Net applications 'by default'. What is needed to change this default?

Bascially, my desktop app. is configured from a browser app. (ASP.Net 2.0) and I want to use CE as the datastore for the application.

Thanks.



View 12 Replies View Related

RAM Support

Jul 24, 2007

My documentation tells me that SQL Server Express only supports 1 gigabyte of RAM.
My computer can take 2 gigs, but I presently only have half a gig.

If I install 2 gigs on my machine, will that cause SQL Server Express to malfunction?

Or does it just mean that the extra gig will not be utilized?


Any advice would be much appreciated.

View 1 Replies View Related

Need SQL Support

Oct 27, 2006

Dear friends



I am a new developer. I need some SQL Language examples to write some quaries.

Ex.

how you collect last record that relevent for the last record updated for a relevent employee in a record table which includes RecordNo and EmployeeNo, salses



Thanks



Any help is greatly apprciated



Amila

View 1 Replies View Related

Configure SQL XML Support In IIS

May 17, 2006

I have configured SQL XML Support in IIS but still i am not able to Use
http://localhost/ss?Sql=select+*+from+users+for+xml+auto
 
I am getting Internal Server Error

View 1 Replies View Related

Versions Of SQL For SAN Support

Oct 22, 2001

I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?

View 2 Replies View Related

Discontinued Support For SQL 6.5

Nov 17, 1999

Has anybody heard or know anything about discontinued support for SQL Server 6.5?

I heard something about maybe 6 months after the release of SS 7.5.

Thanks in advance.

View 1 Replies View Related

Support Row Lock??

Jul 16, 1998

Do SQL 7 support row lock?

View 1 Replies View Related

Microsoft Support For 6.5

Jan 12, 2001

Does anyone know when Microsoft is due to end support for 6.5?

View 1 Replies View Related

Is There Anyway To See What Network Support You Use In EM?

Oct 6, 1998

Hi everyone,

I have several SQL Server 6.5 machines. I would like to see what network support each server uses and change it if possible through the Enterprise Manager.

Thanks...Binh

View 1 Replies View Related

Character Set Support

Sep 20, 2006

I'm looking at an MS SQL server database and it stores city namesacross the world. All aarabic , chinese etc names are converted to the latin alphabet.I feel it is probably critical we support accents as a means todistinguish between cities that would be converted to the same Latinalphabet representation otherwise and as a matter of culturalpoliteness.Now ...... how do we do this?Use varchar? which character code page do we use?Use nvarchar? I heard a rumour that SQL server pads unused characterswith blanks and hence will use space unnecessarily.The data will be presented on sheets and emailed around the world - itwill also appear on a website.Any advice greatly appreciated - thanksOliver

View 1 Replies View Related

SQL Mobile Support For CE 4.2

Aug 8, 2006

An update was supposed to be released for SQL Server Mobile which enabled support for CE 4.2. This was supposed to be released around the time of CF 2.0 sp1. SP1 came out over a month ago and there is still no sign of the SQL Mobile update. Does anyone have any information on a release date ?

View 6 Replies View Related

@@ROWCOUNT Support???

May 4, 2006

I am trying to work a statement like the below - but am getting an error - I assume that @@ROWCOUNT is not supported?



UPDATE MobileInvoiceImport SET OrderDetailID = '123', QuantityReceived = '66' WHERE OrderDetailID = '123'

IF @@ROWCOUNT = 0

INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) VALUES('123','1')

View 1 Replies View Related

OMAP850 Support?

Apr 13, 2006

Hi,

Pardon me if this is not the right forum.

Is SQL Mobile supporting OMAP850 ?

If yes what cab should I use to manually instal sql mobile on the device, OMAP850 is not listed in compact framework nor sql mobile folders

if no is there a plan to support OMAP850 one day?

Thanks,

Philippe

View 3 Replies View Related

No Support For WITH NOCHECK?

Apr 11, 2008

SQL CE does not seem to support WITH NOCHECK constraint when altering the table to add a foreign key. How can I work around this?

View 3 Replies View Related

End Of Support For SQL 2000

Mar 8, 2007

Does anybody know when Microsoft is planning to cut support for SQL 2000? Just recently we have learned that 7.0 is no longer supported.

Thank you in advance,



Leon Shargorodsky

View 1 Replies View Related

How To Support Various Language

Apr 21, 2007

How could i do if i need to use another language, unavailabel in collation such as laos, burma ?

View 2 Replies View Related

ODBC Support

Dec 29, 2006

Can CE be called from an app. that makes ODBC calls?

Thanks.

View 10 Replies View Related

Getting MS Remote Support For SQL

Feb 4, 2008



Hi, I need to get help for a SQL issue from Microsoft. On the website there seem to be two options--one is email support for $99 and another is "online" support for $259. What's the difference? Does the $259 option mean that Microsoft will remote log into my SQL Server and fix the issue while I watch? This is what I need done. Does this $259 pay for the whole issue, until it is resolved?

I am a Microsoft Certified Professional (MCSA)--do I get any discounts or is there any other avenues I should take to get remote support for SQL Server 2005? I wasn't sure where to ask this question, if it is more appropriate elsewhere then let me know.

Thanks!

View 3 Replies View Related

SQL 2000 SP3 Support

Apr 27, 2006

Has anybody heard that Microsft is dropping support for servers running SQL Server 2000 SP3?

View 1 Replies View Related

Dling Support?

Jul 24, 2006

Hi All.

What can we do to let the power that be know that there are many of us that want Dlinq to support SQL ev?

They say they are considering it, how can we help them deside?

Mike Greenway

View 6 Replies View Related







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