Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scrpt questions
Message
From
26/04/2001 14:30:39
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Miscellaneous
Thread ID:
00499152
Message ID:
00500291
Views:
24
>>Mike, raising that error in QA also 'worked' - in that it prevented the rest of the script from running
>
>Really?!? I tried it but nothing happen
>
>SELECT 'hello'
>RAISERROR ('an error occurred', 16, 127)
>GO
>SELECT 'world'
>GO
>
>This doesn't terminate the script. What did you do?
>
>-Mike

if @cVersion not in ('DB4', 'DB5') raiserror ('DATABASE VERSION ERROR!', 127, 1) with nowait, log

it's ugly - but kills the script

HTH,
Ken B. Matson
GCom2 Solutions
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform