Post reply

Stored procedure doesnt stop executing?

  • December 1, 2016 at 12:09 pm

    #332284

    There is stored procedure which show no error but keeps on executing with stop.I had placed some select statements to debug when i stop the browser after some time it display the values in temp table.But keeps on executing.I'm not able to see any error.

  • December 1, 2016 at 12:13 pm

    #1915547

    savibp3 (12/1/2016)

    There is stored procedure which show no error but keeps on executing with stop.I had placed some select statements to debug when i stop the browser after some time it display the values in temp table.But keeps on executing.I'm not able to see any error.

    If you run SP_WHO2 command, can you see the session that executed it, and what is indicated in the STATUS column?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • December 1, 2016 at 12:14 pm

    #1915548

    i'm running in sql browser doesn't support sp_who2

  • December 1, 2016 at 12:19 pm

    #1915552

    savibp3 (12/1/2016)

    i'm running in sql browser doesn't support sp_who2

    Are you the DBA for this server; can you connect to the instance using SSMS or SQLCMD and execute SP_WHO2 ?

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply