May 21, 2003 at 5:58 pm
What is the function call to give you the last sql command that was executed?
We are using a vb routine to call a stored procedure and it is bombing. If you take the same command and run it from tsql of course it works perfectly. The error message returned to the vb program leaves something to be desired and I'm trying to find out what was the command that caused it to fail. I hope that function will give me that.
May 21, 2003 at 9:23 pm
You could us profiler or you could use dbcc inputbuffer.
May 22, 2003 at 1:11 am
Hi,
have you tried the T-SQL Debugger from within VB?
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 22, 2003 at 5:53 am
After much testing last night - we realized that the stored procedure called by vb works correctly under SQL 2000 Service Pack 2. The customer applied SQL 2000 Service Pack 3 and now the stored procedure is broken. Any ideas what might be happening? The error is listed in the first post.
May 22, 2003 at 5:58 am
Oops - here is the actual error message returned.
[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply