• Hello,

    I would not expect this to cause any problems. The SP(?) will take up slightly more Server memory when executing.

    If the variables are not used anywhere in the code then it would be straight forward to remove the declarations.

    Regards,

    John Marsh

    www.sql.lu
    SQL Server Luxembourg User Group