DEFINITIONS

Definitions More Info.
Definition ID217
TitleSQL
CategorySCRIPT
Definitionhangi sorgularin kimlerin cektigini,gecici gosteren sorgular
Definition Description--Most Recently Queries.. select st.text, client_net_address FROM sys.dm_exec_connections c CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) AS st --where LOWER(st.text) like '%companyaccount%' order by connect_time --Recently Executed Queries.. SELECT DMExQryStats.last_execution_time AS [Executed At], DMExSQLTxt.text AS [Query] FROM sys.dm_exec_query_stats AS DMExQryStats CROSS APPLY sys.dm_exec_sql_text(DMExQryStats.sql_handle) AS DMExSQLTxt where lower(DMExSQLTxt.text) like '%delete%companyaccount%' ORDER BY DMExQryStats.last_execution_time DESC
RecordBycunay
Record Date21-07-2012 19:17:29
Düzenle
Kopyala
Sil