FIX: Sp_droplogin Error 14248 if ANSI_NULL_DFLT_ON

 Last reviewed: May 1, 1997
Article ID: Q135402

The information in this article applies to:
  • Microsoft Open Data Base Connectivity, version 2.5
  • Microsoft SQL Server, version 6.0
BUG#: 10986 (6.00)

SYMPTOMS

When you try to execute the system stored procedure sp_droplogin on Microsoft SQL Server version 6.0 and enable SET ANSI_NULL_DFLT_ON, the following error message appears: 

   Error: 14248
   Message: "This login is the owner of 11 Task(s).  You must drop
             or re-assign these Tasks before the login can be dropped."
The Microsoft SQL Server ODBC driver versions 2.50.0121 or later always sets ANSI_NULL_DFLT_ON to ON when running against SQL Server 6.0. Therefore, any attempt to execute sp_droplogin from an ODBC session using the driver results in the following: 

   szSqlState = "37000"
   pfNativeError = 14248
   pcbErrorMsg = 159
   szErrorMsg="[Microsoft][ODBC SQL Server Driver][SQL Server] This
   login is the owner of 11 Task(s).  You must drop or re-assign these
   Tasks before the login can be dropped."

WORKAROUND

DB-Library clients such as ISQL/w or Enterprise Manager sets the following: 

   SET ANSI_NULL_DFLT_ON OFF
   EXEC sp_droplogin...
   SET ANSI_NULL_DFLT_ON ON
It is recommended that sites do not use ODBC to issue sp_droplogin against SQL Server 6.0.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.0. This problem has been corrected in SQL Server version 6.5. Contact your primary support provider for more information.

Additional query words: SQL Server ODBC 16-bit
Keywords : kbbug6.00 kbprg SSrvISQL SSrvTran_SQL
Version : 2.5.0121 6.0
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 1, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.