InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 02:49:42 GMT20http://www.sqlservercentral.com/Forums/Topic487570-149-1.aspx[quote][b]onix-81 (4/19/2012)[/b][hr]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.[/quote]For Sybase I wouldn't know. This is a SQLServer oriented forum :discuss:Nowadays, many of us use Adam Machanics solution [url=http://sqlblog.com/files/folders/beta/entry42453.aspx]Who is Active[/url]Fri, 20 Apr 2012 01:07:34 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspxhi, 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.Thu, 19 Apr 2012 18:05:15 GMTonix-81http://www.sqlservercentral.com/Forums/Topic487570-149-1.aspxThe following dm views also need "View Server State" to functionsys.dm_exec_sessions sys.dm_exec_requests sys.dm_exec_connectionsTherefore these cannot be substituted for sp_who2 which also needs the same permission Thu, 12 Jun 2008 16:15:21 GMTdenise.crabtreehttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspxgrant VIEW SERVER STATE to xyz ;Check "GRANT Server Permissions " in BOL.Tue, 22 Apr 2008 06:04:56 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspxHow to give permission 'view system state' in sql 2005 ???Tue, 22 Apr 2008 04:08:46 GMTniranjankumar_khttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspx[font="Courier New"]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.[url=http://www.sql-articles.com/index.php?page=articles/database-management-views.html]Database Management Views & Functions - SQL 2005[/url][/font]Mon, 21 Apr 2008 06:24:13 GMTvidhya sagarhttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspx- 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 ?Sat, 19 Apr 2008 09:36:02 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic487570-149-1.aspxsp_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.Sat, 19 Apr 2008 00:28:10 GMTniranjankumar_k