sp_who2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » sp_who2

sp_who2

Rate Topic

Display Mode

Topic Options

Author

Message

niranjankumar_k

Posted Saturday, April 19, 2008 12:28 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2008 11:51 PM
Points: 41, Visits: 119

sp_who2 shows the block by user and some information.Currently we are moving from sql 2000 to sql 2005. if i execute the sp_who2 in sql 2005 it shows only my login block information. it does not show other users. is there any admin rights has to give to view other block user ??? how to do that.

Post #487570

ALZDBA

Posted Saturday, April 19, 2008 9:36 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

- with sql2005 you can only see the data you are entitled to.
- you need to grant 'view system state' to see it all.
Do you realy need to do that ?

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

- How to post Performance Problems
- How to post data/code to get the best help

- How to prevent a sore throat after hours of presenting ppt ?

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #487588

vidhya sagar

Posted Monday, April 21, 2008 6:24 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

In SQL 2005 you can make use catalog views or DMV's for the same. You will get more information compared to sp_who2.. Users need view server state permission. Refer the below link.

Database Management Views & Functions - SQL 2005

Regards..Vidhya Sagar
SQL-Articles

Post #487894

niranjankumar_k

Posted Tuesday, April 22, 2008 4:08 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, July 24, 2008 11:51 PM
Points: 41, Visits: 119

How to give permission 'view system state' in sql 2005 ???

Post #488460

ALZDBA

Posted Tuesday, April 22, 2008 6:04 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

grant VIEW SERVER STATE to xyz ;

Check "GRANT Server Permissions " in BOL.

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #488528

denise.crabtree

Posted Thursday, June 12, 2008 4:15 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:30 PM
Points: 50, Visits: 61

The following dm views also need "View Server State" to function

sys.dm_exec_sessions
sys.dm_exec_requests
sys.dm_exec_connections

Therefore these cannot be substituted for sp_who2 which also needs the same permission

Post #516317

onix-81

Posted Thursday, April 19, 2012 6:05 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 19, 2012 6:03 PM
Points: 1, Visits: 0

hi, i'm new in this forum but i have a question, where i can find the sp_who2 script for sybase V15.5? thanks a lot.

Post #1286808

ALZDBA

Posted Friday, April 20, 2012 1:07 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 2:17 AM
Points: 6,862, Visits: 8,049

onix-81 (4/19/2012)

hi, i'm new in this forum but i have a question, where i can find the sp_who2 script for sybase V15.5? thanks a lot.

For Sybase I wouldn't know. This is a SQLServer oriented forum Discuss

Nowadays, many of us use Adam Machanics solution Who is Active

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me Hehe

Post #1286911

« Prev Topic | Next Topic »

Permissions