In a SQL production environment it can happen that you see heavy transactions. With next query you can retrieve the TSQL statement of a process you see in master..sysprocesses.
SELECT Text,hostname, program_name, nt_username,*
FROM Master..sysprocesses
CROSS APPLY sys.dm_exec_sql_text (sql_handle)
WHERE Spid > 50
You can extend the WHERE clause with SPID = XX or something else you wnat to filter on.
Tuesday, July 16, 2013
Subscribe to:
Post Comments (Atom)
2 comments:
A well-written medical school personal statement is your first initial "interview" when applying. Here are some important things to consider that make your admissions packet stand out from the rest. research statement biology
Harus kita akui memang perkembangan agen domino online di Indonesia ini sangat pesat sekali hingga sekarang, tapi yang harus kita pastikan dengan benar adalah apakah
asikqq
pionpoker
dewaqq
bandar ceme
sumoqq
hobiqq
paito warna
interqq
forum prediksi
Post a Comment