sp_who execute rights for Developers | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sp_who execute rights for Developers

Hi, Is there any problem if sp_who or sp_who2 is used by Database Programmers. Is it strictly a dba-only function? Thanks
No is not strictly to dba, so no problem. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
IIRC, it does run into error if the current login does not have access to all databases on the server. Running it as EXEC <db_name>.dbo.sp_who should take care of that little problem.
]]>