Its not impossible to rename the subscriber but it is messy.

My preference would be to use a dns alias as the primary pointer and switch between the two.

You will have...

You will be able to replicate to different object names. Columns I've never done before and dont believe its possible (I can't find documentation for it)

You could replicate to...

IMO the most simple solution is to use the microsoft provided tool. Tablediff.exe. Its what its there for.

C:\Program Files\Microsoft SQL Server\100\COM\Tablediff.exe

http://msdn.microsoft.com/en-us/library/ms162843.aspx

Only if the replicate ddl option is enabled in the publication.

If it is not, you'll need to:

a) reinitialise the subscriber

b) drop the column from the publisher and add it using...

This is what I determined by browsing the logs.

Additionally, if you use a horizontal filter in your publication and if the updated row does not meet a filter...

GilaMonster (6/6/2011)

---

muthukkumaran Kaliyamoorthy (6/6/2011)

---

@sqlzealot-81,

What gail told is

An inplace update only change the byte.But an exception update trigger and replication.This as you told delete followed by an...

Microsoft say that filestream performs better when storing files greater than 1MB in size.

This is a SQL2008 and 2008R2 feature.

1 x white paper

http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm

Suresh B. (6/3/2011)

---

icemannz (6/2/2011)

---

What I want to achive is basically to have a standby sql server that is updated all the time - so it is a complete copy of...

Well done.

What was it?

Had a similar issue with AMD cool n quiet as well. Similar issue

There are several potential causes. I had this issue last year and found that enabling the service account to lock pages in memory and applying this hotfix resolved all...

I maybe stating the obvious, lets start by elimination variables:

Are the SQL versions the same?

Is the hardware a different setup?

Have you compared the query execution plans for differences?

Have you checked...

You can two independant databases that were on one instance seperated onto two on a cluster. Both instances get the benefits of high availability but dont impact each other...

hxkresl (5/26/2011)

---

MysteryJimbo, however this doesn't retrieve views that make reference to the column in areas other than column headings. In many cases, my views are not pulling in...