raiserror with Nowait not working as expected 1

[baboudi]

Hi all,

I am using raiserror with nowait for the first time but I am not having the expected behaviour.

i.e. if I run the following, I should have the first message immediatley and the second one after 5 secs, but both messages are appearing at the end of the procedure run (as if NOwait is being ignored)

RAISERROR ('DELAY 1 HAS ENDED', 10,1) WITH NOWAIT

WAITFOR DELAY '00:00:05.00'

RAISERROR ('DELAY 2 HAS ENDED', 10,1) WITH NOWAIT


I tried this on different SQL Servers (2005/2008) with the same behaviour.

Am I missing something obvious?

Thanks a lot
Benoit

 

[baboudi]

Apologizes if this is a stupid question, but havent figured this one yet, and all my research showed that I should get a message immediately when the nowait is used.

any comments/pointers very welcome

 

[markros]

If any consolation, I'm getting the exact same behavior.

PluralSight Learning Library

 

[tsuji]

How to say... When executing the block of lines in the management studio, look into the "Messages" tab _immediately_ (it requires a user click on the "Messages" tab otherwise it is defaulted to "Results" tab), the first msg_str does show up immediately and then waiting till the second msg_str.

If one stays on the "Results" tab till the end of the execution, it creates an illusion of both msg_str appear simulataneously after the 5 sec delay.

It seems the behaviour is following the description of the documentation.

 

[markros]

Actually, you're right. It does work correctly - I was looking at the results tab instead of messages.

PluralSight Learning Library

 

[baboudi]

thanks tsuji and markros.

Thats was the mistake I was doing...looking under results instead of messages!