code for good

To Get Except

select * from V_EMailDefaults except
(select distinct V_EMailDefaults.* from V_EMailDefaults
inner join #tempEntities on V_EMailDefaults.EmailType collate SQL_Latin1_General_CP1_CI_AS = #tempEntities.EmailType collate SQL_Latin1_General_CP1_CI_AS
and V_EMailDefaults.Language collate SQL_Latin1_General_CP1_CI_AS= #tempEntities.Language collate SQL_Latin1_General_CP1_CI_AS)) a

WHERE (Entity = 'default')
and EntityType = #ENTITYTYPE#
^ and EmailType = #EMAILTYPE# ^

resolve collation

inner join #tempEntities on V_EMailDefaults.EmailType collate SQL_Latin1_General_CP1_CI_AS = #tempEntities.EmailType collate SQL_Latin1_General_CP1_CI_AS

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%