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.
| 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 |
 |
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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. |
|
|
|
beatkeeper25
Starting Member
27 Posts |
Posted - 2015-02-17 : 14:13:20
|
| If I run the Insert statements manually, they run fine. |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Insert seen in Profiler but still no data