Hi,
I am getting an error while replicating the sql 2000 database.
The error no is 20598...It stopped replicating the database...
Can any body tell me what is this pls...
Tks in advance...
JoyceIf you provide the answers for the following questions, it will be easier for others to help you.
What kind of replication are you using?
Which service pack has been installed?|||If you provide the answers for the following questions, it will be easier for others to help you.
What kind of replication are you using?
Which service pack has been installed?
I am using Transactional replication|||Hey, I came up with the link at Microsoft support:
http://support.microsoft.com/search/default.aspx?InCC_hdn=True&Catalog=LCID%3D1033%26CDID%3DEN-US-KB%26PRODLISTSRC%3DON&Product=&KeywordType=ALL&Titles=false&numDays=&maxResults=25&Queryl=sql+server+replication+error+%2320598&Query=sql+server+replication+error+%2320598&QuerySource=gsfxSearch_Query&srchExtraQry=
Nothing at lazydba, Looks like it's a service pack issue. I'd check with the network group before continueing.|||Come on!!!!!!!!!!!!!!, We can solve this. Let's do the damn thing.
sp_scriptdynamicupdproc is used in transactional replication. The default MCALL scripting logic includes all columns within the UPDATE statement and uses a bitmap to determine the columns that have changed. If a column did not change, the column is set back to itself, which usually causes no problems. If the column is indexed, extra processing occurs. By contrast, this stored procedure uses a dynamic approach: it includes only the columns that have changed, which provides an optimal UPDATE string. However, extra processing is incurred at run time when the dynamic UPDATE statement is built. It is recommended that you test both the dynamic stored procedure approach and the static default approach, and then choose the optimal solution for your particular needs.
if @.@.rowcount = 0
if @.@.microsoftversion>0x07320000
exec sp_MSreplraiserror 20598|||Come on!!!!!!!!!!!!!!, We can solve this. Let's do the damn thing.
sp_scriptdynamicupdproc is used in transactional replication. The default MCALL scripting logic includes all columns within the UPDATE statement and uses a bitmap to determine the columns that have changed. If a column did not change, the column is set back to itself, which usually causes no problems. If the column is indexed, extra processing occurs. By contrast, this stored procedure uses a dynamic approach: it includes only the columns that have changed, which provides an optimal UPDATE string. However, extra processing is incurred at run time when the dynamic UPDATE statement is built. It is recommended that you test both the dynamic stored procedure approach and the static default approach, and then choose the optimal solution for your particular needs.
if @.@.rowcount = 0
if @.@.microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
Hi,
My replication was working fine without any problem. But suddenly the error came (erro numbar 20598).
My replication is transactional replication..
Any body knows this pls.help...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment