Post reply

raise error errors

  • July 14, 2006 at 12:35 pm

    #61455

    Wfhen the following is run it generates the error below .your help is appreciated

    raiserror  

       ('The  user with login :%S , running the program : %s has been blocked for more than 90 seconds and the original blocker has spid %s', 16, 1, @loginame1, @program_name1,@spid1)

    with log

    %s  and %d are all valid values

     

    Thanks as usual

    RAISERROR failed due to invalid parameter substitution(s) for error 50000, severity 16, state 1.

    Server: Msg 2757, Level 16, State 1, Line 32

  • July 14, 2006 at 1:32 pm

    #649364

    You are using %s for your @spid1 which is an integer.  Try using @d instead.

    raiserror  

       ('The  user with login :%S , running the program : %s has been blocked for more than 90 seconds and the original blocker has spid %d', 16, 1, @loginame1, @program_name1,@spid1)

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Viewing 2 posts - 1 through 1 (of 1 total)

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