Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    chicago
    Posts
    1

    Unanswered: Replication Set up

    Hi Friends,

    My question is on Replication set up.

    we want to create replication db on our transactional Db. So
    Source db: Transactiona Database. For ex: Server A
    Destination db: Server B

    we wanted to configure using scripts. so our team developed scripts step by step to complete replication. First we want to try on test database to check if scripts are working successfully. so we took copy of transaction db and kept on the same database and ran all scripts. Replication got set up and ran successfully.

    Then we tried the same scripts on our transacation db directly, now we received an error
    'Implicit conversion from data type datetime to bigint is not allowed. Use the CONVERT function to run this query'

    Can anybody guess the error?

    Thanks in advance

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    If you double click the error it will take you to the offending line.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •