Home Forums SQL Server 2005 T-SQL (SS2K5) Date Conversion Fails in Stored Procedure - But code works in a Trigger !? RE: Date Conversion Fails in Stored Procedure - But code works in a Trigger !?

  • May 7, 2013 at 5:30 am

    #1612923

    Unfortunately I cannot upgrade our production server for another 6 months - so am stuck with 2005.

    But my main issue - is the fact that it is workign fine under a Trigger - but not a Stored Procedure.

    Thanks for any help.

    ________________________________________________________________________________________________
    Regards
    Steve
    SQL 2008 DBA/DBD - MCTS/MCITP

    Please don't trust me, test the solutions I give you before using them.