Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
Create TRIGGER [dbo].[tri_pfAudit_@tblName_INSERT] ON [dbo].[@tblName] AFTER INSERT AS Declare @x as XML --In select I need to check if text, and convert to varchar Select @x = (Select * from Inserted FOR XML AUTO, BINARY BASE64 , ELEMENTS, Root(''ROOT'')) Insert Table_Audit(TableName,txtXML,Action) Select ''@tblName'',@x,''I''
Join the community of 500,000 technology professionals and ask your questions.