I want to find out how data is getting inserted to a particular table.
I mean to say I want to find out the job or Stored Proc which is running on my SQL Server and pushing data regularly into one of my tables.
Copied from a Stack Overflow answer by Damian Leszczyński - Vash, could not find a duplicate here:
You can't set filter to trace specific table directly.
What you can do is specify a filter for
File -> Properties -> Event Selection -> Column Filters -> TextData -> Like -> [Table Name]
Your other option is to use Extended Events, but it has a much higher learning curve. Be careful using Profiler in production. The way it reads the data has a very high overhead and it could also cause the client you're using to time out.
You could use a 'server side trace' but that also has a higher learning overhead. Use Profiler in prod at your own risk, and make sure you don't run the client on an important server.