 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / June 2006Field msrepl_tran_version added
Hello there I've create transacional replication from two databases. At the publisher new field added to all the tables i mark as replicated: msrepl_tran_version It cause damage to my database. What i need to do to ged rid of them? and what i need to do so they won't be created again?  Signatureøåòé âåìãäîø òúéã äðãñú úåëðä èì' 03-5611606 ôìà' 050-7709399 àéîééì: roy@atidsm.co.il You have to run a script to drop them. These columns are using by immediate updating or queued updating publications. Have you need of these publications? SignatureHilary Cotter 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 > Hello there > [quoted text clipped - 4 lines] > It cause damage to my database. What i need to do to ged rid of them? and > what i need to do so they won't be created again? Whell Hilary: When i tried to delete the field by this code? ALTER TABLE Client DROP COLUMN msrepl_tran_version I got an error: Server: Msg 5074, Level 16, State 1, Line 1 The object 'DF__Client__msrepl_t__02FED618' is dependent on column 'msrepl_tran_version'. Server: Msg 4922, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN msrepl_tran_version failed because one or more objects access this column. how can i delete these records? > You have to run a script to drop them. These columns are using by > immediate updating or queued updating publications. Have you need of these [quoted text clipped - 8 lines] >> It cause damage to my database. What i need to do to ged rid of them? and >> what i need to do so they won't be created again? You will have to drop the constraints before dropping the column. SignatureHilary Cotter 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 > Whell Hilary: > [quoted text clipped - 25 lines] >>> It cause damage to my database. What i need to do to ged rid of them? >>> and what i need to do so they won't be created again? I'm sorry with my language. it's one constraint per msrepl_tran_version column, not constraints... Sorry. There are default contraints on that field. You'll have to drop those constraints bfore dropping the column itself. you should do a select on sysobjects to find the default constraints like '%df_%_msrepl%'. i would assume, replication is not in place(immediate updating or queued updating). Once you drop the constraint, it lets u drop the column. HTH Tejas > Whell Hilary: > [quoted text clipped - 25 lines] > >> It cause damage to my database. What i need to do to ged rid of them? and > >> what i need to do so they won't be created again? Whell Tejas: It gives me new error: ALTER TABLE DROP COLUMN failed because 'msrepl_tran_version' is currently replicated. Now what i need to get rid of that, or what i need to cause it not be created again? > There are default contraints on that field. You'll have to drop those > constraints bfore dropping the column itself. you should do a select on [quoted text clipped - 39 lines] >> >> and >> >> what i need to do so they won't be created again? You will have to drop your subscription before trying to make these changes. Is this on the publisher or subscriber? SignatureHilary Cotter 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 > Whell Tejas: > [quoted text clipped - 47 lines] >>> >> and >>> >> what i need to do so they won't be created again? Whell Hilary: It is on the Publisher And it also addes me new tables Conflict.... I've chosed to use Transactional replication, and it act like merge replication. This is realy bad. What i need to do to use replication without changing the database Publisher? > You will have to drop your subscription before trying to make these changes. > Is this on the publisher or subscriber? [quoted text clipped - 73 lines] > >>> >> ???' 050-7709399 > >>> >> ??????: roy@atidsm.co.il If anyone has this pain again please remove replication as much as yo can and then delete all the mofo msrepl_tran_version rows fro syscolumns -- dl33t |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.