BUG: Extended Stored Proc Call May Generate a Thread AV (139557)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q139557
BUG# NT: 11515 (4.21a.SP4)
SYMPTOMS
When you use an extended stored procedure to return data to an output
parameter a thread access violation can occur.
The following query exposes the behavior:
declare @strData varchar(255)
exec xp_echo "Test", @strData OUTPUT
The procedure xp_echo is the sample provided in the XP.DLL file.
WORKAROUND- Stop SQL Server.
- Copy the SQLSERVR.EXE file from the SQL Server Service Pack 3 to the
..\SQL\BINN directory.
- Restart SQL Server.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 4.21a Service Pack 4. We are researching this problem and will post
new information here in the Microsoft Knowledge Base as it becomes
available.
| Modification Type: | Major | Last Reviewed: | 4/21/1999 |
|---|
| Keywords: | kbprogramming KB139557 |
|---|
|