unfortunately, the same error
does anyone have a definitive description about this:
'Enforce relationship for replication'
I've found BOL horrible...
I thought so too,
I've re-created the publication and I'll see if it keeps going on.
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_moviecats_cats'.
With trans repl and DRI enabled, I get the above error once and...
Mohammed, worked like a charm, thank you
Login failed for user 'NT AUTHORITYSYSTEM'.
( Everything is running as .Administrator )
I have created a full text index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
So there is nothing I could have done to prevent orphan users when I moved the databases?
I thought that was the point of using the "transfer...
I've used the sp_'s from this article:
HOW TO: Transfer Logins and Passwords Between Instances of SQL Server...
One of my users created a table named 'dtproperties' of type system and now I can't delete it, when I try as 'dbo' it says: 'you tried to delete one...
1 Way trans. replication to a mysql database
SQL Server Env: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Windows NT 5.0 (Build 2195: Service...
Separate names with a comma.