Groups: Member
Posts: 6
|
What is the syntax for making a call to the EnableEarlyWarningSystem method within SQL?
I've tried:
EXEC @intResult = sp_OAMethod @intObject, EnableEarlyWarningSystem, 1
Which seems to enable EWS. However, using:
EXEC @intResult = sp_OAMethod @intObject, EnableEarlyWarningSystem, 0
or:
EXEC @intResult = sp_OAMethod @intObject, EnableEarlyWarningSystem, -1
does not disable EWS.
|
Groups: Administration
Posts: 90
|
If this method is not called with a True value, the EWS properties (EWSCount and
EWSFlag) will not return a value.
Not calling the EnableEarlyWarningSystem method before initialization should disable EWS by default.
The syntax below however:
EXEC @intResult = sp_OAMethod @intObject, EnableEarlyWarningSystem, 0
is actually correct. However:
*Take note that when you set the EnableEarlyWarningSystem method to either 1 or 0 anytime in your application, you need to re-initialize each time in order for the changes to take effect.
|
