Microsoft KB Archive/288241

= PRB: Problem with the &quot;sp_update_job_trigger&quot; Stored Procedure =

Article ID: 288241

Article Last Modified on 9/23/2002

-

APPLIES TO


 * Microsoft Internet Cellular Smart Access Server 2000

-



This article was previously published under Q288241



SYMPTOMS
A problem may occur with the following if-statement in the &quot;sp_update_job_trigger&quot; stored procedure: if @newfolderid <> @oldfolderid If &quot;@oldfolderid&quot; has a null value, which is the initial value for received e-mails messages, the if-statement may evaluate to false and the Userstatus value in the job table may not be updated. If Userstatus does not indicate that the message is deleted, you cannot remove messages from the trash. Internet Cellular Smart Access (ICSA) SDK Messaging (ISM) does a check on the Userstatus value in the DeleteMail method.



CAUSE
The SET ANSI_NULLS SQL option controls whether comparison with null values evaluates to true or false. The SET ANSI_NULLS SQL option is set when the stored procedure is created. This problem may occur if the SET ANSI_NULLS option is set to ON when the procedure was created. The default value is OFF for database (DB) library connections and ON for OLE DB connections.



MORE INFORMATION
For additional information about this problem, click the article number below to view the article in the Microsoft Knowledge Base:

214601 ANSI_NULLS OFF Behavior in SQL Server 6.x and 7.0

Keywords: kbbug kbpending KB288241

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.