Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 replicate transaction fail??

Author  Topic 

thanhtung2003
Starting Member

15 Posts

Posted - 2004-02-27 : 23:26:00
Hi all,
I use Enterprise manager to make a replication transaction, but the option "Transaction publication" is disable, please show me how to enable it.
Best regards,



Hi all,

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2004-02-28 : 04:56:18
Can you post the output of the following command?

SELECT @@VERSION
GO

Connect to your SQL Server using Query Analyzer and run it.

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page

thanhtung2003
Starting Member

15 Posts

Posted - 2004-03-02 : 21:18:35
This is the result of your query.
"Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "


Hi all,
Go to Top of Page

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2004-03-03 : 08:53:12
You have Personal edition and that cannot be a transactional publisher. See "Replication FAQ" in SQL Server 2000 Books Online.

--
HTH,
Vyas
http://vyaskn.tripod.com
Go to Top of Page
   

- Advertisement -