FIX: DUMP DATABASE w/ Variable Device Name in SP May Cause AV

ID: Q133039


The information in this article applies to:
  • Microsoft SQL Server version 6.0


SYMPTOMS

DUMP DATABASE to a device that uses the format


   dump_device = @dump_device_namevar 
causes a handled access violation if used within a stored procedure.


WORKAROUND

When used outside of a stored procedure the commands work fine. Hard coding a device file path also works correctly.


STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.


MORE INFORMATION

The following commands demonstrate the problem:


   drop procedure sp_dumpdb
   go
   create procedure sp_dumpdb
   as
   declare @lc_dumpdev char(30)
   select @lc_dumpdev="d:\pubs.dmp"
   dump database pubs to disk=@lc_dumpdev
     if  @@error=0
       return(0)
     else
       return(1)
   go
   sp_dumpdb
   go 

Additional query words: sql6 dump database

Keywords : kbother SSrvProg kbbug6.00 kbfix6.00.sp1 SSrvWinNT
Version : winnt:6.0
Platform : winnt
Issue type :


Last Reviewed: December 14, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.