SQL Server Performance Forum – Threads Archive
sp_who execute rights for DevelopersHi, 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
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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.