-
fn_get_sql
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 ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|