Viewing 15 posts - 466 through 480 (of 1,098 total)
Try generating the script of the publication with EM, to check any wrong value, and drop and recreate the publication again.
August 12, 2003 at 10:09 am
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,...
August 8, 2003 at 9:48 am
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...
August 8, 2003 at 6:54 am
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?
August 7, 2003 at 1:53 pm
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...
August 7, 2003 at 1:09 pm
How are you transfering the data? bcp, DTS?
Check that the data in the text file has the same format all along the file.
August 7, 2003 at 1:04 pm
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...
August 7, 2003 at 11:39 am
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...
July 29, 2003 at 3:50 pm
Yes, you can use sp_repladdcolumn and sp_repldropcolumn.
July 29, 2003 at 3:47 pm
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...
July 29, 2003 at 10:17 am
Wich type of replication? Transactional?
July 29, 2003 at 10:11 am
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...
July 28, 2003 at 2:10 pm
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...
July 28, 2003 at 11:12 am
Viewing 15 posts - 466 through 480 (of 1,098 total)