Forum Replies Created

Viewing 15 posts - 466 through 480 (of 1,098 total)

  • RE: Trouble creating Snapshot

    Try generating the script of the publication with EM, to check any wrong value, and drop and recreate the publication again.

  • RE: Scheduled DTS job fails to execute

    You should map the drive inside the DTS excecution. You can do it with the "net use" command.

    To avoid errors, you can choose a drive letter you don't use frecuently,...

  • RE: jobs on the subscriber

    Are you talking about the job of the distribution agent?, the log reader agent?

    Or one of the replication Alerts?

    If they are jobs, then you can change it from within the...

  • RE: Ignoring DupeKey Errors on Bulk Insert

    You should drop and then re create the pkeys..or you can bulk insert into a temp table, and then insert from that table with a left join?

  • RE: Further to my previous.....

    you should check the PAL (Publication Access List) in the publication properties.

    Also check in the distribution job, the parameters used to run the agent.

    If I where you, I would try...

  • RE: when transfering, a few rows were missing

    How are you transfering the data? bcp, DTS?

    Check that the data in the text file has the same format all along the file.

  • RE: Sql Agent auto-start

    I have a batch that checks in a period of time the status of the services..and if someone is stopped, then it starts them.

    I don't think you can do it...

  • RE: Restore fails

    Are you using the KEEP_REPLICATION option?

  • RE: Using a SP to load a temp table ...

    Can you post the error?

    Usually temp tables created in an sp are deleted after the execution of it.

    But is not bad to add an IF EXISTS DROP TABLE clause to...

  • RE: Modify table structure

    Yes, you can use sp_repladdcolumn and sp_repldropcolumn.

  • RE: instances

    osql -L

    to know all the servers in your network.

  • RE: Continuous replication

    The only way to keep in sync your subscribers, will be by executing the missing inserts and updates manually. By a script of your creation. Then you can check if...

  • RE: Pull replication failed right after rebuild index

    Wich type of replication? Transactional?

  • RE: Sysfiles table Update

    To be sure you have the last status, you can capture the output of the sp_helpdb to check the size of your dbs.

    You can also use xp_fixeddrives to check free...

  • RE: Continuous replication

    If you don't want to apply a new snapshot, you will have to manually insert all the missing recors in your subscribers, and update all the different records, too.

    Since the...

Viewing 15 posts - 466 through 480 (of 1,098 total)