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. -------------------------------- http://onmyword.com
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 http://onmyword.com
Login failed for user 'NT AUTHORITYSYSTEM'. ( Everything is running as .Administrator ) http://onmyword.com
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. But even...
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...
No event messages, but I think I fixed it by changing 'Driver={MySQL ODBC 3.51 Driver}' to 'Driver= {MySQL ODBC 3.51 Driver}' {note the space...
MSSQL 2000 sp3a -- to a remote--> mysql 4.0.20-standard The ports are open and a DSN has been created between the two using the native mysql...
SQL Server Enterprise 2000 SP3a
I have a maint plan that backups up the t-logs (and one for the databases) of all the user databases, while executing, the job runs nice and fast,...
sql2k, sp3a Transactional replication snapshot file created without error, but when the distribution agent runs for about 2 minutes the error is:...
I have a Master/Slave transaction replication setup where the slave is read only. The master server is very old and I need to take it offline, Would...
using EM i tried to add a server that was a remotes server (due to replication) as a linked server and it said it was already defined.
SQL 2000 Servers: DB1 & DB2 DB1 --> replicates a database to DB2 DB1 has DB2 as a remote server (not a linked server) I need to run a query on...
SQL Server 2000 Merge Publication's Push subscriptions are expiring early. (before the 14 days) No messages given, any known reasons ?
Would running MSSQL as LocalSystem be the same as running it as .Administrator ? .Administrator has network access correct ?
Separate names with a comma.
