Tuesday, January 4, 2011

Configuration for trace

Manual configuration:
Only enable "Events: RPC Completed"


then goto "Column fitlers"
Select "TextData" on the left site.


Click on 'like' and paste:
%@p_SYS_USERID=N'bastw'%


Click on 'not like' and paste (4 entries):
exec sp_executesql N'update std_queries%
exec sp_executesql N'--Get queryName%
exec sp_executesql N'SELECT * FROM Std_Users WHERE userID=@Userid AND password=@Password%
exec sp_executesql N'UPDATE Std_Users SET stamp%

No comments:

Post a Comment