Hi, i have this T SQL
declare @recount int
set @recount = 3
if @recount < 1
Print 'sending email'
@profile_name = 'WltProfile',
@recipients = 'email@example.com',
@subject = 'import exe may of has crashed on dev ',
@body = 'This is an automatic email ...'
It SHOULD ignore the IF and step over it
however, when i Run this, i get this in results pane:
Mail (Id: 1043) queued.
Its never printing the text 'sending email'
And its always sending the email even though it shouldn't execute that code as its inside the if
What is wrong with this code?