Home Forums SQL Server 2005 Development Select Statements in Stored Procedure gets Error converting data type DBTYPE_DBTIMESTAMP to datetime. RE: Select Statements in Stored Procedure gets Error converting data type DBTYPE_DBTIMESTAMP to datetime.

  • November 9, 2007 at 9:19 pm

    #750031

    We could help a whole lot more effectively if you were to post the body of the stored procedure (the one giving you the error). That error is one I've encountered dealing with OLE DB sources, and usually because I screwed some type of sytntax up. Seeing that from a Stored proc means you're doing sometihng a bit unusual, so it would probably help to see what you're up to...

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?