Jeff

You are indeed missing a trick.  The tables MyTable, ThisTable and AnotherTable have to exist in your database.  If they don't, substitute them for some tables (and columns) that do. ...

OK, so the problem is occurring in transferring data from the distribution database to the subscription database (Northwind) on 192.168.195.10.  I would guess that there's a problem with the sp_MSins_Region...

Claudia

Is it the LogReader Agent or the Distribution Agent that gives you the error?

John

Happy to help.

John

I don't think this can work with your current database design.  It seems to me that where you have gone wrong is to create your FK constraints the wrong way...

Please will you post the SQL for creating the constraint FK_PaymentTypes_CashPayment.

Thanks

John

Not if you use bigint, which is 8 bytes.  Then you can have more than 18 billion billion records in your table.

John

Fernando

Try doing your restore with T-SQL.  Something like this:

RESTORE DATABASE MyDB FROM DISK='\etc\etc\etc.bak'

John

I understand the restrictions on cascading updates and deletes... I think this is what I tried to explain to Darren.  Self-referencing tables aren't to do with this problem, just an...

I thought we were talking about foreign keys?  At least that is what Darren's original question refers to.  I'm afraid I don't understand how you can have a foreign key...

Gift

Am I understanding you correctly?  Are you saying that, to create a foreign key, the name of referencing and referenced columns must be identical?  Is this new to SQL 2005,...

Darren

I'm afraid I'm not familiar with the SET TO NULL option.  But you can't have cascading deletes for the reason I mentioned above.  And you may find that you still...

So I'm guessing you're getting the error message when you try to create the second foreign key constraint?  I'm also guessing that you are using the following code to attempt to...

No, I don't think so.  I think you've got some sort of circular reference going on.  But without being able to see what the FKs do, I can't help you. ...

Darren

Do you have Query Analyzer?  You can use the Object Browser to expand the database, then expand each table.  Find the Constraints you are looking for, then right-click and this...