January 21, 2014 at 10:36 am
And just for the record, it also works in SQL Server 2012 (why shouldn't it...). Had to get rid of some funky chars (most probably due to some enconding issue), solve the brackets issue too, and now works smoothly.
Thanks,
January 29, 2014 at 6:34 am
Hi Everyone,
I am trying to execute this script as it is on a SQL 2000 and 2008. I am getting all sort errors. Please see below. Can anyone help please
Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Line 11
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 12
Line 12: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 22
Line 22: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 30
Line 30: Incorrect syntax near '?'.
Msg 137, Level 15, State 1, Line 37
Must declare the variable '@sql'.
Msg 137, Level 15, State 2, Line 38
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 41
Line 41: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 53
Line 53: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 60
Line 60: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 65
Line 65: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 79
Line 79: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 111
Line 111: Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Line 112
Must declare the variable '@sql'.
Msg 170, Level 15, State 1, Line 116
Line 116: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 118
Line 118: Incorrect syntax near '?'.
Msg 137, Level 15, State 2, Line 124
Must declare the variable '@sql'.
Msg 156, Level 15, State 1, Line 132
Incorrect syntax near the keyword 'END'.
Msg 170, Level 15, State 1, Line 136
Line 136: Incorrect syntax near '?'.
Msg 170, Level 15, State 1, Line 143
Line 143: Incorrect syntax near 'DSP'.
Msg 170, Level 15, State 1, Line 144
Line 144: Incorrect syntax near 'DSP'.
Msg 170, Level 15, State 1, Line 145
Line 145: Incorrect syntax near 'DSP'.
September 23, 2014 at 7:30 am
Try running the script that was posted on 2/22/2010 10:47:26 PM
Chris
April 30, 2015 at 10:06 am
Hello Mike Tutor,
Can you please paste your script here to know what kind of chyanges did you do to get daily alert/reports?
Thanks.
Thanks.
May 12, 2016 at 7:31 am
Thanks for the script.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply