Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
CREATE TRIGGER fr_frame_audit AFTER INSERT OR UPDATE OR DELETE ON fr_frame FOR EACH ROW EXECUTE PROCEDURE audit.if_modified_func();
In the example above, I created a trigger for auditing table ‘fr_frame’ (of course you can create a sp procedure to generate these statements, if you want to generate a trigger for auditing every table in the database…
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|How to loop thru all queries and find which one's were affected by a table change.||47||73|
|The database principal owns a schema in the database, and cannot be dropped.||2||21|
|vb.net - trying to add a Column to a Table using Visual Studio 2013 xsd Designer||2||15|
Join the community of 500,000 technology professionals and ask your questions.