.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Subscriber data changes problems when use_partition_groups set to false

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello,Within our solution we use merge replication to replicate data between MS SQL Server 2008 (running on MS Windows Server 2008) and MS SQL Server Compact 3.5 (running on Windows XP Tablet PC). Initially we set the parameter @use_partition_groups of sp_addmergepublication to true. The replication worked well but later we have observed problems while inserting/updating records on publisher. (commands have been timed out) The timeout problem has been solved by setting @use_partition_groups to false - the performance on subscriber is good, but (as we later realized) subscribers are not getting the changes properly (Publisher’s deletes are not reflected at subscriber) We have found following thread however the answer did not help us: http://social.msdn.microsoft.com/Forums/fi-FI/sqlreplication/thread/638bc057-b12f-4e04-b42d-564b244c715fWe would need to solve this problem ASAP.Please help.Thx a lot in advanceRobert

View Complete Post

More Related Resource Links

Remote Data Access encountered problems when opening the database.

Hello,   I have some toubles with SQLCERemoteDataAccess   The exceptions are thrown on rda.Pull("Article", "Select * from Article", _ rdaOleDbConnectString, _ RdaTrackOption.TrackingOnWithIndexes, _ "ErrorTable")   with follow parameters : rdaOleDbConnectString = "Data Source=MyServeur;Initial Catalog=BddClient;User Id=admin;Password=admin;" InternetURLString = ""; LocalConnectString = "\\BACKUP\\AppliClient\\Bdd.sdf"     And the followinf error : Error Code: 80004005 Message : SQL Server Compact encountered problems when opening the database. [Internal Error Number =0, Internal Error String = ] Minor Err.:28559 Source :Microsoft SQL Server Compact   Error Code: 80004005 Message : Minor Err.:0 Source :Microsoft SQL Server OLE DB Provider My CE database file Bdd.sdf exist on pocket pc, and I access to the sqlcesa35.dll with IE. The server is a Windows Server 2003 SP2 using SQL Server 2005.   Thank you in advance

FieldTemplate_Edit to show value when custom meta data is set editable equals false

Have a custom FieldTemplate (RadioButtonChooser_Edit.ascx) that shows a radiobuttonlist based on a single character.  Using LinqtoSQL/DynamicData enabled.Example G, F, P  (Good, Fair, Poor).If the custom metadata for a field in the table is set  [Editable(false)]  I get a G, F, or P.  I would like to show the full word when editable is set to false.  Not sure how to approach this.

Problems querying XML data with null values

If the tags have "xsi:nil" in them, then my query failes with a "XML parsing: line [x], character [x], undeclared prefix" error.  So my question is how to get the query to handle or ignore those tags with "xsi:nil" embedded in them.  So specifically, the first SQL query below is successful, and the second one fails with the aforementioned error.  Any comments appreciated, thanks. -- Declare XML variable DECLARE @data XML; -- Element-centered XML SET @data = N'<data> <customer> <id>1</id> <name>Allied Industries</name> </customer> <customer> <id>2</id> <name>Trades International</name> </customer> </data>'; -- Using the query() method SELECT T.customer.query('id').value('.', 'INT') AS customer_id, T.customer.query('name').value('.', 'VARCHAR(20)') AS customer_name FROM @data.nodes('data/customer') AS T(customer); Returns: 1 Allied Industries 2 Trades International ================== -- Declare XML variable DECLARE @data XML; -- Element-centered XML SET @data = N'<data> <customer> <id>1</id> <name>Allied Industries</name> <fax xsi:nil="true" /> </customer> <customer> <id>2</id> <name>Trades International</name> <fax xsi:nil=&quo

Problems with single quote character when attempting to export data from SQL Server

Hi, I am attempting to use the following query, which works fine when run in sql server management studio, to export data: SELECT             '1',             isnull(left(DISTRICT,1),' '),             isnull(left(CTV,2),'  '),             isnull(left(CTV2,5),'     ')           FROM [CensusData].[dbo].[MainQuestionnaire$] The export command follows: EXEC xp_cmdshell 'bcp "SELECT             '1',             isnull(left(DISTRICT,1),' '),             isnull(left(CTV,2),'  '),             isnull(left(CTV2,5),'     ')             FROM [CensusData].[dbo].[MainQuestionnaire$]" queryout "C:\bcptest.txt" -T -c -t -S "MYSERVER"' The error is: Incorrect syntax near '1'. I believe that the problem is with the single quote characters but don't know how to fix it. I am using SQL Server 2005 Express edition. Please help.

Godaddy.com and MySql.Data.dll problems.

I posted this on the 'Hosting Open Forums', but didn't get any answer so I'll try again here...   I have a .NET 2.0 application that is hosted on Godaddy.com.  When you setup your MySQL database, Godaddy supplies you with several connection strings, depending on the connector you wish to use (ODBC, OLEDB, and MySQL Connector .NET). Since they provide a connection string for Connector .NET, I assume this means I could use this connector to access MySQL, and from what I read, doing so would be preferable to using ODBC or OLEDB. I setup my page and plopped the MySql.Data.dll into my bin directory as suggested.  Since Godaddy sets the trust level to medium on shared hosts, I got the following error (I've seen many people bring up this problem due to running under a medium trust level in .NET 2.0):  System.Security.SecurityException: That assembly does not allow partially trusted callers. So, I did some research and it was suggested that if you add [assembly:AllowPartiallyTrustedCallers] to AssemblyInfo.cs in the MySql Connector .NET source, recompile, then use the new .dll, the trust issue will be resolved. I did this and placed the new .dll in my /bin folder and although the original error went away, I now get the following error:  MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---> System.Security.Se

Excel File as input paramter for Lookup Data Flow Transformation problems


Before I start, I'm using SQL 2008.

I have a Excel file with email addresses that need to acts at input parameters to a Lookup transformation. I have set the Excel Source to my file and specified the email field to be the output. I have dropped the Lookup Transformation Data Flow and connected the both. I'm going to execute a very simple stored procedure, and under the Connections section my SQL query looks like follows: EXEC Test_GetUserName ? 
When I run that I get an error saying that no parameter was provided. But when I run EXEC Test_GetUserName 'someemail@companyname.com' everything executes great, for the obvious part that the email is hard coded. How do I pass the excel input as the parameter?

Thanks for all the help.

There is 10 types of people in the world, those that understand binary, and those that don't.

WPF: Recreating a paper form as an online application for data input/retrieval: 2 problems


As with many paper forms,

(1) I have a form with some one-character-per-box data entry fields.

How could I implement the same thing using WPF?

(2) I also have some multi-line data entry fields--some of which begin in the middle of a row, but continue at the beginning of the next row.

Any ideas as to how to set my application up so that these rows can be merged into one field?

Accessing data from GridView Column which is set to Visible="false"


I have four columns in gridview.   EmpId,EmpName,EmpSal,EmpDept.

I want to display the complete information on another page,for this am sending empId to other page through RowCommand.

Now I dont want to display my EmpId Column in GridView but I want to access it .. How to do this...

Thanx and regards....

Problems with returning the data table


public DataTable ExcelToDatatable_dt1
                foreach (GridViewRow rowItem in GridView1.Rows)

Want to set replicate schema changes on a merge publication to false - any problems


Is it safe to change the replicate schema property of a publication mid-stream? We have a server that rarely gets schema changes to the published table, but once a year or so the vendor might change the underlying table(s) in the publication. This is usually a field size change and/or adding a new field.

I don't want to take any chances on disrupting the current merge publication since hundreds of users are already syncing their subscriptions daily. And the sqlce database file is very large (1gb) so it's not practical to have them all reinitialize their subscriptions.

The application using the replica databases will not need the majority of these changes, but at least one of the fields that is being altered in size is already part of the publication. Am I right in assuming that this will 'break' the subscriptions anyway?

Merge Replication Atomicity - at what point does ALL subscriber data become visible at the publisher



I have a Merge Replication installation going on with about 35 connected devices. When one of the subscribers synchronizes, do the inserted rows appear sporadically on the publication database at different times? Or do they appear all at once?

Can all of these be isolated inside a transaction - this would seem like it should be the default behaviour, in case of a sync being cancelled or failing due to loss of connectivity etc. 

The reason for this question is that another part of the system seems to have queried the publication database during and after a subscriber synchronization with differing results. 

If this is normal, what would be the best solution to ensure data integrity? 

Thank you in advance. 


Problems loading data after table creation



I'm new to SSIS so maybe there is a very simple solution for my problem.  I have a table named MyTable.  Before loading data into it, I first check if the table exists.  If not, then the table is created.  After the task is executed and the table is created, I find that the rest of the ETL does no execute, but returns an error saying that the table does no exist.

I think that the ETL is executing too fast to realize that the table has been recently created or maybe i am missing a step between the table creation and the data load.

Any help to solve this will be really appreciated.  

Best regards,  Carlos

collect data from user - email problems


I have a WF with a Collect Data from user action. It works perfectly - creates a task and sends the email.

I moved the site collection by stsadm -o restore to a different server. The Collect Data from user action fails to send the emails now - the task gets created successfully but no email gets sent.

I have added a Send email message action just before the Collect Data from user action and it just sends an email to an email address and this works fine. It just fails to send the email from the Collect Data from user action.

  • the email outgoing settings are correct and work.
  • The task list is set to send emails when an owner is assigned.
  • I am triggering the WF's using an admin account, so I have Full control permission
Is there anything else it could be?

We must always get the latest data from Subscriber, is there any way to do it?



We are trying to implement Replication on a SQL database that is connected to by one of our c# applications.

The application uses both a SQL database and another tool (Source Depot) to store some data.

Because of this, the information on the database and the depot need to be kept in sync, or the application breaks.

Typical changes to the db are the addition of a line to a table, and at the same time the client application will add a new version to a file to source control.

We are using transactional replication and writing to the publisher only, while using the subscribers for improving performance over the WAN.

Our latency for the replication of a transaction right now is about 3 seconds, but it will be worse if we were to roll this system out to other locations (we are only testing its feasibility now).

Because of the need to keep the SQL and SD in sync, we are getting errors when connecting to the db after a write operation was done on the publisher (so, a line was added to a table), because Source Depot will report the latest information, but the SQL will take 3 seconds to replicate the new line.

Is there any way that we can fix this? Ideally the subscriber wouldn't report obsolete information, but wait until the new data had been replicated... does the Subscriber have any knowledge of

Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend