Viewing 15 posts - 2,056 through 2,070 (of 6,216 total)
sp_repldone
Updates the record that identifies the last distributed transaction of the server. This stored procedure is executed at the Publisher on the publication database.
Syntax
sp_repldone [ @xactid = ] xactid
...
June 9, 2003 at 1:32 pm
You do/dont have a primarykey already? If not, I'd start there if possible, probably go with identity or uniqueidentifier. I think probably worth indexing the datetime value, see what happens....
June 9, 2003 at 11:20 am
Well...not really! Maybe just try to filter on the publisher computer name as the hostname. You'll get a lot, but you can filter it afterwards.
Andy
June 9, 2003 at 11:17 am
Log reader picks up the data and stuffs into distribution, then distribution agent actually calls the proc that should include the column you added. Hate to ask, but you're sure...
June 9, 2003 at 8:59 am
Do you get an error or does the update just not change anything? If an error, which one? One reason for an update to fail without error is code in...
June 9, 2003 at 7:24 am
I don't think the hint hurts you. Easy enough to test a few times with/without. Probably need to revisit the query plan, see what can be tweaked.
Andy
June 9, 2003 at 7:22 am
Doing the explicit create table is preferred, the select into can cause blocking in tempdb.
Andy
June 9, 2003 at 7:21 am
You only need a logreader for transactional - pretty common to use transactional just to get the concurrent snapshot. Do you have any other publications set up on the publisher...
June 9, 2003 at 5:10 am
Shouldnt have to provide anything if the app is using NT authentication, SQL should detect and authorize access if appropriate. If the apps require a sql login then you'll have...
June 9, 2003 at 5:08 am
Good code to demo problem, I can reproduce. Quick look on MSDN didn't reveal anything. My guess is that ADO is stripping out single quotes for the sort. If so,...
June 9, 2003 at 4:28 am
Get the logreader running and keep it running. The default behavior is to not remove records from the log until the logreader has processed, preventing transactions from being missed as...
June 8, 2003 at 3:51 pm
It will work, but you have to have all the DTS dll's installed on the machine. Check the redistribution policy, but I think ok as long as you have licensed...
June 2, 2003 at 8:33 pm
Tried running the XP machine as local admin, see if its a permission issue?
Andy
June 2, 2003 at 5:10 pm
I agree that using a role avoids this kind of problem. Definitely something to put on your todo list, or just deal with now and be done with it!
But to...
June 2, 2003 at 5:08 pm
Viewing 15 posts - 2,056 through 2,070 (of 6,216 total)