HI
I am trying to design merge replication.
step1:configure sqlservr1 as publisher and distributor and published pubs
database.
step2:from sqlserver2 i tried to pull the data using pull
subscription.everything works fine.
step3:again i decided to disabled publishing then start disabling step by
step finally i disabled sqlserver1 as publisher and distributor.
step4:i went to pubs database and start entering data in column mode some
tables allowing data but some tables raising errors saying that errors#
(transaction cannot start in firhosemode).
errors#(data entered is inconsistent value check datatype)
Can anyone help should be appreciated.
Message posted via http://www.droptable.com
Are you updating the tables using Enterprise Manager? Check
http://support.microsoft.com/default...;en-us;237398.
Adrian
"pardhi via droptable.com" <forum@.nospam.droptable.com> wrote in message
news:b7beba92b262474fb634526f72c156c4@.droptable.co m...
> HI
> I am trying to design merge replication.
> step1:configure sqlservr1 as publisher and distributor and published pubs
> database.
> step2:from sqlserver2 i tried to pull the data using pull
> subscription.everything works fine.
> step3:again i decided to disabled publishing then start disabling step by
> step finally i disabled sqlserver1 as publisher and distributor.
> step4:i went to pubs database and start entering data in column mode some
> tables allowing data but some tables raising errors saying that errors#
> (transaction cannot start in firhosemode).
> errors#(data entered is inconsistent value check datatype)
> Can anyone help should be appreciated.
> --
> Message posted via http://www.droptable.com
2012年2月19日星期日
firehosemode
标签:
database,
design,
distributor,
firehosemode,
hii,
merge,
microsoft,
mysql,
oracle,
published,
publisher,
pubsdatabase,
replication,
server,
sql,
sqlserver2,
sqlservr1,
step1configure,
step2from
订阅:
博文评论 (Atom)
没有评论:
发表评论