SQL Server System Process Ids

  • Hi Frnds,

    Does SQL Server reserve few Process IDs (SPId in Sys.SysProcesses) for its use??. I have to confirm this since, I read somewhere that SPIDs <=51 are reserved for System Use. But today I noticed a User process getting executed @ SPId=51.

    Can someone confirm this..please...

    In ' Thoughts ',

    [font="Comic Sans MS"]Vampire[/font]

    --In 'thoughts'...
    Lonely Rogue

  • SPIDS <= 50 are reserved

    ---------------------------------------------------------------------

  • Thanks.

    Still In ' Thoughts ',

    [font="Comic Sans MS"]Vampire[/font]

    --In 'thoughts'...
    Lonely Rogue

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

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