Rogue Insert statement running
Posted on 2013-12-30
SqlServr.exe is eating up CPU time and choking the server. I ran a SLQ trace through Profiler and found a bulk insert statement that keeps running over and over. There is no replication to the affected table and no scripts that I have written to do this insert. The only update to the table happens via a SQL job overnight and it is showing idle. According to the trace output, the application name is Microsoft SQL Server and the user name and login account is a local admin account. How do I shut the insert down?
If there is another way to better identify the problem, let me know.