medelstein (3/11/2010)

---

Hello,

I tried creating the runninSqlStatements stored procedure and it gives me a syntax error on this line:

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as qt

with this error:

Msg 102, Level 15, State 1, Procedure RunningSQLStatements, Line 9

Incorrect syntax near '.'.

Here is the entire sql I'm using:

Create Procedure RunningSQLStatements

as

Begin

Insert Into AuditTSQL (LoginName,SPID,DBName,ParentQuery,Wait,Program,HostName,StartTime,InsertedTime)

SELECT sp.loginame as [UserName],sp.spid as SPID , DB_NAME(sp.dbid) ,qt.text ,wait_type ,sp.program_name ,Hostname ,start_time ,convert(varchar(19),GETDATE(),120)

FROM sys.dm_exec_requests er

INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid

Inner Join sys.dm_exec_sessions es On er.session_id = es.session_id

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) as qt

WHERE es.is_user_process = 1

AND er.session_Id NOT IN (@@SPID)

ORDER BY sp.dbid, sp.loginame

End

Thanks,

Mike