problem with SQL Server 2005 sp called from VC++ 6.0
- From: vg <vgolden2002@xxxxxxxxx>
- Date: Mon, 8 Sep 2008 13:21:02 -0700 (PDT)
Dear all -
We run into a very strange problem. We have a very large & complex SQL
Server 2005 stored procedure with a number of temp tables and
cursors.
The logic in this sp is written as such - it truncates a permanent
table in the database, inserts 360 rows into it, than executes the
logic and updates all columns and rows (using cursors from temp
tables) in this table.
When we run it within SQL Server Management Studio - basically doing
"exec sp_xxx" it works just fine. When we're trying to run the same sp
from VC++ (ultimately using SQLExecDirect call) strange things are
happening. Permanent table that is used to hold results gets
truncated, rows are inserted, temp tables are created and populated,
but than SQL Server literally 'ignores' all updates that are sitting
inside cursors. After that sp returns with no error code!
Any ideas or similar experience anyone?
Any help is greatly appreciated.
.
- Prev by Date: Re: Help-a-Dummy Please
- Next by Date: managed code/unmanaged code...What's the difference???
- Previous by thread: CoInitializeSecurity: Impersonation level for code hosted in a surrogate
- Next by thread: managed code/unmanaged code...What's the difference???
- Index(es):
Relevant Pages
|
