I have to say this having read this thread.

half the problem with the IT industry is people doing jobs for which they are not qualified, and not owning up when...

There is also a stored proc I added a few weeks ago that will enable you t oscript out the insert statements for data in the tables similar to sqldump...

I have not come accross this exact issue but I have come accross a similar issue involving the timestamp field.

When coding an ASP/COM site with an SQL Server back end...

As a developer I have got to commend a DBA for bringing this up. I very rarely deal with DBA's and am mainly responsible for my own databases.

In my experience...

try

SELECT CONVERT(char(12),Northwind.dbo.orderdate,3) as orderdate

FROM Northwind.dbo.Orders

see

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_con_11_77l1.asp

Mr Peter Livesey

Edited by - PeterLivesey on 02/05/2002 10:26:53 AM

quote:

---

SELECT Orderdate

FROM Northwind.dbo.Orders

WHERE OrderDate = CONVERT(varchar, '7/19/1996', 100)

---

you are still selecting orderdate as a...

quote:

---

The ODBC connection is set as the 'sa' login and password.

---

I suggest dropping this ODBC...

I am not a DBA myself but a developer who has spent a lot of time studying, database

design.

Not all Companies have a DBA, my experience is that most SME's...