I like that answer, Rudy!  My similar favorite is "I don't know, but here's what I'm doing to find out!".

DateTime columns have no format... the dates are actually stored as a special form of FLOAT (BOL says 2 INTs but that's not quite right).  Changing the column to a...

I don't use Power Builder so this will likely not be much help... but, if it were me, I'd select 1 column at a time to troubleshoot which column is...

You cannot use a column name as a parameter for a table valued function.  From Books Online...

Multi-statement Table-valued Functions

CREATE FUNCTION [ owner_name. ] function_name

    ( [ { @parameter_name [AS]...

Show us the INT value for '5/10/2007' and we'll be able to tell you (but I think you're wrong about the date)

Um... just making sure... you're saying that the current size of TempDB is over 166 GIGA BYTES ???

I'm...

Oh... almost forgot... if the code uses MAX(someid)+1 to determine the next "Key" or uses @@IDENTITY (SCOPE_IDENTITY is OK), that may be the source of the "Key" being out of...

Here's a powerful hint... the "key" this error message speaks to is either a "Primary Key" or a column with a UNIQUE index (usually a "Primary Key" for this error).

Ah, sorry... that's too much info...

This will do it without a loop... again, if you get negative numbers for rows for some tables, you will need to do a DBCC...

Could be a couple of things, but let's go for the simple side, first.

Try adding the WITH RECOMPILE option to the stored proc... you may be fighting something bad that...

Actually, I believe this is what they call a "UNIX DATETIME" and it represents the number of milliseconds since the midnight on 01/01/1970.  That also makes your 5/11/2007 date incorrect (unless...

DBCC SHOWCONTIG WITH TABLERESULTS

... will show you a whole lot more than just table names and rows. 

If you get negative numbers for rows for some tables, you will need...

For Windows XP... TaskMgr.exe

That'll be one case of beer for asking questions outside the scope of SQL Server

I believe this will do.

SET DATEFIRST 7 --Default for SQL Server

SELECT GETDATE()-DATEPART(dw,GETDATE())-2

Like this...

SELECT CONVERT(CHAR(10),CAST('Mar 20 2007 3:57pm' AS DATETIME),111)

Of course, you would sub a couple of things to use against a table...

SELECT CONVERT(CHAR(10),CAST(yourdatestringcolumn AS DATETIME),111)

FROM yourtable