Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-01-05 : 08:14:22
|
| Marcelino writes "Hi folks!I have experienced some problems with execution of a Stored Procedure. This is the scenario:1) The instruction is called by a Visual Basic 6 Application like this"DataBaseConnection.Execute strSQL", where strSQL is a string that contain the Stored Procedure;2) The version of SQLServer is 7.0 (I don't Know what version of the Service Pack Applied). This is the error message that shows : Location: y:\SPHINX\NTDBMS\storeng\drs\oledb\rowsrort.h:757Expression: m_ecP == EcSPID: 8Process ID: 968PS: The machine where the application is executed, does not have a 'y' drive mapped;" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-05 : 08:27:35
|
| There are a few bugs that can cause thishttp://support.microsoft.com/default.aspx/kb/274266/EN-US/http://support.microsoft.com/default.aspx?scid=kb;EN-US;q263695A few things to tryMake sure you have the latest service packs.Set maxdop = 1Get rid of derived tables in favour of temp tables.What happens if you run the sp from query analyser.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Stored Procedure execution abort