Can you post your code?

If memory serves, xp_sendmail only returns a 0 or 1, and it considers 0 a success. I don't believe it populates the @@Error variable, as...

What is the datatype returned by Debug.Write?

What is the precision of that datatype.

Because you used imprecise datatype you failed to return precise number.

Sorry.

Why would I care what precision it...

Lies and the lying liars who tell them.

Your test scenario was coded as specified, and you were quite specific. BR nailed the results. Traditional rounding didn't. In your test, .1251...

Then you're wasting your time performing replication, as failover won't be pretty when the subscriber-turned-publisher doesn't have a seed.

My earlier suggestion for using blocks of identity values on different tables will...

3. No.

I displayed that BR contradicts itself in 900 cases out of 20000.

You're still lying. Let's see the post where you did that. Heck, I'll help you out.

Here is your...

1. "2" with which precision?

If display does not show you following digits it does not mean they don't exist.

"2.0" displayed on screen is not "2.(0)"

So, your result does not...

If memory serves, the subscriber doesn't increment the seed when you do this, so in a failover, it would be out of synch.

That wasn't your question, a question which I answered quite thoroughly. You seem to often change your question once we give a definitive answer, full of proofs, etc. Tell you what, why don't...

You don't remember saying "It's funny nobody can provide a way to store 1/3 in computer. Is anybody here a programmer?"?

I showed you a way, one of many ways, in...

We've already been over this. Remember in the other thread where you claimed that no programming language would return 2 for the expression (2/3) * 3? Remember where I not...

It even thinks a tab (Char(9)) is a valid numeric.

As a long-time consultant, I completely agree.

If a client has an existing system that is poorly designed, but that they are happy with, our job is to work around it,...

I'm guessing that Eamon was given the requirement that identifiers had to be unique throughout a database.

On one of my contracts, I was given such a requirement, because someone had read...

Ah, I missed that part. I saw the line "I have to take the latest highest value from a control table...", but missed the inline comment where he states "this...

After looking over the expected output, I think I want to retract the fact that I'd bet you are correct. It's still possible, but I don't think I consider it...