b******d
发帖数: 115 | 1 I have a question about the replication method with SQL7 or
SQL2000 (I'm using SQL2000 actually). I know how to set up
publication for replicating certain tables, but need to
figure out how to capture the content of a publication and
send a message to an MSMQ queue. The default for
transactional replication in SQL server is to replicate the
change to a subscriber's table. My guess is during the
process of getting the content from publisher to subscriber,
there's got to be a place (maybe internal |
|
w**d
发帖数: 1476 | 2 Yes, probably you can not install SQL 2000 on Win2000Pro.
I had never tried that, but I can not install sql7 on winnt4 wkstation.
You don't need advanced server, just server should be ok. |
|
a*****a
发帖数: 438 | 3 JET is for Access/Excel, don't use that one.
have you tried installing service pack for SQL7.0? |
|
f****y
发帖数: 70 | 4 DB is MS SQL7.0, OS is Win2000 Server. The
problem is that Chinese characters can not insert into
DB correctly. Could you pls help me how Can we solve
the problem?
thanks a lot. |
|
c*****d
发帖数: 6045 | 5 不可能吧，如果我没有理解错，你在使用identity
那你再添加一条的话，岂不是要重复6吗？ |
|
j******t
发帖数: 11 | 6 or it is the way Access primary key goes? |
|
m**********m
发帖数: 92 | 7 If you are using autonumber in Access or identity in MS SQL Server, then it
works this way. Nothing was wrong. The number is not reset when you delete
records. To reset the autonumber to a certain value, you need to use
DBCC CHECKIDENT to reseed the column at certain value
in sql server 7. Please google its usage and examples. |
|
j******t
发帖数: 11 | 8 thanks again! //BOW
just found out that one "stupid" way to solve the problem is to delete the key
and insert it to the table again. then everything works out well.:) |
|
