There is a table named users in my database.
It has two colume:
userName varchar(20)
age int
now I execute the follow transaction:
begin tran
insert users (userName,age) values ('mark',25)
insert users (userName,age) values ('jack',2577777777777767777)
commit tran
obviously,the second setence has an overflow error,
the question is:has the first record been inserted into the users table?
why?
"κ" <weisl@.netstars.com.cn> wrote in message
news:%23T$6pCrPGHA.140@.TK2MSFTNGP12.phx.gbl...
> There is a table named users in my database.
> It has two colume:
> userName varchar(20)
> age int
> now I execute the follow transaction:
> begin tran
> insert users (userName,age) values ('mark',25)
> insert users (userName,age) values ('jack',2577777777777767777)
> commit tran
> obviously,the second setence has an overflow error,
> the question is:has the first record been inserted into the users table?
> why?
>
Because you told it to. You need error checking (or try/catch in SQL 2005)
to prevent execution from moving from the line that generates the error to
the line that commits the transaction.
David
Showing posts with label transaction. Show all posts
Showing posts with label transaction. Show all posts
Tuesday, March 6, 2012
about Transaction's problem
There is a table named users in my database.
It has two colume:
userName varchar(20)
age int
now I execute the follow transaction:
begin tran
insert users (userName,age) values ('mark',25)
insert users (userName,age) values ('jack',2577777777777767777)
commit tran
obviously,the second setence has an overflow error,
the question is:has the first record been inserted into the users table?
why?"κÊöÀÚ" <weisl@.netstars.com.cn> wrote in message
news:%23T$6pCrPGHA.140@.TK2MSFTNGP12.phx.gbl...
> There is a table named users in my database.
> It has two colume:
> userName varchar(20)
> age int
> now I execute the follow transaction:
> begin tran
> insert users (userName,age) values ('mark',25)
> insert users (userName,age) values ('jack',2577777777777767777)
> commit tran
> obviously,the second setence has an overflow error,
> the question is:has the first record been inserted into the users table?
> why?
>
Because you told it to. You need error checking (or try/catch in SQL 2005)
to prevent execution from moving from the line that generates the error to
the line that commits the transaction.
David
It has two colume:
userName varchar(20)
age int
now I execute the follow transaction:
begin tran
insert users (userName,age) values ('mark',25)
insert users (userName,age) values ('jack',2577777777777767777)
commit tran
obviously,the second setence has an overflow error,
the question is:has the first record been inserted into the users table?
why?"κÊöÀÚ" <weisl@.netstars.com.cn> wrote in message
news:%23T$6pCrPGHA.140@.TK2MSFTNGP12.phx.gbl...
> There is a table named users in my database.
> It has two colume:
> userName varchar(20)
> age int
> now I execute the follow transaction:
> begin tran
> insert users (userName,age) values ('mark',25)
> insert users (userName,age) values ('jack',2577777777777767777)
> commit tran
> obviously,the second setence has an overflow error,
> the question is:has the first record been inserted into the users table?
> why?
>
Because you told it to. You need error checking (or try/catch in SQL 2005)
to prevent execution from moving from the line that generates the error to
the line that commits the transaction.
David
about Transaction's problem
There is a table named users in my database.
It has two colume:
userName varchar(20)
age int
now I execute the follow transaction:
begin tran
insert users (userName,age) values ('mark',25)
insert users (userName,age) values ('jack',2577777777777767777)
commit tran
obviously,the second setence has an overflow error,
the question is:has the first record been inserted into the users table?
why?"κ" <weisl@.netstars.com.cn> wrote in message
news:%23T$6pCrPGHA.140@.TK2MSFTNGP12.phx.gbl...
> There is a table named users in my database.
> It has two colume:
> userName varchar(20)
> age int
> now I execute the follow transaction:
> begin tran
> insert users (userName,age) values ('mark',25)
> insert users (userName,age) values ('jack',2577777777777767777)
> commit tran
> obviously,the second setence has an overflow error,
> the question is:has the first record been inserted into the users table?
> why?
>
Because you told it to. You need error checking (or try/catch in SQL 2005)
to prevent execution from moving from the line that generates the error to
the line that commits the transaction.
David
It has two colume:
userName varchar(20)
age int
now I execute the follow transaction:
begin tran
insert users (userName,age) values ('mark',25)
insert users (userName,age) values ('jack',2577777777777767777)
commit tran
obviously,the second setence has an overflow error,
the question is:has the first record been inserted into the users table?
why?"κ" <weisl@.netstars.com.cn> wrote in message
news:%23T$6pCrPGHA.140@.TK2MSFTNGP12.phx.gbl...
> There is a table named users in my database.
> It has two colume:
> userName varchar(20)
> age int
> now I execute the follow transaction:
> begin tran
> insert users (userName,age) values ('mark',25)
> insert users (userName,age) values ('jack',2577777777777767777)
> commit tran
> obviously,the second setence has an overflow error,
> the question is:has the first record been inserted into the users table?
> why?
>
Because you told it to. You need error checking (or try/catch in SQL 2005)
to prevent execution from moving from the line that generates the error to
the line that commits the transaction.
David
about transaction?
How can i say how many and what transactions on the current db?
Also the time-stamp for each of transaction?
many thanks
Also the time-stamp for each of transaction?
many thanks
See "dbcc opentran" in BOL.
Example:
dbcc opentran (0) with tableresults
AMB
|||In SS2005, you can also use a DMV
Code Snippet
SELECT sys.dm_tran_active_transactions
about transaction replication...
Hi everybody,
I am new to SQL replication , I use MS SQL 2000 with
SP3 . I use databases of a financial program which has 360 tables. But I
receive that error when replicating data :
Could not drop object 'dbo.TBLSUBELER' because it is referenced by a FOREIGN
KEY constraint.
(Source: UGUR (Data source); Error number: 3726)
Why this error occurs and what can i do ?
Best regards...
This error is caused because sysdepends is out of sync on your publisher.
All RDBMS's have this problem.
The best thing to do is to pre create your schema, save it to a script and
execute it as part of a pre snapshot command.
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
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
FOREIGN
> KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>
|||At what stage during the replication process are you getting this error?
This error is occurring because the specified table is being deleted, but
another table has a foreign key defined on it.
You can get this problem when re-applying the snapshot or running the agent
after the subscription has been reinitialised (which is also re-applying the
snapshot incidentally).
Raj Moloye
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
> FOREIGN KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>
I am new to SQL replication , I use MS SQL 2000 with
SP3 . I use databases of a financial program which has 360 tables. But I
receive that error when replicating data :
Could not drop object 'dbo.TBLSUBELER' because it is referenced by a FOREIGN
KEY constraint.
(Source: UGUR (Data source); Error number: 3726)
Why this error occurs and what can i do ?
Best regards...
This error is caused because sysdepends is out of sync on your publisher.
All RDBMS's have this problem.
The best thing to do is to pre create your schema, save it to a script and
execute it as part of a pre snapshot command.
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
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
FOREIGN
> KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>
|||At what stage during the replication process are you getting this error?
This error is occurring because the specified table is being deleted, but
another table has a foreign key defined on it.
You can get this problem when re-applying the snapshot or running the agent
after the subscription has been reinitialised (which is also re-applying the
snapshot incidentally).
Raj Moloye
"Uur Ekinci" <ugur@.argeset.com> wrote in message
news:uHgOmTbHFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Hi everybody,
> I am new to SQL replication , I use MS SQL 2000 with
> SP3 . I use databases of a financial program which has 360 tables. But I
> receive that error when replicating data :
> Could not drop object 'dbo.TBLSUBELER' because it is referenced by a
> FOREIGN KEY constraint.
> (Source: UGUR (Data source); Error number: 3726)
> Why this error occurs and what can i do ?
> Best regards...
>
about transaction replication initialization
Hi Guys,
In transaction replication, before seting up the replication, do we need to
keep same copy for Publisher and Subscriber. That is mean do we need to
create all objects in Subscriber database which need to replicate from
Publisher in advance or I don't need to create and init snap shot will create
those objects in Subscriber. for example, if I want to replicate a table, do
I neet to create this table in Subscriber ahead? Or init snap shot agent
will do that. Thanks.
By default, there is no requirement to create anything on the subscriber. It
is sometimes beneficial to do a nosync initialization, in which case what
you are saying is pertinent, but this is usually because the snapshot files
are so large and/or the data already exists onthe subscriber so we take
advantage of it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thank you very much. But I have other question is: I have test replication
environment, where it was worked fine. But after I delete one table in
subscriber, it causes error that the table in subscriber is not existed. why
it was not created again automately? Thanks.
"Paul Ibison" wrote:
> By default, there is no requirement to create anything on the subscriber. It
> is sometimes beneficial to do a nosync initialization, in which case what
> you are saying is pertinent, but this is usually because the snapshot files
> are so large and/or the data already exists onthe subscriber so we take
> advantage of it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||It isn't really designed for you to be editing the subscriber's schema in
this way. To reinitialize this table, drop the subscription to the table
then drop the article. Add the article then add the subscription, start the
snapshot agent and it'll be sent over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hello Iter,
Schemas are not maintained but rather are modified when the schema at the
publisher changes.
It is assumed schema changes will not be modified at the subscriber.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> Thank you very much. But I have other question is: I have test
> replication environment, where it was worked fine. But after I delete
> one table in subscriber, it causes error that the table in subscriber
> is not existed. why it was not created again automately? Thanks.
> "Paul Ibison" wrote:
|||Thank you guys. If I want to modify the schemas in the publisher, e.g. add
new columns, how can I make changes in subscriber to make them identical?
Thanks
"Simon Sabin" wrote:
> Hello Iter,
> Schemas are not maintained but rather are modified when the schema at the
> publisher changes.
> It is assumed schema changes will not be modified at the subscriber.
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>
>
|||It largely depends on what version of SQL Server you are currently using.
There is also a difference between altering a table's existing column and
adding or dropping columns. For the latter on SQL Server 2000 please take a
look at sp_repladdcolumn/sp_repldropcolumn. For SQL Server 2005 or changing
existing columns please take a look at these articles:
http://www.replicationanswers.com/AddColumn.asp
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
In transaction replication, before seting up the replication, do we need to
keep same copy for Publisher and Subscriber. That is mean do we need to
create all objects in Subscriber database which need to replicate from
Publisher in advance or I don't need to create and init snap shot will create
those objects in Subscriber. for example, if I want to replicate a table, do
I neet to create this table in Subscriber ahead? Or init snap shot agent
will do that. Thanks.
By default, there is no requirement to create anything on the subscriber. It
is sometimes beneficial to do a nosync initialization, in which case what
you are saying is pertinent, but this is usually because the snapshot files
are so large and/or the data already exists onthe subscriber so we take
advantage of it.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thank you very much. But I have other question is: I have test replication
environment, where it was worked fine. But after I delete one table in
subscriber, it causes error that the table in subscriber is not existed. why
it was not created again automately? Thanks.
"Paul Ibison" wrote:
> By default, there is no requirement to create anything on the subscriber. It
> is sometimes beneficial to do a nosync initialization, in which case what
> you are saying is pertinent, but this is usually because the snapshot files
> are so large and/or the data already exists onthe subscriber so we take
> advantage of it.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||It isn't really designed for you to be editing the subscriber's schema in
this way. To reinitialize this table, drop the subscription to the table
then drop the article. Add the article then add the subscription, start the
snapshot agent and it'll be sent over.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hello Iter,
Schemas are not maintained but rather are modified when the schema at the
publisher changes.
It is assumed schema changes will not be modified at the subscriber.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> Thank you very much. But I have other question is: I have test
> replication environment, where it was worked fine. But after I delete
> one table in subscriber, it causes error that the table in subscriber
> is not existed. why it was not created again automately? Thanks.
> "Paul Ibison" wrote:
|||Thank you guys. If I want to modify the schemas in the publisher, e.g. add
new columns, how can I make changes in subscriber to make them identical?
Thanks
"Simon Sabin" wrote:
> Hello Iter,
> Schemas are not maintained but rather are modified when the schema at the
> publisher changes.
> It is assumed schema changes will not be modified at the subscriber.
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
>
>
|||It largely depends on what version of SQL Server you are currently using.
There is also a difference between altering a table's existing column and
adding or dropping columns. For the latter on SQL Server 2000 please take a
look at sp_repladdcolumn/sp_repldropcolumn. For SQL Server 2005 or changing
existing columns please take a look at these articles:
http://www.replicationanswers.com/AddColumn.asp
http://www.replicationanswers.com/AlterSchema2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
About trace flag 8588
Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an active
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> while the session is enlisted in a distributed transaction that has an active
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
> For more information about using trace flags and startup parameters, see the
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please update
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
> > Hi Guys,
> > I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> > while the session is enlisted in a distributed transaction that has an active
> > savepoint. I setup two sql server 2000 in two windows 2003 server, both
> > install sql server sp1. I created linked server and setup MCDTC on both
> > server. When I run application that include distributed transaction, I got
> > error above. I re-check MCDTC, permission and so on, but I still got that
> > issue. Could some one help me to fix it? Thanks in advance.
> >
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an active
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> while the session is enlisted in a distributed transaction that has an active
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
> For more information about using trace flags and startup parameters, see the
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please update
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
> > Hi Guys,
> > I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
> > while the session is enlisted in a distributed transaction that has an active
> > savepoint. I setup two sql server 2000 in two windows 2003 server, both
> > install sql server sp1. I created linked server and setup MCDTC on both
> > server. When I run application that include distributed transaction, I got
> > error above. I re-check MCDTC, permission and so on, but I still got that
> > issue. Could some one help me to fix it? Thanks in advance.
> >
About trace flag 8588
Hi Guys,
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>
I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remote
while the session is enlisted in a distributed transaction that has an activ
e
savepoint. I setup two sql server 2000 in two windows 2003 server, both
install sql server sp1. I created linked server and setup MCDTC on both
server. When I run application that include distributed transaction, I got
error above. I re-check MCDTC, permission and so on, but I still got that
issue. Could some one help me to fix it? Thanks in advance.For more information about using trace flags and startup parameters, see the
"DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
Online.
To use trace flag 8599, obtain the latest service pack for SQL Server 2000:
Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Once you update the service pack your problem will get fixed. Please update
the same and lemme know if it works...
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and
time
asking back if its 2000 or 2005]
"Iter" wrote:
> Hi Guys,
> I got an error about trace flag 8588, Error 8526 Level 16: Cannot go remot
e
> while the session is enlisted in a distributed transaction that has an act
ive
> savepoint. I setup two sql server 2000 in two windows 2003 server, both
> install sql server sp1. I created linked server and setup MCDTC on both
> server. When I run application that include distributed transaction, I got
> error above. I re-check MCDTC, permission and so on, but I still got that
> issue. Could some one help me to fix it? Thanks in advance.
>|||Thank you very much. But for my case, the server is windows 2003 and have
already installed service pack 1. Is there something else that I need to
install? Thanks.
"Sreejith G" wrote:
[vbcol=seagreen]
> For more information about using trace flags and startup parameters, see t
he
> "DBCC TRACEON" and "Using Startup Options" topics in SQL Server 2000 Books
> Online.
> To use trace flag 8599, obtain the latest service pack for SQL Server 2000
:
> Q290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
> Once you update the service pack your problem will get fixed. Please updat
e
> the same and lemme know if it works...
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread an
d time
> asking back if its 2000 or 2005]
>
> "Iter" wrote:
>
Sunday, February 19, 2012
About repopulate table
Hi Guys,
I have transaction replication setup in my company, and in subscriber there
are some triggers there but not in publication, which is due to business
logic. Now I want to repopulate table's value from publication to subscrition
completely,but I don't want to rerun the snapshot because it will overrite
the triggers in the subscriber. How can do that? Thanks.
Do a no-sync subscription. I think you will want to change the article
properties so that in the snapshot tab, name conflicts section you select
delete all data in table, disable the trigger on the subscriber, run and
deploy the snapshot and then re-enable the trigger.
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
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:ED7B6F2D-4CF7-477D-983A-1AA3740E5A51@.microsoft.com...
> Hi Guys,
> I have transaction replication setup in my company, and in subscriber
> there
> are some triggers there but not in publication, which is due to business
> logic. Now I want to repopulate table's value from publication to
> subscrition
> completely,but I don't want to rerun the snapshot because it will overrite
> the triggers in the subscriber. How can do that? Thanks.
>
I have transaction replication setup in my company, and in subscriber there
are some triggers there but not in publication, which is due to business
logic. Now I want to repopulate table's value from publication to subscrition
completely,but I don't want to rerun the snapshot because it will overrite
the triggers in the subscriber. How can do that? Thanks.
Do a no-sync subscription. I think you will want to change the article
properties so that in the snapshot tab, name conflicts section you select
delete all data in table, disable the trigger on the subscriber, run and
deploy the snapshot and then re-enable the trigger.
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
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:ED7B6F2D-4CF7-477D-983A-1AA3740E5A51@.microsoft.com...
> Hi Guys,
> I have transaction replication setup in my company, and in subscriber
> there
> are some triggers there but not in publication, which is due to business
> logic. Now I want to repopulate table's value from publication to
> subscrition
> completely,but I don't want to rerun the snapshot because it will overrite
> the triggers in the subscriber. How can do that? Thanks.
>
Subscribe to:
Posts (Atom)