Can anyone please guide me on how to create a stored procedure or a trigger that would be run every hour or in intervals, to check all the entire DB i.e. all the columns for any html tags (for e.g.< >),and if html tags have been stored in any colums, the procedure would strip the html tags.
thanks for the help