Viewing 15 posts - 1,366 through 1,380 (of 6,216 total)
If you go through a secure (https) proxy I dont think it does.
Andy
November 11, 2003 at 9:26 am
MaxID + 1 is tricky if you have concurrent users getting a key at the same time. This is really all the ident does, it just manages concurrency for you.
Andy
November 11, 2003 at 9:24 am
November 11, 2003 at 9:24 am
CDW does a detach/copy, you can't detach (in a supported way) without dropping replication. You can alter system tables as posted to let you do it.
Andy
November 11, 2003 at 9:22 am
File growth won't break the connection directly, potentially could case a timeout if it took long enough (or long enough in concert with the update). Do you get an error...
November 10, 2003 at 6:10 pm
Check the box so that only sysadmins can run cmdexec processes. Use a domain account and give it only permissions to things it needs to have (drives, file shares). Dont...
November 10, 2003 at 6:09 pm
Performing simo operations is bad, didnt think you could do it. SQL uses the "shared nothing" method, which means that only one instance of the SQL.exe should be able to...
November 10, 2003 at 6:06 pm
Thank you all for the comments. You're right, it does depend, there is always a case where breaking the rule is the right thing to do. My hope is that...
November 10, 2003 at 6:03 pm
November 10, 2003 at 6:00 pm
Should work fine. You get all the pros/cons of a SAN. If you've got the bucks for it nothing wrong with it!
Andy
November 10, 2003 at 5:58 pm
I choose not to use composite keys as the primary. Life is simpler that way. Less to type when you join, smaller key means better perf, and hopefully the single...
November 10, 2003 at 5:54 pm
I agree, use it as a code generator, then go from there.
Andy
November 10, 2003 at 5:49 pm
The first part of setting up publisher, distributor, and publication should be the same. Haven't ever done the repl to Oracle, little info in BOL, search for "Oracle Subscribers".
Andy
November 10, 2003 at 5:48 pm
Interesting problem. No ideas yet. Closest link I could find:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_servdatabse_1ypf.asp
Andy
November 10, 2003 at 5:45 pm
Two logins is a good approach, though using it forces you to use sql logins and not NT authentication (if you care). Have to be very careful that later on...
November 10, 2003 at 8:26 am
Viewing 15 posts - 1,366 through 1,380 (of 6,216 total)