all groups > sql server replication > february 2004 >
You're in the

sql server replication

group:

Replication Quesion



Replication Quesion sharad
2/20/2004 8:06:13 AM
sql server replication: Dear Friends

I have front end application of VB which use the SQL
database as the backend. To have the full disaster
recovery i want to put the SQL server in the replication
but as the rowguide is having not null property will it
create any problem to my program while inserting the
records.

Your earlier reply will be helpful.

Best regards
RE: Replication Quesion Paul Ibison
2/20/2004 8:46:07 AM
Sharad
depending on the replication you use, RowGUIDs are maintained by defaults and triggers. The guid column is added at the end of the table schema so shouldn't affect any inserts, updates, deletes. If you are using the parameters collection to call an insert sp in ado there will never be any issue, but if you are passing insert parameters by position to a dynamic sql statement (client or server) then you'll have to be careful if you add additional columns to your replicated article as they'll be added after the rowGUID column
Regards
AddThis Social Bookmark Button