Results 1 to 3 of 3

Thread: sp_who2

  1. #1
    Join Date
    Jun 2007
    Posts
    2

    Unanswered: sp_who2

    Hi,

    Can someone please provide sp_who2 proc for Sybase?

    Thank you.

  2. #2
    Join Date
    Feb 2007
    Location
    Chennai, TN
    Posts
    68
    Hi,
    What do u mean by sp_who2?. For what purpose you need that SP?. Can u be little bit clear

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Look at the source for sp_who2 and create your own version by selecting from sysprocesses.
    Your query will probably be
    SELECT spid ,status ,suser_name(suid) as loginname
    ,hostname ,blocked as BlkBy ,db_name(dbid) as DBName
    ,cmd ,cpu ,physical_io ,program_name ,spid
    from master.dbo.sysprocesses noholdlock
    order by spid

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •