Viewing 15 posts - 1 through 15 (of 230 total)
remove post
Edited by - bryan99y on 06/20/2003 4:27:56 PM
June 20, 2003 at 2:40 pm
What are most people runnning - active/active or active/passive and why?
June 16, 2003 at 8:13 pm
I read with an active/active two node cluster, each database server acts independently and can server data. When a failover occurs, then the "instance" from the failed server runs on...
June 16, 2003 at 8:14 am
I want to be able to have both nodes active at the same time and be able to load balance.
What is WLB?
June 16, 2003 at 5:51 am
wouldn't dropping just the article work?
exec sp_droparticle @publication = ...
exec sp_addarticle @publication = ...
(as you can tell from my questions I have no way to test this...just in prod.)
June 13, 2003 at 10:40 am
problem: (two possibly)
alter table property alter column building_size_ext decimal(18,2)
Server: Msg 4929, Level 16, State 1, Line 1
Cannot alter the table 'property' because it is being published for replication.
Warning: The table...
June 13, 2003 at 7:29 am
I was told that you cannot make changes to the publisher without stopping replciation for snapshot.
Is this true?
June 12, 2003 at 4:49 pm
Snapshot repl:
I just want to make a column data type change.
How?
June 12, 2003 at 10:07 am
the reason for caching is to accomodate large data sets.
June 11, 2003 at 11:54 am
what if the recordset is very large?
what if the user chooses a record on the 1st page...thus caching is useless and not necessary.
We are dealing with about 50 calls/minute here.
...
June 11, 2003 at 11:29 am
that won't work.
that will only work with a temporary table. Don't want that because we will be getting about 100 page hits/sec. Too much temp. table creation.
June 11, 2003 at 11:14 am
problem solved.
sp_repldone. No need to unpublish and publish as BOL indicates.(from Microsoft)
June 10, 2003 at 3:10 pm
Viewing 15 posts - 1 through 15 (of 230 total)