Header Information Is Either Corrupted Or Missing. While Synchronization Between SQL Server 2000 && SQL Server CE 2.0

Jun 30, 2007

Hi
I am stuck while doing synchronization between SQL Server 2000 and SQL Server CE 2.0.
getting an Error "Header information is either corrupted or missing."

My Specification is follow :
Windows XP with SP2
Visual Studio 2005 Enterprise edition
SQL Server 2000 (SP3a)
SQL Server CE 2.0
Application is Smart Device application (Pocket PC 2003) using C#.
Microsoft ActiveSync 4.5
IIS 5.1

I followed steps as per given in this URL :
http://msdn2.microsoft.com/en-us/library/ms839425.aspx#sql_serverce_replication_net_topic2I performed eeach steps successfully, My code is as per given below.

private void button1_Click(object sender, EventArgs e)
{
getSyncReady();
}

SqlCeReplication loSqlCeReplication;
private void getSyncReady()
{
try
{
String lsDBFile = "Northwind.sdf";
loSqlCeReplication = new SqlCeReplication();
loSqlCeReplication.InternetUrl = "http://192.168.0.5/Northwind/sscesa20.dll";
loSqlCeReplication.Publisher = "C99";
loSqlCeReplication.PublisherSecurityMode = SecurityType.NTAuthentication;
loSqlCeReplication.Publication = "NorthwindProducts";
loSqlCeReplication.PublisherDatabase = "Northwind";
loSqlCeReplication.Subscriber = Dns.GetHostName();
loSqlCeReplication.SubscriberConnectionString = "Data Source=" + lsDBFile;
if (!System.IO.File.Exists(lsDBFile))
{
MessageBox.Show("The application requires synchronization", "Replicator",
MessageBoxButtons.OK, MessageBoxIcon.Asterisk, MessageBoxDefaultButton.Button1);
loSqlCeReplication.AddSubscription(AddOption.CreateDatabase);
}
loSqlCeReplication.Synchronize();
}
catch (Exception foException)
{
throw foException;
}
}



I am not getting whats going wrong.
My Firewall is disable and i have not installed any antivirus softwares (including Norton internet Security....in many forums i got this suggestion but i think its not an issue,even though for solving this issue i performed new installation of Windows XP SP-2 )

View 4 Replies


ADVERTISEMENT

Error : Header Information Is Either Corrupted Or Missing.

Mar 3, 2006

My config :



1 computer with win2000, IIS, McAfee Virus Scan, and all I need to develope.



1 computer with VS2005.



When I try to make merge replication I have this Error :Header information is either corrupted or missing.



I search on the web and find some information like that error is cause by NIS (Norton Internet Security) but I dont have it.



I have another mobile software in VS 2003 and I don't have trouble whit im. It work perfectly but not in VS 2005.



I can access to the replication folder. I use sscesa20.dll.



Need help



thanks.

View 2 Replies View Related

SQL Server 2012 :: Replication - Missing Stored Procedure Comment Header

Jul 25, 2013

I have recently started using replication in SQL 2012 SP1. When a stored procedure is altered on the source, the changes are replicated to the subscribers; however, the comment headers are removed at the subscribers. Due to the vast number of stored procedures I have, I do not want to move the comments below the Create Procedure statement. Are there any other ways to have comment header move with the stored procedures?

Here is what I am experiencing

Source SP

ALTER PROCEDURE [dbo].[SPTest]
AS
BEGIN
SELECT GETDATE()
END

Destination SP

ALTER PROCEDURE [dbo].[SPTest]
AS
BEGIN
SELECT GETDATE()
END

View 7 Replies View Related

Does Sql Server Compact Edition 3.5 Support RDA Synchronization With Sql Server 2000 Database?

Jan 21, 2008

Does Sql Server Compact Edition 3.5 support RDA synchronization with Sql Server 2000 database?

View 4 Replies View Related

Mirroring :: 2012 Database Mirror Missing Witness Server Information?

Oct 24, 2015

missing witness server information and the fail-over is broken suddenly? 4:00am no maintenance job. I have one sql job on 10pm for backup on database transaction log only.

I can see the primary have problem then perform fail-over to mirror database, the auto fail-over was broken.

I re-build the sql mirror is OK , but i want to find the root cause.

Windows application event was full when there have many failed event, i have increase log size for application event.  

View 7 Replies View Related

Synchronization Of SQL Server 2000 && SQL-Lite Data

Sep 21, 2005

I have a master database containing data from many client databases located in various locations.
I have to synchronize data between the master & client databases. If data in client changes, the master needs to be updated. If the data in Master changes, the client needs to be updated.

Because of the security issue, the client location will initiate this process of Synchronization. It has to be automatic process scheduled once everyday. The Client databases are SQL-Express Databases and the Master is Sql Server 2000 database.

What is the industry standard or the best way to achieve this task ? Are their any tools that easily accomplish this? Can SQl Server Replication achieve this ?

Thanks

View 1 Replies View Related

Pocket Pc 2002 Sqlce Data Synchronization With Sql Server 2000 (SP4)

Mar 11, 2006

i am using C#..net

I am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication
class.

the error is

"a call to sql server reconciler failed"

native error 29006

and sometimes

native error

29045.

View 4 Replies View Related

Need Information On SQL SERVER 2000 With Multi-threading CPU

Nov 23, 2005

Hi,I have SQL SERVER 2000 SP4 Enterprise , Windows 2003Enterprise onXeon 4 Processors (now with multi-threading CPU) and I havequestions whichseem weirds to me (used to have the same config withoutMulti-Threading) as following:1. SQL Server see 8 CPUs. Is this because ofmulti-threading CPUs ?2. when use SP_WHO2 ACTIVE ,2.1 Result has user SPID , which blockitself(it is UPDATE and SELECTstatements, most often)2.2 Result has user SPID , show morethan one result rows withthe same processe and command3. when use Properties of SQL Server , it has anerror 15407 in log.many thanks in advanceNiponW

View 2 Replies View Related

License Information For Best Practice Analyser For SQL Server 2000

Jul 26, 2007

Hi,
I have downloaed microsoft's Best Practice Analyser for SQL Server 2000. I would like to recomend this tool in our organisation. Before that i want to confirm that is there any restrictions to use this tool or it is an free ware tool.

View 1 Replies View Related

SQL Server 2000 Enterprise Manager Snap-in Missing

Nov 11, 2006

After running virus cleaning software on my HD, I suddenly find my Enterprise Manager snap-in missing and fail to initialize. Is the MMC erased or damaged? What should I do? Reinstall SQL Server 2000 or repair it? Please advise. Thanks.

View 3 Replies View Related

Scheduling Snapshot And Synchronization Is Missing On The Generate Scripts

Aug 10, 2006

hello all,


i need to bring down the entire replication solution

but just before i do that i need to script. The EM has a generate script feature

but it lacks the schedule for snapshot generation and synchronization



by the way,

whats the fastest way of melting the entire replication solution and

then brinnging them back again.

Can i do replication backup and restore?
regards,
joey

View 1 Replies View Related

SQL 2012 :: Adding Header Information To XML Generated File

Apr 23, 2015

I have a sql query:

SELECT
'5' AS 'value/@version',
'database' AS 'value/@type',
'master' AS 'value/name',
LTRIM(RTRIM(( [Server Name] ))) AS 'value/server',
'True' AS 'value/integratedSecurity',
15 AS 'value/connectionTimeout',
4096 AS 'value/packetSize',
'False' AS 'value/encrypted',
'True' AS 'value/selected',
LTRIM(RTRIM(( [Server Name] ))) AS 'value/cserver'
FROM dbo.RedGateServerList
FOR XML PATH(''), ELEMENTS

I need to add some header information to the beginning of the query:

<?xml version="1.0" encoding="utf-16" standalone="yes"?><!--
SQL Multi Script 1
SQL Multi Script
Version:1.1.0.34--><multiScriptApplication version="2" type="multiScriptApplication"><databaseLists type="List_databaseList" version="1">

Everything I have tried ends up as a failure, usually compile issues. My goal here is to be able to automare a configuration file for multiscript so I can keep my server list up to date.

View 2 Replies View Related

Missing Information From Database

Aug 14, 2007

I have a serious problem with either SQL Server or SQL Reporting Services. I have 7 tables in a database that are relational. I have created serveral reports against this database. Last week when I pulled one of the reports, I was missing information on one of the cells. The reason why I know this is because my boss has us verify the report against the database. That took about an hour to complete. When we found that the report was not correct I repulled the report and the cell that was empty, was now populated. What gives? This is the same report I have pulled for the last month and had no problems until now. Is there a time issue involved between the last update to the database to the time I pull the report? Or maybe there is something wrong with the query?

SELECT Lease.[Lease #], MineralContacts.[Mineral Owner First Name], MineralContacts.[Mineral Owner Last Name], Tract.County, Tract.[Tract Number],
Tract.[Tract Description], Tract.Section, Tract.Block, Tract.Survey, Tract.Abstract, Lease.[Lease Date], Tract.[Title Check Though], Tract.[2ndTitleReview],
Tract.[2nd R/S Complete], Tract.[Title Agent], Tract.[Tract Gross Acres], SubTract.[Tract Net Acres], Draft.[Draft Status], Draft.[Draft Due Date],
Draft.[Draft Amount], Draft.[Draft #], Draft.[ANB Invoice #], Draft.[Lse File Sent to CP], Draft.[Money Wired from CP to EA],
Draft.[STA Approved Draft for pmt], Draft.[STA Recommend to Return Daft], Draft.[KE Advised ANB to Pay Draft], Draft.[KE Advised ANB to Return Draft],
Draft.[Paid Draft Recd], SubTract.Comments, SubTract.Hide
FROM Tract INNER JOIN
SubTract ON Tract.TractID = SubTract.TractID INNER JOIN
Mineral ON SubTract.SubTractID = Mineral.SubTractID INNER JOIN
Lease ON Mineral.MineralID = Lease.MineralID INNER JOIN
Draft ON Lease.LeaseID = Draft.LeaseID INNER JOIN
MineralContacts ON Mineral.MineralID = MineralContacts.MineralID
WHERE (Draft.[Draft Status] IS NOT NULL) AND (Draft.[Draft Due Date] IS NOT NULL)

View 1 Replies View Related

Missing Data In Page Header When Exporting To Excel

Mar 12, 2008



Hello all,

I have a report that I need to reference data in my Page Header. I am referencing 2 data fields in my report body to do this. The report will render fine and the data is present in my Pager Header; however, when I export to Excel, the data is missing; only my labels are present. What's even stranger is that it works just fine if I export to a PDF file.

Below is the expression code from one of the fields in my Page Header :

="From: " & ReportItems!dtBegDate.Value


Again, the report will render fine and my data is present. It only comes up blank when I export to Excel. The only part of the data that makes it over is the text (i.e. "From:")

I'm at a loss on this. Any suggestions?

Thanks,

Karl

View 2 Replies View Related

Help - Corrupted SQL Server 2K Log. Is This Serious

Jul 23, 2005

Hello,I have a SS2K (SP3) that is appending very wierd looking error messagesto the SQL Server Log (Current). The messages are not formatted asother log entries. The messages suggest some kinda dump information.The messages have the following characteristics:Date Information is invalidSource information is invalidMessage information is strangeThe following is a message that appear in my current SQL Server LogDATE:78008454SOURCE: Module(MSVCRT+Message (_endthread+000000C1)There are many messages like this in the log.Is this serious?Thanks - Covi

View 1 Replies View Related

Sql Server Corrupted.

Jul 18, 2007

I am having problems with my applications files. Part of my windows foundation or plug and play (error 31 - device not attached to system). I also found that my sql server is corrupted and I got the message to uninstall and reinstall. I don't know how to find where to go to re-install and unfortunately I uninstalled the VSS sql already. How do I find my sql server to re-download? help!

View 1 Replies View Related

SQL 2012 :: SSRS Export To Word Header Background Color Missing

Mar 17, 2015

I have a SSRS report developed in SQL 2012. When I exporting the report into word the back ground colour of page header missing. When Exporting to PDF and Excel page header BG colour showing.

View 0 Replies View Related

SQL 2000 Corrupted Record! Can't Delete Table

May 9, 2008

Hi All,

I have just one corrupted record on a table: I copied everything else to another table but I can't delete or rename the old one!

Is restoring the whole DB my only way out there?

Any help or suggestion would be much appreciated!

Cheers

View 8 Replies View Related

SQL Server Express Synchronization With Sql 2005 Server

Apr 17, 2008



Hi,

We have a window based application which uses sql server express as a backend...

Currently, We are sending xml files to the users to update their application with data users also sends data in xml format to us.

We receive data from various users and collate it on a central server for analysis..

We prefer having sql server express as a local data store so that user does not depend on live connection to the central server. But we would like to have a on demand syncronization or scheduled snyncronization with central sever ,,,

There are many approaches to it... my question is which is the best for our given scenario. Is it using web service or sql sever broker or sql synnchronization.

If you can direct me to some practical implementation then it will be great help.



Thanks

San

View 1 Replies View Related

Synchronization Between SQL Server Express - SQL Server Mobile

Dec 7, 2006

Hello,

I plan to use :

- SQL Server on server
- SQL Server Express on notebooks
- SQL Mobile on Windows Mobile 5.0 devices.

How can I create a replication between SQL Express and SQL Mobile ? SQL Server express cannot act as a Publisher server.

In this post a Senior Program Manager says It is possible but I don't find how to :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=55236&SiteID=1

Thanks

JF

View 1 Replies View Related

Cannot Start Your Application. The Workgroup Information File Is Missing Or Opened Exclusively By Another User.

Aug 24, 2007

hye everyone,
when i browse my web application the eror as below display..
what should i do..
any suggestion or tips...

"Cannot start your application. The workgroup information file is missing or opened exclusively by another user. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Cannot start your application. The workgroup information file is missing or opened exclusively by another user. "


thanks in advance..
thank you very much..

View 1 Replies View Related

2000 DTS Packages Corrupted By 2005 Client Tools?

Jan 12, 2006

Hi,

I have many sql 2000 DTS packages that I support from my development workstation  running v2000 sp4. Packages are altered on the development machine and then go through a normal release mechanisms to production via testing servers etc.

I have recently installed the client tools for SQL Server 2005 on my desktop to evaluate the product.  The 2005 DB instance is running on a seperate server.

So, I have dev edition of sql 2000 and 2005 client tools (including BI Dev studio etc) on my workstation.

I have recently had to make changes to a 2000 DTS package and used my 2000 enterprise manager to do so. No Problem- saved and tested fine on my workstation. 

But when I try and release it to another server, or open the package using enterprise manager from another machine that does not have sql 2005 installed - I get an error message 'Unspecified error'.  This I've seen before when trying to open packages created in v2000 , using v7 or where the service packs are different between machines.

Digging around my workstation and comparing some of the DLLs I know to be required to distribute DTS  packages (from RDIST.txt) it seems that some of the SQL 2000 dll files have been updated by my 2005 installation. 

E.g

DTSFFILE.DLL on my machine is 2000.85.1054.0 whilst on any 'clean' 2000 machine is at version v2000.80.760.0

Surely it cant be right that SQL 2005 has newer versions of components for SQL 2000 than is available with the latest SP for the actual product! Especially considering that the installation of 2005 does not even allow you to edit 2000 DTS packages through the management studio without a 'special' download' of the feature pack,(whihc by the way does not work very well either)

So am I to conclude that you can not run side by side installations of SQL 2000 and 2005 on a single machine and expect 2000 to run as it did previously

View 11 Replies View Related

Error: Cannot Start Your Application. The Workgroup Information File Is Missing Or Opened Exclusively By Another User.

May 7, 2008

Hi all,
I'm kinda new at programming, and am currently attempting to create a web application.  I have an error when I try to insert information into a sql server database, and can't find how to fix it no matter how hard I try.
The error I get is: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
I have it so a user is logged in and is shown a form to fill out, then submits it (which creates an insert statement and sends it to the database).
My connection string is as follows:
CnnString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "data source=serverdestination;" + "User id=user;" + "Password=pass;";
If you need any more information, just let me know.
Any help would be greatly appreciated!

View 2 Replies View Related

Corrupted Table In SQL 2000, DBCC CheckDB Found No Errors

Jan 21, 2008

Hello,

I am facing an issue with a table in my database.

1) When I run a query Select * from MY_Table the query never completes. If I press cancel in Query Analyzer after 1 second or 2 minutes, it always shows the same 174 records. The total table size is 800 KB with 3148 rows .. according to TaskPad

2) No queries, even queries that would return only 1 record complete execution against that table

3) I am unable to rename the table, if I try to rename the table Enterprise Manager becomes unresponsive and has to be closed.

4) If I try to browse the rows through Enterprise manager by scrolling through the records, it allows me to go down through a number of rows and then Enterprise manager gives me a timeout expired error.

5) I ran a DBCC CheckDB command ran for 1 hr and 7 minutes. It says there are 0 allocation errors and 0 consistency errors in the database.

6) The other database tables seem to be OK and the Database is operational except for calls involving the 1 Table

7) I am unable to Drop the Table

8) DBCC CheckAlloc finds 0 allocation errors and 0 consistency errors.

9) DBCC CheckTable on MY_Table returns with: There are 3148 rows in 33 pages for object 'MY_Table' .. no errors are printed.


Can one of the SQL Gurus on this forum please recommend a course of action.

Thanks in advance.

View 1 Replies View Related

Unable To Connect To SQL Server EndPoint Through SQL Server Authentication Using WS-Security Header

May 14, 2008

Hi folks,

I have created an EndPoint in SQL Server 2005 as per the code below.


CREATE ENDPOINT OSTC_LMS_Endpoint

AUTHORIZATION LMSEndPointUsers

STATE = STARTED

AS HTTP(

PATH = '/ostc_sql_endpoint',

AUTHENTICATION = (BASIC),

PORTS = (SSL),

SITE = 'OSTC-DEV-001'

)

FOR SOAP (

WEBMETHOD 'ostc_SQLSoapTester'

(name='OSTC_LMS_06.dbo.ostc_SQLSoapTester',

FORMAT = ROWSETS_ONLY,

SCHEMA=STANDARD),

WSDL = DEFAULT,

LOGIN_TYPE = MIXED,

SCHEMA = STANDARD,

DATABASE = 'OSTC_LMS_06',

NAMESPACE = 'http://tempUri.org/'

)

GO

USE master

GRANT CONNECT ON ENDPOINT::OSTC_LMS_Endpoint

TO [LMSEndPointUsers]

GO

USE master

GRANT CONNECT ON ENDPOINT::OSTC_LMS_Endpoint

TO [ostc-dev-001endPointUsers]

GO

-----------------------------------------------------------------------------------------------------------------
The SPROC being exposed as the webmethod: -


USE OSTC_LMS_06

IF EXISTS (SELECT name FROM sysobjects

WHERE name = 'ostc_SQLSoapTester' AND type = 'P')

DROP PROCEDURE ostc_SQLSoapTester

GO

CREATE PROCEDURE ostc_SQLSoapTester

@UsersId char(12)

AS

SET NOCOUNT ON

SELECT FIRST_NAME,FAMILY_NAME

FROM USERS

WHERE USERS_ID = @UsersId

GO



USE OSTC_LMS_06

GRANT EXECUTE ON ostc_SQLSoapTester

TO LMSEndPointUsers

GO

USE OSTC_LMS_06

GRANT EXECUTE ON ostc_SQLSoapTester

TO [ostc-dev-001endPointUsers]

GO

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

The computer in question is our dev server and is running as a workgroup machine with the following: -
Win Server 2003
SQL Server 2005
.net Framework 2.0
No firewalls or Proxies are in the way.

The computer has to be as a workgroup machine to reflect our live server.

The user LMSEndPointUsers is a SQL Server Login
The user ostc-dev-001endPointUsers is a machine login

We have employed the Security class as per the information given in the SQL Server documentation with the intention of using the WS-Security headers that apparently are to be used when trying to authenticate using a SQL Server login.

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

Code used to connect and try and reciev the dataset.


string sUserName = "userName";

string sPassword = "Password";



LMS_Endpoint.OSTC_LMS_Endpoint wsSQLTester = new LMS_Endpoint.OSTC_LMS_Endpoint();

SqlSoapHeader.Security sqlSec = new SqlSoapHeader.Security();

sqlSec.Username = sUserName;

sqlSec.Password = sPassword;

XmlWriter writer = XmlWriter.Create("Security.xml");

writer.WriteStartElement("security");

sqlSec.WriteXml(writer);

wsSQLTester.sqlSecurity = sqlSec;


DataSet dsMySet = wsSQLTester.ostc_SQLSoapTester("RH6915145507");


Basically authorization is denied 401.
Hope someone can help here as have tearing my hair out.

Thanks in advance

View 2 Replies View Related

Recover A Database From Another Hard Disk With A Corrupted Windows 2000 Installation.

Jul 23, 2005

Hello,I am trying to recover a SQL Server 7 database from another hard diskdrive that has a corrupted Windows 2000 Advanced Server installation. Iam not able to repair the corrupted Windows 2000 Advanced Serverinstallation but the file system is intact. I have installed a new copyof SQL Server 7 onto a new hard disk and have used the sp_attach_dbsystem stored procedure to attach the database from the old hard driveinto the new installation of SQL Server 7 on the new hard drive. Thedatabase shows up in the Enterprise Manager View and all the data andstructure are there, but when I try to run a Web site that uses ODBCconnections to the database I get the following error:ODBC Error Code = 08001 (Unable to connect to data source)[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL servernot found.I have double-checked that all the NTFS permissions, ODBC DSNs, and WebServer settings are correct and when I run the SQL Server ODBC drivertest at the completion of each ODBC DSN setup, it is successfull.1) Why am I getting this ODBC error?2) What steps have I missed in the recovery process?3) If I have done something wrong recovering my database, can I stillrecover it since I still have: a) The old master database file and logfile; b) The old database (non-master) file and log file; c)A backed-up(Enterprise Manager -> Right Click A Database -> All Tasks -> BackupDatabase) copy of the old database (non-master) file; ?My System Specifications:-Windows 2000 Advanced Server-SQL Server 7-IIS 5.0-Cold Fusion Server 4.5 Professional Full EditionThanks For Your Time,Nathan

View 2 Replies View Related

Sql Server Synchronization

Jun 6, 2002

hi!
all.

i want to create a web application architechture which having multiple web server.
this all web server having sql server database.
now what i want is to Keep all data in all databases.
means i want to synchronize my all sql servers.
it is also possible ki my one webserver can have multiple clusted database.
hope to hear soon from u people.

Regards
Viky

View 1 Replies View Related

Sql-Server Synchronization

May 24, 2007

Dear All,

How to do Sql Server Synchronization.

Say:
Server "A" contains "123" database.
Server "B" contains "123" database.

But changes is made on Server A. I want that every changes made on server A "123" database should reflect on Server B "123" database on real time basis.

whether it is done through replication or any other way, i want practical answer so that i can try it out.

Thanks

View 2 Replies View Related

Sql Server Synchronization

Feb 12, 2006

I want to realize these steps in .net2005 C# programme:

1) Start Sqlserver2005 publication snapshot agent.

2) View Sqlserver2005 snapshot agent status, if it finished then go on.

3) Start Sqlserver2005 Subscription synchronization agent.

4) View Sqlserver2005 synchronization agent status, if it done then continue.

I tried to find some SP, dll, method or script to realize this funtion, but failed.

I really need help.

A thousand thanks for your patience.

View 3 Replies View Related

SQL Server Admin 2014 :: Server Level Trigger To Log Activity And Rollback After Logging Information

Sep 8, 2015

I use following trigger to stop user "smith" if he try to connect through SSMS to My Server:

create TRIGGER [trg_connection_MyServer]
ON ALL SERVER WITH EXECUTE AS 'Smith'
FOR LOGON
AS
BEGIN
IF ORIGINAL_LOGIN()= 'Smith'
begin
if exists (SELECT 1 FROM sys.dm_exec_sessions
WHERE (program_name like 'Microsoft SQL Server%' and original_login_name = 'Smith') )
ROLLBACK;
end

I want to log this information or send emal incase, this user try to connect through SSMS, so that I can catch it. How can I do this, if I use insert command it rollsback everything and I can't do any activity.

View 8 Replies View Related

Sql Server 2005 Compact Edition 3.1 RDA Synchronization Fails On Table With Index In Sql Server 2005 Database

Jan 21, 2008

We have been using Sql Server 2005 Compact Edition 3.1 RDA synchronization method successfully on Sql Server 2000 database. Recently we moved the database to Sql Server 2005, sync doesn't work anymore, it just hangs on one table. On further investigation, we found out that it's the index on that table that causes this. We removed the index, it works fine. We are wondering the root cause, removing the index is not a solution for us. Any thoughts?. Thanks.

View 1 Replies View Related

Web Synchronization For SQL Sever 2000?

Dec 6, 2005

Knowing that web synchronization is a new feature comes with SQL Server 2005. 

View 1 Replies View Related

Synchronization Between Two SQL Server Database

Jun 23, 2005

I have two SQL Server Database, one is at my company and one is at my company's customer. There are two related databases and two related tables in the servers. When I make a change in the table at my database, I want these changes to be done at the other server. I mean the related tables should have the same records all-time. I made a search and found that "Linked-Servers" is a good idea in this scenario. I made a linked server and run the following query in the Query Analyzer;insert into SAMPLE_LINKED_SERVER.SAMPLE_DATABASE.dbo.SAMPLE_TABLE(id,name) Select id,name From MY_SAMPLE_TABLE Where id Not In (Select id From SAMPLE_LINKED_SERVER.SAMPLE_DATABASE.dbo.SAMPLE_TABLE)This query works as I wanted. But I want this process to be done automaticaly without user interaction. Should I use Trigger? Do you suggest using Linked Servers?Or is there any other methods to make synchronization between two SQL Server Database?If I cannot find a good method in SQL Server, then I will be forced to make this synchronization by writing .NET code, but that would be difficult I think. Any suggestion and comment is wellcome.Thanks in advance.

View 2 Replies View Related







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