| Groups | Blog | Home |
sql server replication : Field msrepl_tran_version added
updating or queued updating publications. Have you need of these publications? -- Hilary 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 [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... > 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? > > -- > øåòé âåìãäîø > òúéã äðãñú úåëðä > èì' 03-5611606 > ôìà' 050-7709399 > àéîééì: roy@atidsm.co.il >
You will have to drop the constraints before dropping the column.
-- Hilary 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 [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:%23ePeTNMAGHA.3864@TK2MSFTNGP12.phx.gbl... > 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? > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... >> 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? >> >> -- >> Hilary 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 >> >> "Roy Goldhammer" <roy@hotmail.com> wrote in message >> news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... >>> 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? >>> >>> -- >>> øåòé âåìãäîø >>> òúéã äðãñú úåëðä >>> èì' 03-5611606 >>> ôìà' 050-7709399 >>> àéîééì: roy@atidsm.co.il >>> >> >> > >
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 [quoted text, click to view] "Roy Goldhammer" wrote:
> 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? > > "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... > > 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? > > > > -- > > Hilary 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 > > > > "Roy Goldhammer" <roy@hotmail.com> wrote in message > > news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... > >> 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? > >> > >> -- > >> øåòé âåìãäîø > >> òúéã äðãñú úåëðä > >> èì' 03-5611606 > >> ôìà ' 050-7709399 > >> à éîééì: roy@atidsm.co.il > >> > > > > > >
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? -- øåòé âåìãäîø òúéã äðãñú úåëðä èì' 03-5611606 ôìà' 050-7709399 àéîééì: roy@atidsm.co.il
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? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... > 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? > > -- > Hilary 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 > > "Roy Goldhammer" <roy@hotmail.com> wrote in message > news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... >> 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? >> >> -- >> øåòé âåìãäîø >> òúéã äðãñú úåëðä >> èì' 03-5611606 >> ôìà' 050-7709399 >> àéîééì: roy@atidsm.co.il >> > >
You will have to drop your subscription before trying to make these changes.
Is this on the publisher or subscriber? -- Hilary 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 [quoted text, click to view] "Roy Goldhammer" <roy@hotmail.com> wrote in message news:essSUXVAGHA.2036@TK2MSFTNGP14.phx.gbl... > 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? > > "Tejas Parikh" <TejasParikh@discussions.microsoft.com> wrote in message > news:32CD928E-5D0B-45EF-8A07-85C65A30BA65@microsoft.com... >> 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 >> >> "Roy Goldhammer" wrote: >> >>> 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? >>> >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >>> news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... >>> > 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? >>> > >>> > -- >>> > Hilary 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 >>> > >>> > "Roy Goldhammer" <roy@hotmail.com> wrote in message >>> > news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... >>> >> 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? >>> >> >>> >> -- >>> >> ???? ??????? >>> >> ???? ????? ????? >>> >> ??' 03-5611606 >>> >> ???' 050-7709399 >>> >> ??????: roy@atidsm.co.il >>> >> >>> > >>> > >>> >>> >>> > >
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? [quoted text, click to view] "Tejas Parikh" <TejasParikh@discussions.microsoft.com> wrote in message news:32CD928E-5D0B-45EF-8A07-85C65A30BA65@microsoft.com... > 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 > > "Roy Goldhammer" wrote: > >> 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? >> >> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message >> news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... >> > 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? >> > >> > -- >> > Hilary 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 >> > >> > "Roy Goldhammer" <roy@hotmail.com> wrote in message >> > news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... >> >> 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? >> >> >> >> -- >> >> ???? ??????? >> >> ???? ????? ????? >> >> ??' 03-5611606 >> >> ???' 050-7709399 >> >> ??????: roy@atidsm.co.il >> >> >> > >> > >> >> >>
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? [quoted text, click to view] "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message news:#K1WEuYAGHA.3140@TK2MSFTNGP14.phx.gbl... > You will have to drop your subscription before trying to make these changes. > Is this on the publisher or subscriber? > > -- > Hilary 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 > > "Roy Goldhammer" <roy@hotmail.com> wrote in message > news:essSUXVAGHA.2036@TK2MSFTNGP14.phx.gbl... > > 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? > > > > "Tejas Parikh" <TejasParikh@discussions.microsoft.com> wrote in message > > news:32CD928E-5D0B-45EF-8A07-85C65A30BA65@microsoft.com... > >> 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 > >> > >> "Roy Goldhammer" wrote: > >> > >>> 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? > >>> > >>> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message > >>> news:%23y6ZYGMAGHA.2656@tk2msftngp13.phx.gbl... > >>> > 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? > >>> > > >>> > -- > >>> > Hilary 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 > >>> > > >>> > "Roy Goldhammer" <roy@hotmail.com> wrote in message > >>> > news:%23EzlsbLAGHA.3296@TK2MSFTNGP12.phx.gbl... > >>> >> 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? > >>> >> > >>> >> -- > >>> >> ???? ??????? > >>> >> ???? ????? ????? > >>> >> ??' 03-5611606 > >>> >> ???' 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 ----------------------------------------------------------------------- dl33ta's Profile: http://www.dbtalk.net/m48 View this thread: http://www.dbtalk.net/t22702
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |