FIX: SQL Server 6.0 Service Pack 2 Fixlist

• Microsoft SQL Server, version 6.0 Service Pack 2

The following is a list of fixes and various other improvements that have been made in the Microsoft SQL Server version 6.0 Service Pack 2. Service Pack 2 is now available from your primary support provider. For more information, contact your primary support provider.

Service Pack 2 includes all fixes previously released in Service Pack 1 for version 6.0. The list of fixes for Service Pack 1 is appended at the end of this article.

Please note that workarounds described have been provided for your information only. It is not necessary to implement these workarounds if you have the updated software.

LIST OF PROBLEMS CORRECTED IN SERVICE PACK 2

• FIX: SELECT During UPDATE STATISTICS Can Terminate w/ Msg 814
• FIX: DBCC NEWALLOC May Not Detect TEXT Extent Inconsistencies
• FIX: INSERT Into w/ IDENTITY Col Inside Trigger Causes AV
• FIX: SELECT INTO From Table w/ IDENTITY Col Causes Handled AV
• FIX: Update of Primary Key Causes Repl Custom St. Proc to Fail
• FIX: Multiple ORDER BY DESC May Cause 614 Errors
• FIX: DBCC SQLPERF(THREADS) Fails w/ AV on 6.0 SP 1
• FIX: SELECT w/ IN Clause Causes AV w/ Subquery SELECT NULL
• FIX: Procedure for Repl. Can Fail When Referencing NCI
• FIX: Repl w/ Ext Chars on Non-ANSI Char Sets May Fail
• FIX: RPC w/ Text/Image Parameters May Cause Handled AV
• FIX: Syntax Error Reporting Disabled w/ St Proc >68 Pages
• FIX: Drop Procedure Gives 3702 Error if Cursor Not Deallocated
• FIX: Users Blocking With No Locks Displayed in sp_lock
• FIX: Invalid Column in Subquery May Result in Handled AV
• FIX: Milliseconds Are Not Replicated w/ DATETIME Fields
• FIX: Cursor w/ Union May Cause Errors if Not First in Batch
• FIX: Handled AV If Many Users Dropping/Creating Tables
• FIX: BEGIN TRAN After OPEN CURSOR May Not Commit
• FIX: Explicit Insert of Identity Value in SP Can Cause AV
• FIX: Error 3307 Running Update Stats After 1105 Error
• FIX: LogReader Can Fail On sp_repldone After Unsubscribing
• FIX: LogReader Can Fail On sp_repldone Using Partitioning
• FIX: Timestamp Col of Temp Table Set to 0 When Inserting Row in SP
• FIX: AV or Error 632 on Update w/ Select Count(distinct) Subqu
• FIX: Cursor Using Stored Proc After LOAD DB May Get 225 Error
• FIX: Inserts on SMP Computer Can Cause Error Message 1203
• FIX: Stored Procedures Can Corrupt Themselves in Small Caches
• FIX: A Cursor in a St. Procedure Can Cause an Access Violation
• FIX: A View With an Outer Join Can Cause An Access Violation
• FIX: SELECT TEXT Columns with FOR BROWSE Holds sh_page Locks
• FIX: dbopen Memory Leak of 32K On Failed Login Attempt
• FIX: SELECT From View w/ Data Length > 1962 Bytes May Hang Svr

FIX: SELECT During UPDATE STATISTICS Can Terminate w/ Msg 814

ARTICLE-ID:Q134629 BUG# NT: 11144 (6.00)

SYMPTOMS

Queries that run during execution of UPDATE STATISTICS can terminate with Msg 814, Level 20, State 1:

   Keep count of buffer <n> holding logical page <n> in database <db>
   has become negative.

CAUSE

Though rare, you could encounter this problem if the following conditions apply:

- The SELECT statement must include a subquery expression and execute

  a query plan that uses an index referenced in the UPDATE STATISTICS
  command (or indirectly if the entire table is referenced).

  must be set to zero on SQL Server version 6.0).

If, after encountering the initial error, execution of other commands that involve tables from the SELECT statement also fails with Msg 814, you may have to restart SQL Server to avoid encountering the error in the future.

WORKAROUND

Run UPDATE STATISTICS prior to or after the query that fails.

-OR-

Drop and recreate affected indexes instead of running UPDATE STATISTICS.

FIX: DBCC NEWALLOC May Not Detect TEXT Extent Inconsistencies

ARTICLE-ID:Q135350 BUG# NT: 11026 (4.20)

SYMPTOMS

The DBCC NEWALLOC commmand may not detect extent chain inconsistencies if the problem is on TEXT or IMAGE chains.

CAUSE

The DBCC NEWALLOC command traverses extent chains for all indexes of a table, but does not check the extent chains for indid = 255, which is the number used for TEXT and IMAGE chains. Inconsistencies of this type are also not detectable with the DBCC TEXT_AL or DBCC TEXT_ALLOC commands. DBCC CHECKALLOC does correctly detect and report TEXT extent chain problems.

WORKAROUND

Use the DBCC CHECKALLOC command in addition to or in place of DBCC NEWALLOC if you have TEXT or IMAGE columns.

FIX: INSERT Into w/ IDENTITY Col Inside Trigger Causes AV

ARTICLE-ID:Q136534 BUG# NT: 10242 (6.00)

SYMPTOMS

An INSERT INTO a table with an IDENTITY column inside a trigger can cause a handled access violation (AV).

CAUSE

The client AV occurs only if the table with an IDENTITY column has a trigger. The trigger may be fired by either an INSERT, DELETE, or UPDATE operation. The client does not cause an AV when a SELECT INTO operation is performed on a table that is not using the IDENTITY property.

WORKAROUND

If your purpose in performing an INSERT operation inside a trigger is to implement Unique Increasing key values without using the IDENTITY property of SQL Server version 6.0, then please refer to the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q75164
   TITLE     : Implementing a Unique, Increasing Key Value

FIX: SELECT INTO From Table w/ IDENTITY Col Causes Handled AV

ARTICLE-ID:Q136536 BUG# NT: 10340 (6.00)

SYMPTOMS

On Microsoft SQL Server version 6.0, a SELECT INTO from a table with an identity column when the set IDENTITY_INSERT option is ON can cause a handled access violation (AV).

The AV will not occur when the IDENTITY_INSERT option is switched OFF.

WORKAROUND

• Set the IDENTITY_INSERT option OFF before performing the SELECT-INTO.

• Perform an INSERT by issuing a SELECT from the source to the destination table.

FIX: Update of Primary Key Causes Repl Custom St. Proc to Fail

ARTICLE-ID:Q136544 BUG# NT: 11329 (6.00)

SYMPTOMS

On Microsoft SQL Server version 6.0, if you update the primary key of a table, the original primary key parameters passed to a custom stored procedure defined for replication will be replaced with the updated primary key values.

FIX: Multiple ORDER BY DESC May Cause 614 Errors

ARTICLE-ID:Q137432 BUG# NT: 11164 (6.00)

SYMPTOMS

A query with multiple ORDER BY <col> DESC clauses may get a 614 error:

   A row on page X was accessed that has an illegal length of Y in database
   Z.

FIX: DBCC SQLPERF(THREADS) Fails w/ AV on 6.0 SP 1

ARTICLE-ID:Q138013 BUG# NT: 11497 (6.00)

SYMPTOMS

The command DBCC SQLPERF(THREADS) on SQL Server version 6.0 Service Pack 1 fails with the error:

   DBCC function 'threads' in the library 'sqlper60' generated access
   violation; SQL Server is terminating process <n>

This problem does not exist in SQL Server 6.0 without Service Pack 1 applied.

WORKAROUND

Most of the information from SQLPERF(THREADS) can be found using a combination of other resources such as SQL Enterprise Manager (Current Activity), sp_who, examining the sysprocesses table, and Windows NT Performance Monitor.

FIX: SELECT w/ IN Clause Causes AV w/ Subquery SELECT NULL

ARTICLE-ID:Q138263 BUG# NT: 11525 (6.00)

SYMPTOMS

A simple SELECT statement with an IN clause and a subquery of the form SELECT NULL may cause a handled access violation in SQL Server version 6.0. The problem also occurs with a NOT IN clause instead of an IN clause in the query. However, if the subquery returns null results, the access violation does not occur.

WORKAROUND

If the subquery is replaced with the NULL keyword, the access violation does not occur.

FIX: Procedure for Repl. Can Fail When Referencing NCI

ARTICLE-ID:Q138290 BUG# NT: 10981 (6.00)

SYMPTOMS

If a published article has a stored procedure created FOR REPLICATION that references a column in a non-clustered index on the article's base table, the filter procedure can prevent a transaction from being replicated. Examining the MSjob_commands table in the distribution database can help you detect this problem.

CAUSE

The SELECT statement in the replication filter procedure is being incorrectly evaluated by SQL Server when applying the filter procedure against the logged change in the published database.

The most common occurrence of this problem is when a "restriction clause" for the article is created using SQL Enterprise Manager where the column listed in the clause is part of a non-clustered index.

This problem can also occur if you develop your own filter procedure using the CREATE PROCEDURE FOR REPLICATION command. This problem does not affect the proper synchronization of data when first subscribing, only changes made after synchronization.

WORKAROUND

1. Drop the non-clustered index.

2. Remove the column referenced in the filter procedure from the non- clustered index.

3. Filter the replicated changes on the subscriber by using custom stored procedures.

FIX: Repl w/ Ext Chars on Non-ANSI Char Sets May Fail

ARTICLE-ID:Q138291 BUG# NT: 11374 (6.00)

SYMPTOMS

Extended character values embedded in SQL statements, such as an INSERT command, can be incorrectly distributed by the LogReader on servers installed with non-ANSI character sets. In most situations, the values will appear as unreadable characters. In other situations, it could cause the command to fail with a syntax error when applied to the subscriber.

CAUSE

The sp_replcmds procedure used by the LogReader is using an ANSItoOEM conversion which can cause extended characters on non-ANSI servers to become unreadable.

FIX: RPC w/ Text/Image Parameters May Cause Handled AV

ARTICLE-ID:Q138324 BUG# NT: 11373 (6.00)

SYMPTOMS

A stored procedure created with a text/image parameter may cause a handled access violation (AV) when executed through dbrpcexec or Transact-SQL.

CAUSE

SQL Server fails to handle the text parameter properly when re-mapping stored procedure variables after the stored procedure was bumped out of procedure cache.

It is only reproducible if the stored procedure is executed with the length of the text/image parameter greater than 2048 bytes immediately after it is reloaded into procedure cache.

WORKAROUND

Because this would not happen the first time a stored procedure is loaded into procedure cache, drop and recreate the stored procedure, which should avoid the problem. Another way to avoid the problem would be to fake a call to the stored procedure with the length of the text/image parameter that is shorter than 2048 bytes, then call it with the real value. For example:

   sp_recompile test_v
   go
   test_v_proc 1,'Fake one'
   go
   test_v_proc 1,'Real, longer then 2048 byte value'
   go

FIX: Syntax Error Reporting Disabled w/ St Proc >68 Pages

ARTICLE-ID:Q138477 BUG# NT: 11209 (6.00)

SYMPTOMS

Syntax error reporting is disabled when the query plan size of a stored procedure exceeds 68 pages.

You can verify the query plan size by running DBCC MEMUSAGE after creating a stored procedure without any syntax-errors.

The stored procedure has been created, but will not exist in the database, thus it will not be displayed in the DBCC MEMUSAGE output.

WORKAROUND

Reduce the size of the stored procedure so that it is less than 68 pages.

FIX: Drop Procedure Gives 3702 Error if Cursor Not Deallocated

ARTICLE-ID:Q138538 BUG# NT: 11556 (6.00)

SYMPTOMS

If you execute a stored procedure that declares a cursor not using exec(), and then close the connection before the cursor is opened or deallocated, and then try to drop the procedure from a new connection, a 3702 error similar to the following will be generated:

   Msg 3702, Level 16, State 3
   Cannot drop the procedure 'cursor3702' because it is currently in use.

WORKAROUND

Declare your cursor using exec(), or make sure that you always open and/or deallocate the cursor before you close your connection. For example:

   use pubs
   go
   create procedure cursor3702 as
       exec("declare testcursor cursor for
       select * from authors")
   go
   cursor3702
   go

If you receive the 3702 error, and the connection which executed the stored procedure is already closed, you will need to restart SQL Server before you can drop the procedure.

FIX: Users Blocking With No Locks Displayed in sp_lock

ARTICLE-ID:Q138603 BUG# NT: 11660 (6.00)

SYMPTOMS

Many users performing queries against tables with non-clustered indexes on symmetric multiprocessing (SMP) computers with more than two processors can get processes blocking each other, but there are no related locks shown by sp_lock. KILLing the blocker may or may not alleviate the problem. This problem is very rare.

WORKAROUND

If KILL fails to alleviate the blocking, shut down and restart SQL Server. The problem is caused by applications issuing many "cancels" and can be alleviated by reducing the number of cancels sent to the server.

FIX: Invalid Column in Subquery May Result in Handled AV

ARTICLE-ID:Q138673 BUG# NT: 11623 (6.00)

SYMPTOMS

A subquery that references an invalid column may cause a handled access violation (AV). The expected output would be the 207 error message, "Invalid column name <table.column>".

WORKAROUND

Make sure you are referencing valid column(s) within the subquery.

FIX: Milliseconds Are Not Replicated w/ DATETIME Fields

ARTICLE-ID:Q138718 BUG# NT: 11767 (6.00)

SYMPTOMS

The milliseconds portion of the datetime field does not get replicated. When sp_replcmds generates the inserted value for a datetime field, the milliseconds portion is not included.

WORKAROUND

Do not include milliseconds for a datetime field in any table that is going to be included in an article for replication.

FIX: Cursor w/ Union May Cause Errors if Not First in Batch

ARTICLE-ID:Q138746 BUG# NT: 11237 (6.00)

SYMPTOMS

If a cursor is opened that contains a union between two queries, you may receive errors such as:

  DB-Library: Possible network error: Bad token from SQL Server:
  Datastream processing out of sync.
  Net-Library error 0:
  DB-Library: Possible network error: Bad token from SQL Server:
  Datastream processing out of sync.  Connection broken.
  <above is repeated many times>
  Net-Library error 6: ConnectionClose (CloseHandle()).
  Msg 533, Level 20, State 4
  Can't find a range table entry for range 5.
  DB-Library Process Dead - Connection Broken

  Msg 16942, Level 16, State 2
  Asyncronous keyset generation failed, the cursor has been deallocated

WORKAROUND

This generally occurs when there are other Transact-SQL statements preceding the declaration of the cursor. Moving the cursor to the beginning of the batch may prevent the errors from occurring.

FIX: Handled AV If Many Users Dropping/Creating Tables

ARTICLE-ID:Q138748 BUG# NT: 11417 (6.00)

SYMPTOMS

You may get a handled access violation (AV), 632 errors, or 614 errors on symmetric multiprocessing (SMP) computers running SQL Server if there are multiple users dropping and creating tables concurrently. This is true of TEMPDB as well as user databases. The timing involved for this bug to occur makes it very rare, and there are no side effects outside of the client being terminated.

WORKAROUND

Set the sp_configure "SMP concurrency" option to "1".

FIX: BEGIN TRAN After OPEN CURSOR May Not Commit

ARTICLE-ID:Q138749 BUG# NT: 11659 (6.00)

SYMPTOMS

When using Transact-SQL cursors, if BEGIN TRAN is issued after OPEN CURSOR, and then the cursor is closed, there can be an open transaction that cannot be removed with COMMIT TRAN or ROLLBACK TRAN.

WORKAROUND

Call BEGIN TRAN before you call OPEN CURSOR.

FIX: Explicit Insert of Identity Value in SP Can Cause AV

ARTICLE-ID:Q138750 BUG# NT: 10308 (6.00)

SYMPTOMS

If you explicitly insert a value into an IDENTITY column inside a stored procedure, it can cause an thread level access violation.

WORKAROUND

Use a batch file instead of a stored procedure if you need to insert a value explicitly into an IDENTITY column.

FIX: Error 3307 Running Update Stats After 1105 Error

ARTICLE-ID:Q138787 BUG# NT: 11167 (6.00)

SYMPTOMS

Error number 3307, "Process x was expected to hold logical lock on page y," can be generated if UPDATE STATISTICS is run when the database has run out of space. This can also leave stranded locks that can only be cleared by stopping/starting SQL Server.

WORKAROUND

Ensure there is adequate space in the database such that error 1105 "Can't allocate space" is not encountered when you run UPDATE STATISTICS.

FIX: LogReader Can Fail On sp_repldone After Unsubscribing

ARTICLE-ID:Q138826 BUG# NT: 11493 (6.00)

SYMPTOMS

If the last subscription to an article is removed while there are still outstanding unreplicated transactions in the published database log, the LogReader task for replication can fail with the following error:

   The replicated transaction (xxx, yyy) no longer exists in the log.
   Unable to execute sp_repldone on '<server>'.

The LogReader task will fail and be shutdown in this situation. No replication transactions for the published database will be processed until the error is corrected. Since the log cannot be truncated past the oldest unreplicated transaction, the log may fill to a point where Msg 1105 will be encountered.

WORKAROUND

Find the row in MSjobs in the distribution database whose xactid_page and xactid_row match the values listed in the error message above. This row should contain the maximum job_id value for the table.

After you do this, update the values for xactid_page and xactid_row for this row to 0. It is recommended that you run the UPDATE statement with a BEGIN TRAN command so that you can rollback changes if you make a mistake. Make sure to execute COMMIT TRAN if the statement is successfully applied.

The simplest way to perform this update is:

   UPDATE MSjobs SET xactid_page = 0, xactid_row = 0
   WHERE  xactid_page = <xactid_page> AND  xactid_row = <xactid_row>

   where
   <xactid_page> and <xactid_row> are the values that are displayed in the
   LogReader error message <x,y>

FIX: LogReader Can Fail On sp_repldone Using Partitioning

ARTICLE-ID:Q138825 BUG# NT: 11636 (6.00)

SYMPTOMS

Under certain conditions using horizontal or vertical partitioning, the LogReader task for replication can fail with the following error:

   The replicated transaction (xxx, yyy) no longer exists in the log.
   Unable to execute sp_repldone on <server>.

CAUSE

This problem can occur if a transaction is run against a published article that does not meet the criteria of a horizontal or vertical partition. The LogReader task will fail and be shutdown in this situation. No replication transactions for the published database will be processed until the error is corrected. Since the log cannot be truncated past the oldest unreplicated transaction, the log may fill to a point where Msg 1105 will be encountered.

WORKAROUND

Find the row in MSjobs in the distribution database whose xactid_page and xactid_row match the values listed in the error message above. This row should contain the maximum job_id value for the table. Then update the values for xactid_page and xactid_row for this row to 0. It is recommended that you run the UPDATE statement with a BEGIN TRAN command so that you can rollback changes if you make a mistake.

Make sure to execute COMMIT TRAN if the statement is successfully applied. If the LogReader is setup as "Autostart," restart SQLExecutive. Otherwise, you may choose to execute the task "On Demand" to make sure it can run successfully. If the problem is resolved, the LogReader task will show up as a "Running Task" under SQL Enterprise Manager. However, it will not show a successful status in the Task History if you restarted SQLExecutive.

FIX: Timestamp Col of Temp Table Set to 0 When Inserting Row in SP

ARTICLE-ID:Q138848 BUG# NT: 11220 (6.00)

SYMPTOMS

When you insert a row inside a stored procedure (SP) into a temporary table that contains a timestamp column in a situation where the temporary table was created outside the SP and was deleted after the creation of the SP, the timestamp column is set to 0 when the SP is called.

WORKAROUND

If the SP gets called once after its creation and before the original table is dropped, the timestamp is set to a correct value in all subsequent calls.

FIX: AV or Error 632 on Update w/ Select Count(distinct) Subqu

ARTICLE-ID:Q138846 BUG# NT 11505 (6.00)

SYMPTOMS

A handled access violation (AV) or 632 error may be generated if an UPDATE statement is issued that sets a column in the update table equal to the "SELECT COUNT(DISTINCT column)" results of a subquery. The subquery must contain a comparison expression against a column which contains all null values.

The 632 error will generate the text:

   Error : 632, Severity 20, State 1
   Memmove() was called with a length of n - maximum allowed length is m.

WORKAROUND

Rewrite the query to eliminate the use of the COUNT(distinct) expression within the same statement as the comparison against the null column(s). A possible option would be to select the distinct results into a temporary table and perform futher manipulation on that data set.

FIX: Cursor Using Stored Proc After LOAD DB May Get 225 Error

ARTICLE-ID:Q140871 BUG# NT: 12136 (6.00)

SYMPTOMS

Opening a server-side cursor where the SELECT statement is a stored procedure may result in error 225:

   Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped
   during query optimization

CAUSE

If the stored procedure has not already been executed by itself prior to being used in the cursor, the re-resolution of the stored procedure leads to this error.

WORKAROUND

Execute the stored procedure outside the cursor prior to using it with a cursor after a LOAD DATABASE has taken place.

FIX: Inserts on SMP Computer Can Cause Error Message 1203

ARTICLE-ID:Q141539 BUG# NT: 11223 (6.00)

SYMPTOMS

If a table has a non-unique clustered index and is running on a multiprocessor computer with SMP support on, INSERTs can cause the following 1203 error message to occur:

   Msg  1203 Level 20 State 1
   Caller of lock manager is incorrectly trying to unlock an unlocked
   object. spid=%d locktype=%d dbid=%d lockid=%ld.

WORKAROUND

There are several options available to avoid this problem, including:

1. Turn off dedicated multiprocessor support to allow the INSERT to complete.

2. Replace the clustered index on the problem table with a nonclustered index.

3. Make the non-unique clustered index into a unique clustered index.

FIX: Stored Procedures Can Corrupt Themselves in Small Caches

ARTICLE-ID:Q141540 BUG# NT: 11322 (6.00)

SYMPTOMS

During the execution of a stored procedure, the following error messages could occur:

   Msg 2806, Level 18, State 0
   Stored procedure %s is corrupted.  Must re-create procedure.

   Msg 707, Level 20, State 9
   System error detected during attempt to free memory at address
   0xdcdcdcdc.

CAUSE

If the SQL Server procedure cache gets full, this can result in corrupt stored procedures. In addition to the cache being full, the stored procedures running need to be above 64 pages in size. Also, they need to be accessing temporary tables that were created outside the stored procedure.

WORKAROUND

You can avoid this problem by increasing the amount of memory available to the SQL Server procedure cache. This can be done by either altering the memory available to SQL Server or by increasing the percentage of SQL Server's memory available to the procedure cache.

FIX: A Cursor in a St. Procedure Can Cause an Access Violation

ARTICLE-ID:Q141541 BUG# NT: 11508 (6.00)

SYMPTOMS

A stored procedure that contains a cursor can cause an access violation if the following conditions are met:

1. The cursor needs to have an expression clause.

   executed again for the AV to occur.

WORKAROUND

Remove or change the expression clause to not be an expression clause. Remove the ORDER BY and do the sort another way using temporary tables, or sort the result set on your client. Do not drop the stored procedure and immediately recreate and execute it. If the stored procedure must be dropped, then drop the stored procedure and shut down and restart SQL Server; this will allow it to execute upon re-creation.

FIX: A View With an Outer Join Can Cause An Access Violation

ARTICLE-ID:Q141542 BUG# NT: 12004 (6.00)

SYMPTOMS

A SELECT against a view can result in the following error message:

   Msg 530, level 18, State 0
   Attempt to insert NULL value into column %d in work table (table id);
   column does not allow NULLS, UPDATE fails.

CAUSE

For this bug to occur, the view needs to meet the following conditions:

1. The SELECT clause needs to have a DISTINCT in it.

When SQL Server forms the outer join work table, it mistakenly puts NULLS in the work table where the bit field is. By definition, a bit field must be either 0 or 1, and in the case of a NULL it should default to 0; however, in this case it does not.

WORKAROUND

You can circumvent the problem by avoiding any one of the three conditions that must be present to cause it.

FIX: SELECT TEXT Columns with FOR BROWSE Holds sh_page Locks

ARTICLE-ID:Q141550 BUG# NT: 11535 (6.00)

SYMPTOMS

Using FOR BROWSE in a SELECT statement in a user-defined transaction holds shared page locks until the end of the transaction.

CAUSE

This problem occurs only when the TEXT datatype column is included in the SELECT list. The locks are not held until the end of the transaction when the TEXT datatype columns are not selected.

FIX: dbopen Memory Leak of 32K On Failed Login Attempt

ARTICLE-ID:Q139556 BUG# NT: 11480 (6.00)

SYMPTOMS

A call to dbopen with an invalid password or an attempt to establish an invalid trusted connection causes a 32K memory leak. The private bytes for the process will climb by 32K each time the dbopen fails. You may also see Process\Non-Paged Pool bytes increase. Continued leaks may cause Windows NT to run to a low virtual memory state.

WORKAROUND

Ensure that all login attempts are valid.

MORE INFORMATION

Some specific troubleshooting areas:

1. Check all passwords and password mappings. (Use the SQL Security Manager for mappings and the Control Panel Service application to verify startup information for the specific service.)

2. Enable failed and successful SQL Server logins. (Use the SQL Server Setup Security option.)

3. Logon as the secured user and use ISQL with the -E parameter to verify the user can establish a secured login.

4. Verify the net-library supports a trusted connection. (Use the SQL Server Client Configuration Utility to verify a named pipes or multi-protocol connection is being established.)

5. Verify the pipe name is correct. The pipe name must begin with \\.\pipe\... Anything else will cause an error when SQL Server attempts to create the pipe. Thus, named pipe connections will fail.

   Verify the pipe is opend by looking in the SQL Server errorlog.

6. Run SQLExecutive in debug mode. (sqlexec -c -v)

   **Specifically, retries of the replication processes can indicate failed

        logins.
   

FIX: SELECT From View w/ Data Length > 1962 Bytes May Hang Svr

BUG# NT: 12766 (6.00) ARTICLE-ID:Q147179

SYMPTOMS

A SELECT from a VIEW on a table that has a data length greater than 1962 bytes (a table created with VARCHAR datatype) may hang the server. The server will crash with the following error message:

   SQLSERVR.EXE   - Application error
   The exception Integer Division By Zero
   (0xc000094) at location 0x00513098

ADDENDUM: LIST OF PROBLEMS CORRECTED IN SERVICE PACK 1

For the complete description of these bugs, please see Knowledge Base article Q136575.

• FIX: Memory Leak in NTWDBLIB.DLL on Failed dbopen()
• FIX: ODBC 6.0 Driver Sometimes Cannot Get Results w/ dbmsspx3
• FIX: Updating a Text Column Results in a Table Scan
• FIX: Cannot Insert BLOB Data Larger Than 128k w/ SQLSetParam
• FIX: Repl Synch Fails with Table Names That Have Ext Chars
• FIX: EXECUTE Command w/ a Local Variable Can Cause Thread AV
• FIX: DUMP DATABASE w/ Variable Device Name in SP May Cause AV
• FIX: IN Condition with More Than 15 Values May Fail
• FIX: Unexpected Behavior During Object Resolution
• FIX: DBCC NEWALLOC Enhanced to use RA for Performance
• FIX: Query Plan Inconsistent If Search Value > Last Step
• FIX: Optimizer Hint for Index Name Fails in View
• FIX: Open Cursor Statement in SP Sets Variables to NULL
• FIX: Lvl 16 Error on Temp Tbl From SP w/ > 64 Pgs May Cause AV
• FIX: SELECT INTO w/ Correlated Subqueries May Cause AV
• FIX: DUMPs May Halt Queries With Triggers
• FIX: Create Worktable for Oversized Table Can Stop the Server
• FIX: ALTER TABLE Allows Nulls in PRIMARY KEY
• FIX: AV When Creating Reformat Plan of SP Containing Join
• FIX: Updating a Record w/ NULL Text Field Can Cause 2574 Error
• FIX: Add Constraint Causes Identity-Column Inserts to Fail
• FIX: Cannot Create a Qualified Table With a Check Constraint
• FIX: SET ARITHABORT ON Inadvertently Causes an Insert to Fail
• FIX: Cursor Declaration In a Stored Procedure Causes Client AV