FIX: RPC Using SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT May Cause AV

• Microsoft SQL Server version 7.0

SYMPTOMS

The SQL Server process may experience multiple exceptions, generally access violations (AVs), and/or may stop unexpectedly if the first invocation of a given procedure is an SQL remote procedure call (RPC) event using the SQL_PARAM_OUTPUT and SQL_PARAM_DEFAULT bindings during initial submittal.

WORKAROUND

To work around this problem, do either of the following:

• Update the application to avoid the use of the SQL_PARAM_DEFAULT option.
  
  -or-



• Drop and re-create the procedure, adding the WITH RECOMPILE directive to the creation script. The following is an example:
  

  
  create procedure spTest @strData char(80) = "RD"
  WITH RECOMPILE
  as
  begin
     select 1
  end 

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.Microsoft has confirmed this to be a problem in SQL Server version 7.0. This problem has been corrected in U.S. Service Pack 1 for Microsoft SQL Server version 7.0. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: abnormal termination terminate terminated

Keywords : SSrvGPF kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug