Ja, Stored Procedures darf er ausführen.
Hier das LogFile. Die Letzte Abfrage bringt keine Werte für nt_username hostname zurück.
EventClass StartTime TextData RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT … Audit Login 09.04.2015 13:38 -- network protocol: TCP/IP set quoted_identifier on set arithabort off set numeric_roundabort off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set cursor_close_on_commit off set implicit_transactions off set l SQL:BatchStarting 09.04.2015 13:38 select USER_NAME() select usertype,type,name from systypes where usertype>=257 SQL:BatchCompleted 09.04.2015 13:38 select USER_NAME() select usertype,type,name from systypes where usertype>=257 RPC:Completed 09.04.2015 13:38 exec sp_datatype_info 1 RPC:Completed 09.04.2015 13:38 exec sp_datatype_info 12 RPC:Completed 09.04.2015 13:38 exec sp_datatype_info -2 RPC:Completed 09.04.2015 13:38 exec sp_datatype_info -3 SQL:BatchStarting 2015-04-09 13:38:32.003 SET LOCK_TIMEOUT 10000 SQL:BatchCompleted 2015-04-09 13:38:32.003 SET LOCK_TIMEOUT 10000 SQL:BatchStarting 2015-04-09 13:38:32.023 SELECT DISTINCT nt_username FROM master..sysprocesses WHERE spid=@@spid SQL:BatchCompleted 2015-04-09 13:38:32.023 SELECT DISTINCT nt_username FROM master..sysprocesses WHERE spid=@@spid RPC:Completed 2015-04-09 13:38:32.040 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT DISTINCT blocked,WAITTIME FROM master..sysprocesses WHERE nt_username=@P1 AND blocked>0 ORDER BY Waittime DESC',N'@P1 varchar(128)','TestUser' RPC:Completed 09.04.2015 13:38 exec sp_executesql N'SELECT nt_username,hostname FROM master..sysprocesses WHERE spid=@P1 ',N'@P1 float',0
Hier nochmals das LogFile als Screenshot. :)