Post reply

Multiuser Exception ???

  • May 21, 2009 at 3:14 am

    #132562

    All of a sudden one my scheduled SQL Server agent jobs is failing. All the job is doing is executing a single stored procedure.

    Msg 50000, Level 16, State 1, Procedure spTableTransaction_Update, Line 149

    Multiuser Exception

    Also running the stored procedure manually is giving the same error.

    SQL Server 2005 Standard Edition SP3 cum. patch 2 on Windows 2003 SP2.

    Any clues?

  • May 21, 2009 at 3:16 am

    #998125

    Is your database set to single user mode?

  • May 21, 2009 at 3:44 am

    #998132

    No (off course not)...

    Any other user activity is just running fine. I can also normally query the database.

    My first guess is that it is something within the procedure, but I haven't got any clue where to look for (since I can't find any information on this error, except checking for the single-user option).

  • May 21, 2009 at 3:46 am

    #998133

    That's not built-in SQL error. The error number (50000) indicates that it's being raised in that procedure. Take a look through that proc for code like this, and see what it is that triggers it.

    RAISERROR ('Multiuser Exception',16,1)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 21, 2009 at 3:52 am

    #998137

    Finally found it. The raiserror is in a nested procedure...

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

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