Viewing 15 posts - 1,576 through 1,590 (of 6,216 total)
For read only subscribers it's cake. If you'll have updating subscribers (transactional or merge) SQL will still handle the idents for you by issuing ranges to each subscriber. Biggest caveat...
September 17, 2003 at 11:19 am
Funny you should ask. I put one together last year for a project we did in partnership with Lumigent. Email me your address and I'll send you one.
Andy
September 17, 2003 at 9:02 am
You can also alias him to DBO and avoid the issue that way.
Andy
September 17, 2003 at 9:00 am
There have been some other posts, but so far I haven't heard from anyone who has it running. I think I posted earlier that it was definitely interesting when I...
September 17, 2003 at 5:41 am
September 17, 2003 at 5:40 am
You could have them query to get the constraint. Not as nice perhaps, but doable.
Andy
September 16, 2003 at 12:29 pm
I use RAID-5, pure economics believe it or not! On the caching I sure don't know the answer, but my hunch is that you're better off to cache the writes...
September 16, 2003 at 4:43 am
That's a tough call. I think for a very small set where you really really don't think it will change, I'd use the constraint. One consideration is if you are...
September 16, 2003 at 4:38 am
I'll email Brian to look at this, he administers it and no idea how he scores. He's out of pocket for a couple days, look for a reply around the...
September 16, 2003 at 4:35 am
Could also look at using the textinrow option if a lot of your text fields are small but some still exceed the limit for varchar/row length.
Could pick up a little...
September 16, 2003 at 4:34 am
I dont know if I agree that a table restore is a bad practice. Take the case where a knucklehead deletes all the rows from a 100 row lookup table....
September 15, 2003 at 5:25 pm
Not quite the same, but this might help (use caution!):
http://www.sqlservercentral.com/columnists/awarren/attachanddetachagain.asp
Andy
September 15, 2003 at 5:22 pm
You can do it by just comparing one table at a time, using different queries to identify which rows need to be added, deleted, or updated. Red Gate as a...
September 15, 2003 at 1:51 pm
Why is it missing? Those shouldnt be touched by users. Take a look at the proc sp_MSscript_sync_upd_proc. You can also fix it by just doing a new snapshot.
Andy
September 15, 2003 at 1:49 pm
Is the merge agent running? Have you verified the data is inserted successfully? Does it happen if you insert into a different server?
Andy
September 15, 2003 at 1:47 pm
Viewing 15 posts - 1,576 through 1,590 (of 6,216 total)