-2

How can I find out what triggers are fired and what sql functions (system+user) are called or what views are updated and what all tables got updated when i fire a update query in ssms? Basically, I need an information about what all happened in the database when i fire an updated query. Is there any process to find out???

Rahul Dev
  • 141
  • 2
  • 17

1 Answers1

1

SQL Server Profiler may help with this. The accepted answer on this question linked by SchmitzIT will explain more: How can I see which tables are changed in SQL Server?

Osher Shuman
  • 213
  • 3
  • 7