Microsoft KB Archive/133039

{|
 * width="100%"|

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

 * }

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

Issue type : kbbug

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600