Hmmm....i guess i could. Goal here is to make use of windows account in a connection string. I know you could...

I will get the execution plan by eod, mentioned below is the...

happycat59 (3/26/2012)

---

My first question is "Why are you even needing to specify DOP (or any other hint) ?"

Generally SQL Server will do a pretty good job without any hints. ...

opc.three (3/13/2012)

---

sqldba_newbie (2/19/2012)

---

Ok i got this working,hope this would help someone.

For SP's i haven't tried this because WSUS has the capability to deploy SP's.

For CU's, you can make use of...

I do have a hard copy of his book. Let me...

Suresh B. (3/7/2012)

---

sys.dm_exec_query_plan DMV gives cached plans in...

Suresh B. (3/1/2012)

---

1) Run the following (with your database and publication name):

USE <Database>

GO

EXEC sp_changepublication

@publication = 'MainPub',

@property = N'allow_anonymous',

@value = 'false'

GO

EXEC sp_changepublication

@publication = 'MainPub',

@property = N'immediate_sync',

@value = 'false'

GO

2) Add new article...

Suresh B. (2/29/2012)

---

I believe it creates "snapshot" of only the new articles.

I believe it does...

GilaMonster (2/29/2012)

---

Not much unless you have explicit transactions. It is, as its name implies, an ID for the transaction

So

BEGIN TRAN

insert ...

update ...

update...

delete ...

COMMIT

will all get the same transactionID, however without...

Suresh B. (12/21/2009)

---

Apollo74x (12/21/2009)

---

Suresh B. (12/17/2009)

---

Why is a complete snapshot being generated when a new article is added (SQL 2005)?

--------------------------------------------------------------------------------

This is expected behaviour if you have a merge or...

Amirali Charania (9/7/2007)

---

I know this is a old post, but I have the "exact" same issue with SQL 2005. Was a solution to this problem found? I have SQL 2000...

winash (2/22/2012)

---

Actually thats what we have been doing. My biggest concern here is whenever we add a new object to subscriber we need to reset-up replication and re-create all synonyms...

Steve Jones - SSC Editor (2/22/2012)

---

I'm not sure mirroring or log shipping work if this is a local server being read only for online work in an application. Updates for...

Brandie Tarvin (2/22/2012)

---

Well, okay. There's still a non-Replication method around this.

Depending on your edition, you could use Log Shipping or Data Mirroring to get a readable version of a secondary...

No, not for reporting server. Our architecture is setup in such a way that all the reads has to go to local server and writes to central server(publisher). So secondary...