Groups | Blog | Home
all groups > sql server replication > september 2006 >

sql server replication : Assert failed


LPR-3rd
9/27/2006 10:19:08 AM
Running SQL 2K & Win 2K

I receive the following error message when the snapshot agent runs on
my merge publications.

Assert failed: @indid is null in sp_MStablekeys (pk/uq) (Source:
MSSQLServer, Error number: 12241)

Anyone have any idea about this one??

Larry....
Hilary Cotter
9/27/2006 1:51:34 PM
This looks like a bug. Script out the tables and run the script in a
different database. Then script out the publication script and make
adjustments for the new database, and try to run it again. If it works this
time, its a problem with the publication/subscription database. If not it is
likely a bug.

Reapply the latest service pack and try again. If you get the error again,
contact Microsoft.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

AddThis Social Bookmark Button