We asked specifically (several times) for your expected OUTPUT too.

In particular, I am unclear on this statement:

and your task is to add a new column called...

My understanding is that you can...

GilaMonster (1/27/2014)

---

I don't see the point of writing you an alternate query if I can't test it...

SELECT a.ID AS Master_ID, b.ID AS Duplicate_ID

FROM dbo.Merit_Build2 AS a

INNER JOIN dbo.Merit_Build2 AS b

ON a.Country = b.Country

AND a.Postcode = b.Postcode

AND a.organisationname = b.organisationname

AND a.Address1 = b.Address2

WHERE...

>> FROM sys.identity_columns

Thanks for that nugget Jeff - almost 45000 man hours working with SQL Server and still learning!! :w00t:

Search web for sp_msforeachtable. It will iterate through all user tables in the database and execute code you specify. You will need to test syscolumns joined to sysobjects...

Read Books Online. They are a tremendous resource and are free with the product.

Mani-584606 (1/24/2014)

---

We have Vmware VM machines. As per Systems team, if we wanted to use Quorum as a Shared drive, then they need to create RTM drive And if they...

dave-L (1/23/2014)

---

Our production server has been generating rather frequent (at least once a day) 825 errors and I am considering enabling trace flag 818 for more information on the issue.

KB...

You gave the answer right in your quote of guidelines:

> Even number of nodes, no shared storage ...

Evil Kraig F (1/23/2014)

---

GilaMonster (1/23/2014)

---

In that case, Kraig's comments on contention don't apply, he was talking about the practice of...

Shrinking a tlog will not necessarily shrink it, or shrink it to a size you want (which should NOT be a tiny size, btw). It depends on where the...

Mani-584606 (1/22/2014)

---

Hi,

I want to set up AlwaysOn Availability Groups using 2 windows servers.

1. I have 2 Winodows enterprise servers ready

2. Clustering feature enabled on both of them

So before I...

Joe.Spitler (1/23/2014)

---

We are running MS System Center Operations Manager (SCOM) with 2 nodes, always on, with SQL Server 2012. Our transaction logs are growing and filling up the the...

I STRONGLY recommend a 2-number scheme over GUIDs to ensure uniqueness for numbering across multiple servers. Bigint plus smallint is just 10 bytes vice the 16 you need for...