DECLARE @Handle binary(20)
SELECT @handle=sql_handle
FROM master..sysprocesses
WHERE spid= 60

SELECT * FROM ::fn_get_sql(@handle)

When l use fn_get_sql l only get a aprt of the script that is being run. How can l get the whole script or prcedure to be displayed ?

Second Question :

Is there a way to track dropped objects, commands like delete,truncate at database level in sql and log these events into a table ?