Tommy Bollhofer (9/21/2009)
Tommy Bollhofer (9/20/2009)
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 🙂
Update: I can reproduce this by copying the T-SQL from SSC so I'm assuming this is related to the WYSWYG editor. I just uploaded a new version which should post later this afternoon or sometime tomorrow morning. If this continues to be a problem I will reach out to Steve Jones to see if we can add a resource section so that the procedure can be downloaded directly.
In the interim, please feel free to e-mail me at tbollhofer2@gmail.com and I'll e-mail you a copy.
Thanks!
The new version has been posted to SSC. I've tested and verified everything is working. To avoid any formatting issues; i.e. UNICODE, etc., I would recommend copying and pasting the code into SSMS.
Thanks!
Tommy
Follow @sqlscribe