Viewing 15 posts - 3,301 through 3,315 (of 6,216 total)
Snapshots are intrinsic to all three types of replication. I'd recommend you read everything you can find in BOL about replication and maybe read the replication chapter in a book...
September 6, 2002 at 5:46 pm
Its a registry key, HKLM\Software\Microsoft SQL Server\instance\MSSQLServer, key is BackupDirectory. Should be able to get it from there.
Andy
September 6, 2002 at 5:45 pm
If you use merge there is the possibility that a row could get modified on both publisher and subscriber, creating a conflict - which update wins? MS has built in...
September 6, 2002 at 4:02 pm
I dont think automatically, have to issue the sync command somehow. There is a Win component that will do it, or you could via SQL. Honestly havent tried that, but...
September 6, 2002 at 3:05 pm
Two main ways. One is merge replication, really made for those type of situations, or transaction with immediate update/queued update subscribers. I believe it is possible to do true bi...
September 6, 2002 at 12:01 pm
Possibly #1 will work, but definitely would want to test it before committing. #2 is going to get expensive, but is not a bad strategy. #3 you can split the...
September 6, 2002 at 8:39 am
I think opening/closing the connection as you and relying on connection pooling is the way to go. Definitely dont want to hold a connection for every user. If you have...
September 6, 2002 at 7:58 am
I'll look. Dont know how much I'll help, but I'll look!
Andy
September 6, 2002 at 7:56 am
You can actually script out the trigger directly by using the Object Browser to locate it, right click, script as create, alter, etc
Andy
September 6, 2002 at 5:55 am
It does work, but can't say its very elegant for grouping/packaging!
Andy
September 6, 2002 at 5:54 am
Cant think of any permissions required. SQL manages the files, as long as you can get a connection to the box and authenticate with SQL, EM should work.
Andy
September 6, 2002 at 5:52 am
One of these days we'll have to get this written down exactly! Chris, you dont need AWE to use up to the 3G mark, correct? If you use /3GB in...
September 6, 2002 at 5:50 am
You can do it with Exec(). Downsides are you dont get a compiled query plan, security is evaluated at run time, presents a potential security flaw via an injection attack....
September 5, 2002 at 7:41 pm
Not aware of any issues. Recommend you start a new topic, we'll see if anyone has ideas.
Andy
September 5, 2002 at 7:39 pm
By profiling I mean running SQL Profiler to see exactly what sql is being sent from the client machine. Thats how I got the text I posted earlier showing what...
September 5, 2002 at 4:28 pm
Viewing 15 posts - 3,301 through 3,315 (of 6,216 total)