Post reply

find a function call

  • May 21, 2003 at 5:58 pm

    #159150

    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

    #458085

    You could us profiler or you could use dbcc inputbuffer.

  • May 22, 2003 at 1:11 am

    #458092

    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

    #458129

    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

    #458130

    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