Viewing 15 posts - 871 through 885 (of 1,157 total)
I've never used this feature in the way microsoft intended. I have done this but it does require a basis server to be setup up using snapshots.
Our setup has multiple...
August 23, 2011 at 8:22 am
New column types.
Configurable replication of partition switching are a couple.
They are the main changes people are going to use. I've also found this microsoft link
August 23, 2011 at 8:18 am
Why would you delete the row at the subscriber if it was one way replication?
Another way would be to re-insert the row at the subscriber then delete from the publisher....
August 23, 2011 at 8:14 am
I never do anything other than backups in a maintenance plan and occasionally I dont do that
August 22, 2011 at 1:19 am
awu (8/17/2011)
you can use the max degree of parallelism option to limit the number of processors to use in parallel plan execution.
Question is...
August 22, 2011 at 12:55 am
I'm always cautious when using identities in replication. They've stung me in the past.
What you will need to do is calculate how many identities you need at all subscribers...
August 22, 2011 at 12:22 am
happycat59 (8/21/2011)
I think that you will also need to add a subscriber to the article (using sp_addsubscription)
and generate the single table snapshot.
August 22, 2011 at 12:15 am
Yes it is. You can create a multi tier replication topology with a publisher -> subscriber/publisher -> subscriber.
It'll be easier to leave replicate ddl on and have a pull...
August 21, 2011 at 8:30 am
sqlsponge2 (8/18/2011)
I was under the impression that a new snapshot sent via initialization would overwrite was was on the subscriber with all new data from the publisher.
You are correct in...
August 21, 2011 at 8:28 am
If you're looking for something like "sp_replremovecommand" you wont find one.
I would consider editing the repl proc on the subscriber (ALTER PROCEDURE) to skip a particular primary key OR if...
August 21, 2011 at 8:20 am
We use some DL580's and have a couple of Superdomes which are discontinued (i think).
Try SGI who do the worlds fasted Windows Server.
http://www.sgi.com/products/servers/altix/uv/[/url]
These are in the running for a potential...
August 21, 2011 at 8:15 am
All skills are useful somewhere. As I've never heard of the company or its software it wouldnt be useful to me nor at any of the companies I've worked...
August 16, 2011 at 3:14 am
By default SQL Server will consume all the memory it wants and is available. Unless you've changed this default you dont need to do any more.
You can run the...
August 1, 2011 at 4:50 am
Not with import/export wizard.
You've a fewof options, you can script the schema in advance in managment studio by right click->tasks->Generate scripts or you can do something more complicated using SMO...
July 29, 2011 at 7:36 am
opc.three (7/28/2011)[hrI always welcome a T-SQL approach first. I just added this to the toolkit. Thanks for sharing this!
Always the best approach! Never more so than with replication
July 28, 2011 at 10:07 am
Viewing 15 posts - 871 through 885 (of 1,157 total)