Records getting deleted from SQL Server 2000 with Access linked Tables

I hope someone can help in solving this problem. I have a VB
application that is accessing data from SQL server 2000 through linked
tables in MS Access. It all works very well, except every once in a
while, a record gets deleted from SQL Tables. I know for sure that the
end user is not deleting it, and I am pretty sure its not a bug in the
VB code. I have delete triggers placed, to trap the deleted record and
the time it's deleted. But I have no idea how or why gets deleted. Any
ideas or help on this will really be appreciated.
Thanks<razisyed@.sbcglobal.net> wrote in message
news:1149805102.464734.305140@.j55g2000cwa.googlegroups.com...
>I hope someone can help in solving this problem. I have a VB
> application that is accessing data from SQL server 2000 through linked
> tables in MS Access. It all works very well, except every once in a
> while, a record gets deleted from SQL Tables. I know for sure that the
> end user is not deleting it, and I am pretty sure its not a bug in the
> VB code. I have delete triggers placed, to trap the deleted record and
> the time it's deleted. But I have no idea how or why gets deleted. Any
> ideas or help on this will really be appreciated.
> Thanks
>
Use SQL Profiler to capture the actual statement being executed. Hopefully
that should give you enough to figure out where the problem is.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||I actually used SQL profiler, and tracked the transactions at the time
of deletion. But I have no idea what any of the entries mean. It has
several errors in it, but I can't find what it means. Besides, those
errors were tracked in the Profiler all the time. The record delete
time was 5/16/2006 3:46:14 PM. Here is what SQL Profiler recorded: I
hope you or someone can make sense out of it. Thanks.
Row Number Event Class Text Data Transaction ID NTUserName Application
Name Login Name SPID Duration Start Time Reads Writes CPU
3903047 10 exec sp_cursorfetch 180150000, 16, 17,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.003 10 0 0
3903048 10 exec sp_execute 2, 263 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.003 2 0 0
3903049 10 exec sp_execute 2,
778 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.003 2 0 0
3903050 10 exec
sp_reset_connection NULL NULL 496 Main s
tate 256 0 2006-05-16
15:46:14.020 0 0 0
3903051 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.020 NULL NULL NULL
3903052 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.020 NULL NULL NULL
3903053 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N'exec Reminders', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.020 16 0 0
3903054 10 exec sp_execute 2,
1849 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.020 2 0 0
3903055 10 exec sp_cursorfetch 180150000, 16, 18,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.020 10 0 0
3903056 10 exec sp_execute 5, 22 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.020 2 0 0
3903057 10 exec sp_execute 2, 264 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.020 2 0 0
3903058 10 exec sp_execute 1,
814 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.037 1 0 0
3903059 10 exec sp_execute 2,
1737 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.037 2 0 0
3903060 10 exec sp_execute 5, 23 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.037 2 0 0
3903061 10 exec sp_execute 2,
779 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.037 2 0 0
3903062 10 exec sp_execute 2, 265 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.050 2 0 0
3903063 10 exec sp_cursorfetch 180150000, 16, 19,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.050 10 0 0
3903064 10 exec sp_execute 2,
1850 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.050 2 0 0
3903065 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.050 NULL NULL NULL
3903066 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.050 NULL NULL NULL
3903067 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N' EXEC Reminders ', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.050 16 0 0
3903068 10 exec sp_execute 5, 24 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.067 2 0 0
3903069 10 exec sp_execute 2, 266 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.067 2 0 0
3903070 10 exec sp_execute 2,
780 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.083 2 0 0
3903071 10 exec sp_execute 5, 25 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.083 2 0 0
3903072 10 exec sp_cursorfetch 180150000, 16, 20,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.083 10 0 0
3903073 10 exec sp_execute 2,
1851 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.083 2 0 0
3903074 10 exec sp_unprepare 4 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.100 0 0 0
3903075 10 exec sp_execute 2,
1247 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.100 2 0 0
3903076 10 exec sp_execute 2, 267 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.113 2 0 0
3903077 10 exec sp_execute 1,
815 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.113 1 0 0
3903078 10 exec sp_cursorfetch 180150000, 16, 21,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.113 10 0 0
3903079 10 exec sp_execute 2,
781 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.113 2 0 0
3903080 15 NULL NULL NULL 128 Main state
133 763 2006-05-16
15:46:13.350 21 0 0
3903081 10 exec sp_unprepare 1 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.113 0 0 0
3903082 10 exec sp_execute 2,
1853 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.113 2 0 0
3903084 10 exec sp_cursorfetch 180150000, 16, 22,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.130 10 0 0
3903085 10 exec sp_execute 2, 268 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.130 2 0 0
3903086 10 exec sp_execute 2,
782 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.147 2 0 0
3903087 10 exec sp_execute 2,
1248 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.147 2 0 0
3903088 10 exec sp_execute 2,
1855 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.160 2 0 0
3903089 10 exec sp_cursorfetch 180150000, 16, 23,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.160 10 0 0
3903090 10 declare @.P1 int set @.P1=180150000 declare @.P2 int set @.P2=1
declare @.P3 int set @.P3=16388 declare @.P4 int set @.P4=7206 exec
sp_cursoropen @.P1 output, N'select * from Reminders', @.P2 output, @.P3
output, @.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 76 2006
-05-16 15:46:14.083 36263 0 78
3903091 10 exec sp_execute 2, 269 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.177 2 0 0
3903092 10 exec sp_execute 2,
783 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.177 2 0 0
3903093 10 exec sp_execute 1,
817 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.177 1 0 0
3903094 10 exec sp_cursorfetch 180150000, 16, 24,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.193 10 0 0
3903095 10 exec sp_execute 2,
1856 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.193 2 0 0
3903096 14 -- network protocol: TCP/IP set quoted_identifier on set
implicit_transactions off set cursor_close_on_commit off set
ansi_warnings on set ansi_padding on set ansi_nulls on set
concat_null_yields_null on set language us_english set dateformat mdy
set datef NULL NULL 128 Microsoft Office 2003 state 75 NULL 2006-05-16
15:46:14.193 NULL NULL NULL
3903097 10 exec sp_execute 2, 270 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.193 2 0 0
3903098 10 exec sp_execute 2,
1249 NULL NULL 1548 Sync state 197 13 20
06-05-16 15:46:14.193 2 0 16
3903099 50 NULL 107461898 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903100 54 NULL 107461898 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903101 54 NULL 107461898 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903102 50 NULL 107461898 NULL 0 NULL sa
5 0 2006-05-16
15:46:14.207 NULL NULL NULL
3903103 54 NULL 107461898 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903104 50 NULL 107461900 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903105 50 NULL 107461900 NULL 0 NULL sa
5 0 2006-05-16
15:46:14.207 NULL NULL NULL
3903106 50 NULL 107461901 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903107 50 NULL 107461901 NULL 0 NULL sa
5 0 2006-05-16
15:46:14.207 NULL NULL NULL
3903108 50 NULL 107461902 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903109 54 NULL 107461902 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903110 50 NULL 107461902 NULL 0 NULL sa
5 0 2006-05-16
15:46:14.207 NULL NULL NULL
3903111 54 NULL 107461902 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903112 50 NULL 107461915 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903113 54 NULL 107461915 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903114 54 NULL 107461915 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903115 50 NULL 107461915 NULL 0 NULL sa
5 0 2006-05-16
15:46:14.207 NULL NULL NULL
3903116 54 NULL 107461915 NULL 0 NULL sa
5 NULL 2006-05-16
15:46:14.207 NULL NULL NULL
3903117 10 exec sp_cursoroption 180150000, 1,
0 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.207 0 0 0
3903118 10 exec sp_cursorfetch 180150000, 16, 1,
1 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.207 18 0 0
3903119 10 exec sp_cursorfetch 180150000, 16, 25,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.207 10 0 0
3903120 10 exec sp_execute 2,
784 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.207 2 0 0
3903121 10 exec sp_execute 2, 271 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.223 2 0 0
3903122 12 SELECT "dbo"."Reminders"."reminderID" FROM "dbo"."Reminders"
WHERE (NOT(("remind" = 0 ) ) AND ("remDate" <= {d '2006-05-16'} ) )
NULL NULL 128 Microsoft Office 2003 state 75 0 2006-05-16
15:46:14.223 119 0 0
3903123 10 exec sp_execute 2,
1909 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.223 2 0 0
3903124 10 exec sp_execute 2, 272 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.240 2 0 0
3903125 12 SET TEXTSIZE 2147483647 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.240 0 0 0
3903126 10 exec sp_cursorfetch 180150000, 16, 26,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.240 10 0 0
3903127 50 NULL 107461940 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903128 54 NULL 107461940 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903129 54 NULL 107461940 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903130 50 NULL 107461940 NULL 496 Main
state 256 0 2006-05-16
15:46:14.253 NULL NULL NULL
3903131 50 NULL 107461945 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903132 54 NULL 107461945 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903133 54 NULL 107461945 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903134 50 NULL 107461945 NULL 496 Main
state 256 0 2006-05-16
15:46:14.253 NULL NULL NULL
3903135 54 NULL 107461945 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903136 54 NULL 107461940 NULL 496 Main
state 256 NULL 2006-05-16
15:46:14.253 NULL NULL NULL
3903137 10 exec sp_cursor 180150000, 4, 0, N'Reminders', @.postDate =
'May 16 2006 12:00AM', @.remDate = 'May 16 2006 12:00AM', @.remind = 0,
@.quoteFollow = 0, @.quoteDate = 'May 17 2006 12:00AM', @.impDate = 'May
16 2006 12:00AM' NULL NULL 496 Main state 256 0
2006-05-16
15:46:14.253 18 0 0
3903138 10 exec sp_execute 2,
775 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.253 2 0 0
3903139 10 exec sp_execute 2,
1250 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.253 2 0 0
3903140 10 exec sp_execute 1,
818 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.253 1 0 0
3903141 10 exec sp_execute 2, 273 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.253 2 0 0
3903142 10 exec sp_execute 2,
1871 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.253 2 0 0
3903143 10 declare @.P1 int set @.P1=6 exec sp_prepexec @.P1 output, N'@.P1
int', N'SELECT
"reminderID","AgentID","ClientID","CompanyID","postDate","remDate","comDate"
,"done","remind","category","critical","quoteFollow","quoteDate","paymentFol
low","paymentDate","renewFol NULL NULL 128 Microsoft
Office 2003 state 253 0 2006-05-16 15:46:14.253 12 0 0
3903144 10 exec sp_cursorclose
180150000 NULL NULL 496 Main state 256 0
2006-05-16 15:46:14.287 15 0 0
3903145 10 exec sp_execute 2, 274 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.287 2 0 0
3903146 10 exec sp_execute 2,
838 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.287 2 0 0
3903147 10 exec sp_execute 2,
1939 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.300 2 0 0
3903148 10 exec sp_execute 2,
1251 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.300 2 0 0
3903149 10 exec sp_execute 2, 275 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.300 2 0 0
3903150 10 exec
sp_reset_connection NULL NULL 496 Main s
tate 158 0 2006-05-16
15:46:14.317 0 0 0
3903151 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.317 NULL NULL NULL
3903152 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.317 NULL NULL NULL
3903153 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N'exec Commissions', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.317 16 0 0
3903154 10 exec sp_execute 2,
840 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.317 2 0 0
3903155 10 exec sp_execute 2,
1940 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.333 2 0 0
3903156 10 exec sp_execute 2, 276 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.333 2 0 0
3903157 10 exec sp_execute 1,
819 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.333 1 0 0
3903158 10 exec sp_execute 6, 807 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.333 6 0 0
3903159 10 exec sp_execute 6, 807 NULL NULL 128 Microsoft Office
2003 state 253 0 2006-05-16 15:46:14.350 6 0 0
3903160 10 exec sp_execute 2,
1252 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.350 2 0 0
3903161 10 exec sp_execute 2,
841 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.350 2 0 0
3903162 10 exec sp_execute 2, 277 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.350 2 0 0
3903163 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.350 NULL NULL NULL
3903164 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.350 NULL NULL NULL
3903165 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N' EXEC Commissions ', @.P2 output, @.P3
output, @.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.350 16 0 0
3903166 10 exec sp_execute 2,
1941 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.363 2 0 0
3903167 10 exec sp_execute 2, 278 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.380 2 0 0
3903168 10 exec sp_execute 2,
842 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.380 2 0 0
3903169 10 exec sp_execute 2,
1942 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.397 2 0 0
3903170 10 exec sp_execute 2, 279 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.397 2 0 0
3903171 10 exec sp_execute 1,
822 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.397 1 0 0
3903172 10 exec sp_execute 2,
1253 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.397 2 0 0
3903173 10 exec sp_execute 2,
843 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.427 2 0 0
3903174 10 exec sp_execute 2, 280 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.427 2 0 0
3903175 10 exec sp_execute 2,
1943 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.427 2 0 0
3903176 10 exec sp_execute 2, 281 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.457 2 0 0
3903177 10 exec sp_execute 2,
1254 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.457 2 0 0
3903178 10 exec sp_execute 2,
844 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.457 2 0 0
3903179 10 exec sp_execute 2,
1944 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.473 2 0 0
3903180 10 exec sp_execute 1,
823 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.473 1 0 0
3903181 10 declare @.P1 int set @.P1=180150000 declare @.P2 int set @.P2=1
declare @.P3 int set @.P3=16388 declare @.P4 int set @.P4=8128 exec
sp_cursoropen @.P1 output, N'select * from Commissions', @.P2 output, @.P3
output, @.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 158 76 2006
-05-16 15:46:14.397 40923 0 78
3903182 10 exec sp_execute 2, 282 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.490 2 0 0
3903183 10 exec sp_execute 2,
845 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.490 2 0 0
3903184 10 exec sp_execute 2,
1945 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.503 2 0 0
3903185 10 exec sp_cursorfetch 180150000, 16, 27,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.503 10 0 0
3903186 10 exec sp_execute 2,
1255 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.503 2 0 0
3903187 10 exec sp_execute 2, 283 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.503 2 0 0
3903188 10 exec sp_cursoroption 180150000, 1,
0 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.520 0 0 0
3903189 10 exec sp_cursorfetch 180150000, 16, 1,
1 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.520 18 0 0
3903190 10 exec sp_execute 2,
847 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.520 2 0 0
3903191 10 exec sp_execute 2, 284 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.537 2 0 0
3903192 10 exec sp_cursorfetch 180150000, 16, 28,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.537 10 0 0
3903193 10 exec sp_execute 2,
1946 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.537 2 0 0
3903194 10 exec sp_execute 2, 285 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.550 2 0 0
3903195 10 exec sp_execute 2,
848 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.550 2 0 0
3903196 50 NULL 107462026 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903197 10 exec sp_execute 2,
1256 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.550 2 0 0
3903198 54 NULL 107462026 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903199 54 NULL 107462026 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903200 54 NULL 107462026 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903201 50 NULL 107462026 NULL 496 Main
state 158 0 2006-05-16
15:46:14.550 NULL NULL NULL
3903202 50 NULL 107462031 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903203 54 NULL 107462031 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903204 54 NULL 107462031 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903205 50 NULL 107462031 NULL 496 Main
state 158 0 2006-05-16
15:46:14.550 NULL NULL NULL
3903206 54 NULL 107462031 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903207 54 NULL 107462026 NULL 496 Main
state 158 NULL 2006-05-16
15:46:14.550 NULL NULL NULL
3903208 10 exec sp_cursor 180150000, 4, 0, N'Commissions', @.Transaction
= N'New Business', @.paid = 0, @.rec = 0, @.pdDate = 'May 16 2006
12:00AM', @.pdCheckNum = N'', @.Notes =
N'' NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.550 23 0 0
3903209 10 exec sp_cursorfetch 180150000, 16, 29,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.550 10 0 0
3903210 10 exec sp_execute 1,
827 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.567 1 0 0
3903211 10 exec sp_execute 2,
1947 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.567 2 0 0
3903212 10 exec sp_execute 2, 286 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.583 2 0 0
3903213 10 exec sp_cursorfetch 180150000, 16, 30,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.583 10 0 0
3903214 10 exec sp_execute 2,
849 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.583 2 0 0
3903215 10 exec sp_cursorclose
180150000 NULL NULL 496 Main state 158 0
2006-05-16 15:46:14.583 18 0 0
3903216 10 exec sp_execute 2, 287 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.600 2 0 0
3903217 10 exec sp_execute 2,
1949 NULL NULL 1180 Sync state 69 13 200
6-05-16 15:46:14.600 2 0 15
3903218 10 exec sp_cursorfetch 180150000, 16, 31,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.613 10 0 0
3903219 10 exec sp_execute 2,
1257 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.613 2 0 0
3903220 10 exec sp_execute 2, 288 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.630 2 0 0
3903221 10 exec sp_execute 2,
850 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.630 2 0 0
3903222 10 exec
sp_reset_connection NULL NULL 496 Main s
tate 256 0 2006-05-16
15:46:14.630 0 0 0
3903223 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.630 NULL NULL NULL
3903224 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.630 NULL NULL NULL
3903225 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N'exec Commissions', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.630 16 0 0
3903226 10 exec sp_cursorfetch 180150000, 16, 32,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.630 10 0 0
3903227 10 exec sp_execute 2,
1950 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.647 2 0 0
3903228 10 exec sp_execute 2, 289 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.647 2 0 0
3903229 10 exec sp_execute 2,
823 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.660 2 0 0
3903230 10 exec sp_execute 2,
1258 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.660 2 0 0
3903231 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.660 NULL NULL NULL
3903232 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 256 NULL 2006
-05-16
15:46:14.660 NULL NULL NULL
3903233 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N' EXEC Commissions ', @.P2 output, @.P3
output, @.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.660 16 0 0
3903234 10 exec sp_cursorfetch 180150000, 16, 33,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.660 10 0 0
3903235 10 exec sp_execute 2, 290 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.660 2 0 0
3903236 10 exec sp_execute 2,
1951 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.677 2 0 0
3903237 10 exec sp_execute 1,
828 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.677 1 0 0
3903238 10 exec sp_execute 2,
716 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.693 2 0 0
3903239 10 exec sp_cursorfetch 180150000, 16, 34,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.693 10 0 0
3903240 10 exec sp_execute 2, 291 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.693 2 0 0
3903241 10 exec sp_execute 2,
1952 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.707 2 0 0
3903242 10 exec sp_execute 2,
1259 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.707 2 0 0
3903243 10 exec sp_cursorfetch 180150000, 16, 35,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.723 10 0 0
3903244 10 exec sp_execute 2, 292 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.723 2 0 0
3903245 10 exec sp_execute 2,
864 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.723 2 0 0
3903246 10 exec sp_execute 2,
1541 NULL NULL 1180 Sync state 69 0 2006
-05-16 15:46:14.740 2 0 0
3903247 10 exec sp_cursorfetch 180150000, 16, 36,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.753 10 0 0
3903248 10 exec sp_execute 2,
865 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.753 2 0 0
3903249 10 exec sp_execute 1,
829 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.753 1 0 0
3903250 10 exec sp_execute 2,
1286 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.753 2 0 0
3903251 10 exec sp_cursorfetch 180150000, 16, 37,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.787 10 0 0
3903252 10 declare @.P1 int set @.P1=180150000 declare @.P2 int set @.P2=1
declare @.P3 int set @.P3=16388 declare @.P4 int set @.P4=8129 exec
sp_cursoropen @.P1 output, N'select * from Commissions', @.P2 output, @.P3
output, @.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 256 93 2006
-05-16 15:46:14.693 40928 0 94
3903253 10 exec sp_execute 2,
866 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.787 2 0 0
3903254 10 exec sp_cursorfetch 180150000, 16, 38,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.800 10 0 0
3903255 10 exec sp_execute 2,
1287 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.817 2 0 0
3903256 10 exec sp_execute 2,
867 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.817 2 0 0
3903257 10 exec sp_cursoroption 180150000, 1,
0 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.817 0 0 0
3903258 10 exec sp_cursorfetch 180150000, 16, 1,
1 NULL NULL 496 Main state 256 0 2006-05-16 15:46:14.817 18 0 0
3903259 10 exec sp_cursorfetch 180150000, 16, 39,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.833 10 0 0
3903260 10 exec sp_execute 1,
830 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.833 1 0 0
3903261 10 exec sp_cursorfetch 180150000, 16, 40,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.850 10 0 0
3903262 10 exec sp_execute 2,
868 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.863 2 0 0
3903263 10 exec sp_cursorclose
180150000 NULL NULL 496 Main state 256 0
2006-05-16 15:46:14.863 18 0 0
3903264 10 exec sp_execute 2,
1288 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.863 2 0 0
3903265 10 exec sp_cursorfetch 180150000, 16, 41,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.880 10 0 0
3903266 10 exec sp_execute 2,
869 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.897 2 0 0
3903267 10 exec
sp_reset_connection NULL NULL 496 Main s
tate 158 0 2006-05-16
15:46:14.897 0 0 0
3903268 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.897 NULL NULL NULL
3903269 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.897 NULL NULL NULL
3903270 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N'exec Reminders', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.897 16 0 0
3903271 10 exec sp_cursorfetch 180150000, 16, 42,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.910 10 0 0
3903272 10 exec sp_execute 2,
1289 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.910 2 0 0
3903273 10 exec sp_execute 1,
831 NULL NULL 3152 Sync castle 266 0 200
6-05-16 15:46:14.927 1 0 0
3903274 10 exec sp_execute 2,
870 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.927 2 0 0
3903275 33 Error: 2809, Severity: 18, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.927 NULL NULL NULL
3903276 33 Error: 16945, Severity: 16, State:
1 NULL NULL 496 Main state 158 NULL 2006
-05-16
15:46:14.927 NULL NULL NULL
3903277 10 declare @.P1 int set @.P1=0 declare @.P2 int set @.P2=98305
declare @.P3 int set @.P3=311300 declare @.P4 int set @.P4=0 exec
sp_cursoropen @.P1 output, N' EXEC Reminders ', @.P2 output, @.P3 output,
@.P4 output select @.P1, @.P2, @.P3,
@.P4 NULL NULL 496 Main state 158 0 2006-05-16 15:46:14.927 16 0 0
3903278 10 exec sp_cursorfetch 180150000, 16, 43,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.943 10 0 0
3903279 10 exec sp_execute 2,
871 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.957 2 0 0
3903280 10 exec sp_execute 2, 293 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.957 2 0 0
3903281 10 exec sp_execute 2,
1290 NULL NULL 1548 Sync state 197 0 200
6-05-16 15:46:14.957 2 0 0
3903282 10 exec sp_cursorfetch 180150000, 16, 44,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.957 10 0 0
3903283 10 exec sp_execute 2, 294 NULL NULL 624 Sync state
215 0 2006-05-16 15:46:14.990 2 0 0
3903284 10 exec sp_cursorfetch 180150000, 16, 45,
1 NULL NULL 996 Main state 263 0 2006-05-16 15:46:14.990 10 0 0
3903285 10 exec sp_execute 2,
872 NULL NULL 1676 Sync state 214 0 2006
-05-16 15:46:14.990 2 0 0
David Portas wrote:
> <razisyed@.sbcglobal.net> wrote in message
> news:1149805102.464734.305140@.j55g2000cwa.googlegroups.com...
> Use SQL Profiler to capture the actual statement being executed. Hopefully
> that should give you enough to figure out where the problem is.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --|||Try running profiler to capture when it is getting deleted.
You can use filter for TEXTDATA column like '%DELETE%XXXX%' where XXXX is
table name..
Jayesh
<razisyed@.sbcglobal.net> wrote in message
news:1149805102.464734.305140@.j55g2000cwa.googlegroups.com...
>I hope someone can help in solving this problem. I have a VB
> application that is accessing data from SQL server 2000 through linked
> tables in MS Access. It all works very well, except every once in a
> while, a record gets deleted from SQL Tables. I know for sure that the
> end user is not deleting it, and I am pretty sure its not a bug in the
> VB code. I have delete triggers placed, to trap the deleted record and
> the time it's deleted. But I have no idea how or why gets deleted. Any
> ideas or help on this will really be appreciated.
> Thanks
>|||Thats a good advice. Thanks. I am not really familiar with profiler.
I'll try to add this option to just track deletes. What other fields or
options should I use?
Thanks again.
Jayesh Antony Jose wrote:[vbcol=seagreen]
> Try running profiler to capture when it is getting deleted.
> You can use filter for TEXTDATA column like '%DELETE%XXXX%' where XXXX is
> table name..
> Jayesh
> <razisyed@.sbcglobal.net> wrote in message
> news:1149805102.464734.305140@.j55g2000cwa.googlegroups.com...|||Thats a good advice. Thanks. I am not really familiar with profiler.
I'll try to add this option to just track deletes. What other fields or
options should I use?
Thanks again.
Jayesh Antony Jose wrote:[vbcol=seagreen]
> Try running profiler to capture when it is getting deleted.
> You can use filter for TEXTDATA column like '%DELETE%XXXX%' where XXXX is
> table name..
> Jayesh
> <razisyed@.sbcglobal.net> wrote in message
> news:1149805102.464734.305140@.j55g2000cwa.googlegroups.com...