This is just a standard windows 2000 box running labview 7.1. We did not see any errors on the local machine until we setup labview to record all SQL...

Found the problem, but i now have another question. It appears SQL 2008 interrupts the data type differently then SQL 2000. In SQL 2000 it would accept this...

I don't think labview is waiting on any triggers. We don't delete the table and recreate with each entry. In this example everything is writing to a database called...

Your right guys, i forgot to put DESC on the end. Sorry for the trouble and thank you for the quick responses.

That gives me the last rows that either have no date in them or dates someone entered in 1900. The data and dates are entered by a machine which...

Oh i'm sure you will. I haven't run into the same problems your...

Maybe this link will help you.

http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/04/stupid-dba-tricks.aspx

datazulu.com/.../Sql2008-R2-Upgrade-Fail.aspx

Thanks GSquared i'll have them try that.

Do you know if this problem disappears when the backend is SQL2008? I'm working on upgrading our sql2000 server to sql 2008 std.

they are using domain accounts.

Thank you Seth! I'll give these a try.