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 🙂
Tommy
Follow @sqlscribe