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

Top 5 Contributors of the Month
Post New Web Links

ROWGUID in Merger Replication - Newbie questions

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

I am a newbie in MS SQL Replication. This is long story for your BlackBerry. I hope you can read and understand my story below.



Publisher: Windows XP & MS SQL 2008 Standard, Customer maintenances EXE Application.

Subscribe: Window XP & MS SQL 2008 Express, Customer maintenances EXE Application.

  I only have Customer maintenances EXE file and I have no application source code.

  Both publisher and subscribe CUSTOMER table will be update by different people and different location.


Problem: for example

In publisher, Table Customer have 3 clients Mr. A, Mr. B, Mr. C.

In subscribe, Table Customer have 2 clients Mr. A, Mr. D


As you know a ROWGUID will add to the tables in merger replication. After the first synchronization, then I execute the EXE application to reads the Customer table, doing some add or delete customer to tables, then the program hang.


View Complete Post

More Related Resource Links

Merge replication performace questions


I believe I’m having performance issues with my merge replication setup.  The reason I believe I’m having trouble is because the progress bar shown in the details window of the subscription, shown in replication monitor, doesn’t get up to 100% for download/upload completion, in fact it usually slowly goes down while the approximate time remaining goes up.  When I look at the Synchronization Status on the subscriber, the blue bar underneath the “Last Status Message” doesn’t go the whole way across.

When I validate the subscription, validation fails for a number of tables but that is what I expect to happen because in order to validate, I need to stop the subscription from continuously updating so I can restart the synchronization in order to get the validation results.

Here is my setup: Server A has 2 quad core Intel (X5460) 3.16GHz CPUs, 32 GB of RAM and a Gigabit Ethernet card.  Server B has 2 quad core Intel (E5530) 2.40GHz CPUs, 24 GB of RAM and a Gigabit Ethernet card with a Gigabit switch between the two servers.

The merge agent profile is using the “High Volume Server-to-Server Profile”.

I am trying to get one publication from server A to server B using a pull subscription which is polling every second.    

General replication questions - SQL Server 2008 R2


First, can SQL Server 2008 R2 replicate to SQL Server 2008 R2 Express Edition???

Second, I have setup replication from R2 to a SQL Server 2000 database.  I defined a stand-alone table (not a parent or child) and replication worked fine.  I simply changed a record and it was reflected in the 2000 database.

Next, I changed the table to be replicated to be a parent table.  After I changed a record in this table, replication failed.  The error message said it was unable to drop a table because it was in a relationship.

Questions.  When replication occurs between a publisher and subscriber and several records in a table targeted for replication, is the table dropped in the subscriber database then copied over in its entirety???  When I define a table to be replicated, do I have to include all the related tables???



Newbie Questions


I've highly interested in WF 4.0 but am having a bit of a problem learning it.  Have a few questions that I hope you'd be able to help me with...

Replication Monitoring Questions

We have a pretty extensive replication topology at our organization. The
publications are 99% transactional with a couple of snapshots thrown in for
articles that do not change very often. these are used for some mission
critical BI processes, so making sure they are in sync is one of my top

I am finding it pretty much impossible to ensure that everything is up to
date without manually opening each publication/ subscription in replication
monitor and verifying that the flow of transactions is behaving properly.
This process takes literally hours for me to complete. I had created a job to
run sp_publication_validation against all of the publications coupled with
alerts to email me when validation failed, and this seemed to be working fine
until this morning. During my morning checklist routine, I found two
publication marked as "Critical Performance," with each having 57 seconds of
latency. When I opened the Distributor to Subscriber History tab, I found
both had a status of "Initial snapshot is not available," and apparently had
not been updating properly for roughly a week. My job did not pick these off
as failing validation. I manually ran a subscription validation against both,
and no results were ever returned.

My question to

Newbie Questions


I've highly interested in WF 4.0 but am having a bit of a problem learning it.  Have a few questions that I hope you'd be able to help me with...

Can WF be used to create a project/solution from scracth?
Does one usually stub out classes first and then add activites?
How does one create an object as input for an activty?
When you create activities it will generate method stubs if none exist right?

second rowguid after new replication wizard



I would like to create new table with fields COL0 (uniqueidentifier - primary key), COL1, COL2... and merge publication with this table.

But 'new publication' wizard creates another one field 'rowguid' (uniqueidentifier). (It's interesting that during wizard steps I don't get message - column 'rowguid' will be added to your table as usual)

Is it possible to create publication table with only one uniqueidentifier column?

thanks in advance!

Newbie question: Are there any code changes required in an app when introducing SQL Replication?



We are investigating introducing SQL Replication (transactional model) to mitigate the usage of our main database from a remote site (so, we would have a replication at the remote site).

What we want is for users to write only to the Publisher, and read from the local Subscribers.

I have just assumed so far that SQL Replication will be completely transparent and handle the replication internally, so that we won't need to change anything in our client applications connecting to the DB, but I can't actually find any documentation that confirms this (it just seems to be the most obvious way for this to work).

Can you please point me to some documentation that clarifies this, or just confirm the actual behaviour here?

Thank you!


some questions about 2005 merge replication



We have 2 servers with 2005 merge replication setup and we have some questions about it:

1.) The database grew up about 55GB data(since most of them are binary image data) and log alternatively and we want to change from Full recovery mode to Simple recovery mode to reduce log size. Do we need to drop and create replication again or simply change the recovery mode is enough? Any other procedures we need to follow?

2.) The snapshot(run once about 2 weeks) job run about 3 to 4 hours. As this job drew all the resources while it's riunning and severely affect other transactions, we want to reduce it's running time. How about rebuild the index for replication system tables(e.g. msmerge_content) and how much gain by this action? Any other suggestions?

Thanks and regards,


Brand new newbie with some set up questions.


Hi All,

Please bear with with me as I'm coming into this pretty much blind. We are setting up to implement SharePoint 2010 in our organization. The setup we are going with is as follows:

Database server running Server 2008, SQL 2008

App server running Server 2008

Front end web server running Server 2008

Now for a few questions:

1. The central administration site is running on the database server. Is this OK or should it be on the app server or does it matter?

2. Since my workstation is only a 32 bit machine, I currently have Visual Studio 2010 on the app server. OK to leave it there or should I upgrade to a 64 bit system on my workstation to remove VS from the server farm?

3. Any recommendations for good online tutorials for site development?



Mark B

C# Interview Questions

C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.

There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access

Frequently Asked Questions - SQL Server Data Types

This is good and precise introduction and Frequently Asked Questions - SQL Server Data Types

connection string question from a newbie


when publishing  in the webmatrix dialogue it asks for "destination connection string" for my "database.mdf"

I was not sure what it was so I pasted this from my web.config file :

Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\database.mdf;Integrated Security=True;User Instance=True

it all published ok, but wont run, so I guess it has somthing to do with this connection string or some kind of configuration issue.

My question is this, What should go in the field for "Destination connection string"

Linq qry with order by basic questions


I have never tried a group by with linq, now I do and I'm stuck.

I try to convert this sql statement to its linq counterpart :

SELECT COUNT(tb_Mailer_Smses.Id) AS [cnt], tb_Mailer_mailing.Id As [Id]
,SUM( CASE WHEN tb_Mailer_smses.DLRStatus = 200 THEN 1 ELSE 0 END) As [Delivered]
FROM tb_Mailer_mailing INNER JOIN
tb_Mailer_Smses ON tb_Mailer_mailing.Id = tb_Mailer_Smses.MailingId
WHERE tb_Mailer_mailing.ApplicationId = 1
GROUP BY tb_Mailer_mailing.Id

Is there some one who can me show me the convertion process ?

Questions about getter and setter


I created a getter and Setter in Visual Basic. I have some questions though. Please look at the code below.
Here are my questions.

A.) At line 1 below, should "pieces" be declared as Private?
B.) In the IDE at lines 4 and 7 the IDE keeps changing those variables to uppercase so that the property name "Pieces" is the
    same as the variable name "pieces".Should I instead define the integer pieces with an underscore: _pieces ?
That is the only way I can get around the IDE forcing the variable to become uppercase.


1  Dim pieces As Integer

2  Public Property Pieces() As String
3  Get

4  Return pieces
5  End Get

6 Set (ByVal values As String)
7   pieces=value
8 End Set
9 End Property

Can WF be used to create a project/solution from scracth?
Does one usually stub out classes first and then add activites?
How does one create an object as input for an activty?
When you create activities it will generate method stubs if none exist right?
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