Here is a good place to start: http://msdn.microsoft.com/en-us/library/ms366351(v=sql.90).aspx

Okay, you're right. ...

Making it easier for others:

http://www.sqlservercentral.com/Forums/Topic1161025-146-1.aspx

Steven Willis (9/6/2012)

---

ScottPletcher (9/6/2012)

---

The INT can't overflow returning billionths of a second -- the max possible value is...

Tom Brown (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Tom Brown (9/6/2012)

---

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes...

jcrawf02 (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

SQLRNNR (9/6/2012)

---

Lynn Pettis (9/6/2012)

---

Why do people think that they will get a different answer to the same problem if they post it in the correct forum?...

That is because the accuracy of datetime2 is only to 100 nanoseconds.

http://msdn.microsoft.com/en-us/library/bb677335(v=sql.100).aspx

Tom Brown (9/6/2012)

---

Anyone from the UK remember BT Phone Day - back in the 1990s sometime, the UK phone company changed all number prefixes to add a 1 -...

FYI, I just ran this query as is with no problems.

Jeffrey Irish (9/6/2012)

---

Hello all. It's been a while.

So, I inherited this query which I have used to great effect to get the most offensive Queries out of a database. I...

SQLRNNR (9/6/2012)

---

What is the circle...

As you were told in the other thread, this issue may have been fixed in SP 2 or later for SQL Server 2000. In that thread you indicated that...

Without having something to look at (I had to do this at a previous employer) I can't give you specifics, but you are going to need a file system task...

Why do people think that they will get a different answer to the same problem if they post it in the correct forum?

Are you still on version 8.00.197 of SQL Server 2000 or have you applied SP 4 yet?

This is a continuation of this thread:

http://www.sqlservercentral.com/Forums/Topic1354623-1550-1.aspx