• dlucas-615847 (9/19/2009)


    When I try to creat this stored procedure, I get two syntax errors:

    Msg 102, Level 15, State 1, Procedure usp_maintain_database_log, Line 107

    Incorrect syntax near '?'.

    Msg 102, Level 15, State 1, Procedure usp_maintain_database_log, Line 111

    Incorrect syntax near '#results'.

    I'm not sure why.

    I can't seem to reproduce it but check the quotes ('). I've run into some problems with the WYSWYG editor on SSC when uploading scripts. You can e-mail me at tbollhofer2@gmail.com if you continue to have problems and I'll send you a copy. I've been running this in production for some time now.

    Thanks 🙂