Viewing 15 posts - 2,671 through 2,685 (of 6,216 total)
Look at what account is being used for the connection?
Andy
January 17, 2003 at 4:45 am
Replication would work fine. Since it will be read only I think transactional makes more sense for you (I'd consider merge vs trans with updating subscribers if you needed to...
January 17, 2003 at 4:43 am
Hmmm. How about starting small? We could host a chat session once, see how it goes, get some feedback? Guys? Guys?
Andy
January 16, 2003 at 5:37 pm
I was at the demo with Steve and was really going in thinking I would not like it. Pleasantly surprised. Failover is quick! The downside (and keep in mind this...
January 16, 2003 at 11:56 am
Thats not a bad idea, a variation of the proxy approach of putting the request in a table so that sql agent can do the work. Potentially less secure since...
January 16, 2003 at 5:56 am
I gotta spend more time doing merge repl myself! Definitely looks like you're missing a table or view that stores the change. Probably fixable, but you have considering just redoing...
January 15, 2003 at 6:18 pm
I dont delegate this in production, they do have access on the dev server (we have a small team). You could put them in the processadmin role so that they...
January 15, 2003 at 6:14 pm
Im new to the SAN stuff, but maybe you could do the BCV thing where you split off a copy, then maybe could use it to sync the other copy.
Andy
January 15, 2003 at 4:25 pm
Should (not on a domain at the moment to confirm) just be able to update sysxlogins. Everything internally is stored based on the sid from there.
Andy
January 15, 2003 at 4:24 pm
Good first step is to figure out why the deadlocking. Maybe you need better indexes, do smaller batches, etc. Could also set the deadlock priority to low so that if...
January 15, 2003 at 4:22 pm
I think its via linked server, maybe its configured wrong?
Andy
January 15, 2003 at 4:20 pm
It is interesting. I guess it depends on the purpose, hoped for result. Thinking maybe we could run some type of bot that would log the exchange into the forum...
January 15, 2003 at 4:14 pm
I may have some questions in a few days. Right now we're juggling a lot of different options based on projected growth and expansion vs what we have to work...
January 15, 2003 at 4:10 pm
As I mentioned above, it IS written in journal style. As for your questions, you tell me? How could I know that the container would drop? What could I do...
January 15, 2003 at 3:59 pm
You can do it, just takes work. I've got an article up that goes into more detail, not 100% match but close. Basically you need to get the logreader to...
January 15, 2003 at 12:55 pm
Viewing 15 posts - 2,671 through 2,685 (of 6,216 total)