• I think that the following line of code only works on SQL 2008

    DECLARE @i INT = 10

    In SQL 2005, it should be

    DECLARE @i INT

    SET @i = 10

    --------------------------------------------------------------
    DBA or SQL Programmer? Who Knows. :unsure: