Roy had the right idea...but I think forgot a few pieces along the way.

Select Ix.D, a.FirstVale, b.FourthValue, d.FifthValue

from MainTable as x

Left Join

(Select id, Sum(Column1) from Table1 where type='A' GROUP...

From what I can tell - it completely overlooks it. Perhaps once you touch the setting in SSMS, etc... I've got it set @ 250 in the registry: cycle...

And having just tried it - the minute it cycles, the number>100 resets to 99. So - you're still stuck.

That's from within SSMS. If you're talking 2000 then...

If they want to pay 250$ for microsoft to tell them what the documentation already states, that's certainly their prerogative. Otherwise - show them the article above.

You don't need to hack the registry to do this in SQL2005.

Open up SSMS, management, right-click on SQL Server Logs, pick Configure. Set it there.

You CANNOT set it to...

It's a case of "you get what you paid for". As far as I know - you get essentially NO support other than what is in the KB and...

It's going to take more info than that to help you.... As in - what issue are you running into? What does you data look like? What do...

...and don't be surprised if some useful keys are wiped out in the process or cleansing the confidential data.....

Creating a brand new database and copying the objects should work as...

It also won't help if textnumber isn't initialized to ''.

chris.compton (2/12/2008)

---

Yes it does, thanks!

Is "candidate" a type of key too?

(or maybe the poster meant 'candidate' in a non db sense

i.e. "candidate to be a key"... can't...

antonio.collins (2/12/2008)

---

this particular example is not a pure triangle as illustrated in your article. that's because the 'code' (account number) is used as the primary join article. so,...

Also - what type of mirroring is it?

Jeff Moden (2/12/2008)

---

I took a look in BOL for Kishore's suggestion on using tablediff.exe.

Lemme quote...

The tablediff command prompt utility returns detailed difference information between two tables and can...

Lookup_BI (2/12/2008)

---

Hi Chris,

I totally get you, but my employer is just over the hill to use a dynamic stored procedure.If only I can get this working, as I have a...

David Leibowitz (2/12/2008)

---

On more complex calc's or those calling functions, computed columns provide a significant hit on performance..I used to use them heavily...I would suggest using them sparingly.

Also, you cannot...