Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Insert seen in Profiler but still no data

Author  Topic 

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-13 : 15:46:49
I'm trying to help troubleshoot a site issue. I'm seeing Inserts coming from site through Profiler. Login has proper permissions. But Inserts are never committed. Site reloads with data missing. I've never seen commands come through profiler and not make it to db. Anyone know how this could happen?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-02-13 : 16:08:41
Actually, Profiler starts a trace on the target instance and reports what the trace spits out. So by the time you see it, the server already has it. Sounds like a different kind of problem
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-13 : 16:17:21
Which events do you have in the trace? Are they starting events? Or completed? If completed, are you seeing rollbacks?

Is there a delete trigger?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-17 : 13:00:51
I see it in SQL:BatchCompleted. I am not seeing any rollbacks (not really sure what that would look like). Also, I don't have any delete triggers on the table.
Go to Top of Page

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-17 : 14:13:20
If I run the Insert statements manually, they run fine.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-18 : 12:38:16
I would add more events to your trace: SP:StmtCompleted, SQL:StmtCompleted, Errors and Warnings - Exception, RPC:Completed. You might even want the Starting events.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -