Recovery problem

In my production database i have lost data in three tables.so i just want to restore the data from my backup which was created.

I am connecting over remote desktop connetion to the server.

With in the databases i right click the database which has my three tables within them.

Then select all tasks->restore database

In restore i select files or file groups

then i select the day i want to restore the ok

It comes up with this error

Cannot open the back up device 'C:\programs\......'

device error or device online

Restore database is terminating abnormally

Is it because i am not doing at the server as i am connecting over remote desktop....

And my database has several tables apart from these three tables.is it possible for me just to restore these three tables.

i am using sql server 2000 database

Please let me know..

Are you using the GUI on the remote server or the GUI on your local machine? The GUI you use will need to be on the machine that the file resides if you are using localfile paths.

Also, you will only be able to restore those 3 tables using a PARTIAL restore if they exist in a separate filegroup to the rest of the data.If you only have one filegroup then you will have to restore the whole thing.

Either way, i think your only option is to do the restore to a separate database and then copy the data to your "live" db.

Check out the RESTORE information in Books Online as this gives a fairly thorough rundown of all the options.

HTH!

|||

Hi,

YOU CAN RETRIEVE THE BACKUP DATA FROM THE DELETED DATA..

I AM WORKING WITH SQL SERVER 2005.

JUST TRY ONCE AFTER THAT YOU CAN!!!!!!!!!!

Recovery of dropped data that was never back up

Hi

I am trying to recover a set of tables with data that was dropped. This data was not backed up. Please advice, is there any way this data can be recovered.

With SQL, the way to go back in time is to restore backups. You really can't recover dropped tables without any backups.

Depending on how valuable and critical the information is (which begs the obvious question of why it wasn't backed up if it was valuable), you may be able to do some forensic data mining on the files themselves. The data is not actually overwritten, just marked as free mujch as the filesystem does. So as long as the space has not been reused, there may still be information out there. SQL has no utilities for this, however.

You can either examine the raw files with a hex editor, or someone may know of a 3rd-party utility to make it slightly easier. None of this is of course supported.

Recovery Model to be used for a Data Flow Task

Hello there

I have a SSIS 2005 DTSX Package which has several Data flow tasks which directly dump data between tables from 2 different databases.

Suppose if my destination database is named, DestinationDB, what recovery model should I select for this database so that my ldf file size does not explode? I want to keep the ldf file as small in size as possible.

1. Currently I have used Simple Recovery model, and the ldf file size goes to around 80 GB. (Inserting around 200 million rows)

2. Will Bulk Logged model be a better option?

Also what does a SSIS 2005 Data flow task use internally? (Insert operation or some sort of Bulk Insert between DBs)

Please help.

The fast load option on the OLE DB destination performs a bulk load.|||

Thanks for the response.

Does the fast load option keep the ldf file size to a minimum?

|||This probably isn't the correct forum for you, but I believe you'll want "bulk-logged recovery" so as not to grow the LDF file. Or split your data into smaller chunks using the MaximumInsertCommitSize setting on the OLE DB Destination.

Recovering unused space on Sql 7.0 tables

Hi List,
I have 4 tables with 20+million rows (3rd party app) anyway these tables are
reporting their space used in the 50+gigabytes but the space they are
claiming is about 70-90 gb is there anyway to force them to shrink to
recover this space.
thanks
evanDepends on how the database files were created. SS 7.0 is kind of PITA
regarding file management... It's one of the main reasons to upgrade to
SS2K.
Anyway, execute the following from within the database you are discribing to
get an accurate representation:
EXECUTE sp_spaceused @.updateusage = 'true'
EXECUTE sp_helpdb 'MyDatabase'
Now, use the DBCC SHRINKFILE command to reclaim the space you desire on the
data files. SS 7.0 space reclaimation on the transaction logs is lousy.
More often than not, you have to detach the database, move the transaction
log somewhere else, then use the sp_attach_single_file_db to have the
database brought back online with a newly created, and hopefully smaller,
transaction log.
Hope this helps.
Sincerely,
Anthony Thomas
"evan b" <evan_at_cheapaschips.com.au_removethis> wrote in message
news:OGlnIj52EHA.1404@.TK2MSFTNGP11.phx.gbl...
Hi List,
I have 4 tables with 20+million rows (3rd party app) anyway these tables are
reporting their space used in the 50+gigabytes but the space they are
claiming is about 70-90 gb is there anyway to force them to shrink to
recover this space.
thanks
evan

Recovering unused space on Sql 7.0 tables

Hi List,
I have 4 tables with 20+million rows (3rd party app) anyway these tables are
reporting their space used in the 50+gigabytes but the space they are
claiming is about 70-90 gb is there anyway to force them to shrink to
recover this space.
thanks
evan
Depends on how the database files were created. SS 7.0 is kind of PITA
regarding file management... It's one of the main reasons to upgrade to
SS2K.
Anyway, execute the following from within the database you are discribing to
get an accurate representation:
EXECUTE sp_spaceused @.updateusage = 'true'
EXECUTE sp_helpdb 'MyDatabase'
Now, use the DBCC SHRINKFILE command to reclaim the space you desire on the
data files. SS 7.0 space reclaimation on the transaction logs is lousy.
More often than not, you have to detach the database, move the transaction
log somewhere else, then use the sp_attach_single_file_db to have the
database brought back online with a newly created, and hopefully smaller,
transaction log.
Hope this helps.
Sincerely,
Anthony Thomas

"evan b" <evan_at_cheapaschips.com.au_removethis> wrote in message
news:OGlnIj52EHA.1404@.TK2MSFTNGP11.phx.gbl...
Hi List,
I have 4 tables with 20+million rows (3rd party app) anyway these tables are
reporting their space used in the 50+gigabytes but the space they are
claiming is about 70-90 gb is there anyway to force them to shrink to
recover this space.
thanks
evan

Recover the deleted tables

Hello, everyone
If I dont have any backup for SQL Server 2k on Win 2k, how to recover the deleted tables and database.
Thanks a lot.
ZYTlumigent's log explorer could have helped you, but out of curiosity, how could it even happen that you don't have backups?|||Originally posted by yitongzhang
Hello, everyone

If I dont have any backup for SQL Server 2k on Win 2k, how to recover the deleted tables and database.

Thanks a lot.

ZYT

If u have lastest full backup,then u can backup log.
Then u can do incomplete recover to restore.sql

recover Dropped table

Hi,
This is a dissaster.
tables are dropped from the database, which there is no transaction log (it
was set up with simple recovery mode.)
Data has never been backup.
Is there anyway that the data can be recover from those dropped table.
Thanks,
DaraDara,
If there is no transaction log, Lumigent won't help you.
If the data has never been backed up, then I have nothing else to offer you.
(If you had a backup, then you could restore it to another database and copy
the tables from the restore database back to your working database.)
Russell Fields
Crazy Idea: If ABSOLUTELY NOTHING has been done to the database since the
tables were dropped and if you are willing to pay for the help, Microsoft
might be able to root out the tables from the database structure. This is
NOT likely though.
"Dara Bunhim" <bdara@.racha.org.kh> wrote in message
news:eCQbzvtcDHA.3520@.tk2msftngp13.phx.gbl...
> Hi,
> This is a dissaster.
> tables are dropped from the database, which there is no transaction log
(it
> was set up with simple recovery mode.)
> Data has never been backup.
> Is there anyway that the data can be recover from those dropped table.
> Thanks,
> Dara
>|||Not sure if this will work. If there was a file system backup, recover data
and log files from the backup before the table was dropped and do sp_attach.
Good luck!
"Russell Fields" <rlfields@.sprynet.com> wrote in message
news:ej3axNucDHA.1532@.TK2MSFTNGP10.phx.gbl...
> Dara,
> If there is no transaction log, Lumigent won't help you.
> If the data has never been backed up, then I have nothing else to offer
you.
> (If you had a backup, then you could restore it to another database and
copy
> the tables from the restore database back to your working database.)
> Russell Fields
> Crazy Idea: If ABSOLUTELY NOTHING has been done to the database since the
> tables were dropped and if you are willing to pay for the help, Microsoft
> might be able to root out the tables from the database structure. This is
> NOT likely though.
> "Dara Bunhim" <bdara@.racha.org.kh> wrote in message
> news:eCQbzvtcDHA.3520@.tk2msftngp13.phx.gbl...
> > Hi,
> >
> > This is a dissaster.
> >
> > tables are dropped from the database, which there is no transaction log
> (it
> > was set up with simple recovery mode.)
> >
> > Data has never been backup.
> >
> > Is there anyway that the data can be recover from those dropped table.
> >
> > Thanks,
> > Dara
> >
> >
>

Recover data from Tables Sql2000

Good Morning,
We have a Win2003 server with SQL2000 running on it. We have an Access Order
Entry application front end with the back end on a database. I was updating
some product pricing in our database and I accidentally DELETED about 360
products. I imported a table with new pricing, and I was updating the prices
in our database with the new prices from an excel spreadsheet.
What is the fastest way I can get back those products? Can I do a roll back
with the trans. log?
Or should I use a backup copy of the database? My automatic maintenance runs
twice a week, so I have backup of the database and logs. But I don't want to
restore the whole database, maybe just one table in the database. Thanks!
Merry Christmas!
Anthony...
Although you can't restore a single table, you can restore the entire
database to a different database name and apply your log backups, if needed.
This will allow you to extract the lost data for insertion into your live
database.
Hope this helps.
Dan Guzman
SQL Server MVP
"Anthony Smith" <anthony@.peconet.com> wrote in message
news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Good Morning,
> We have a Win2003 server with SQL2000 running on it. We have an Access
> Order
> Entry application front end with the back end on a database. I was
> updating
> some product pricing in our database and I accidentally DELETED about 360
> products. I imported a table with new pricing, and I was updating the
> prices
> in our database with the new prices from an excel spreadsheet.
> What is the fastest way I can get back those products? Can I do a roll
> back
> with the trans. log?
> Or should I use a backup copy of the database? My automatic maintenance
> runs
> twice a week, so I have backup of the database and logs. But I don't want
> to
> restore the whole database, maybe just one table in the database. Thanks!
> Merry Christmas!
> Anthony...
>
>
|||Thanks for your help. I did it and it work. I'm a SQL novice so I haven't
done much with SQL logs other than back them up.
Have a Merry Christmas!
Anthony...
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OHjywKP6EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Although you can't restore a single table, you can restore the entire
> database to a different database name and apply your log backups, if
> needed. This will allow you to extract the lost data for insertion into
> your live database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Anthony Smith" <anthony@.peconet.com> wrote in message
> news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
>
|||That's better than most novices; at least you know they exist and have the
sense to back them up.
Sincerely,
Anthony Thomas

"Anthony Smith" <anthony@.peconet.com> wrote in message
news:eMsKduP6EHA.1596@.tk2msftngp13.phx.gbl...
Thanks for your help. I did it and it work. I'm a SQL novice so I haven't
done much with SQL logs other than back them up.
Have a Merry Christmas!
Anthony...
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OHjywKP6EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Although you can't restore a single table, you can restore the entire
> database to a different database name and apply your log backups, if
> needed. This will allow you to extract the lost data for insertion into
> your live database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Anthony Smith" <anthony@.peconet.com> wrote in message
> news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
>

Recover data from Tables Sql2000

Good Morning,
We have a Win2003 server with SQL2000 running on it. We have an Access Order
Entry application front end with the back end on a database. I was updating
some product pricing in our database and I accidentally DELETED about 360
products. I imported a table with new pricing, and I was updating the prices
in our database with the new prices from an excel spreadsheet.
What is the fastest way I can get back those products? Can I do a roll back
with the trans. log?
Or should I use a backup copy of the database? My automatic maintenance runs
twice a week, so I have backup of the database and logs. But I don't want to
restore the whole database, maybe just one table in the database. Thanks!
Merry Christmas!
Anthony...Although you can't restore a single table, you can restore the entire
database to a different database name and apply your log backups, if needed.
This will allow you to extract the lost data for insertion into your live
database.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Anthony Smith" <anthony@.peconet.com> wrote in message
news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Good Morning,
> We have a Win2003 server with SQL2000 running on it. We have an Access
> Order
> Entry application front end with the back end on a database. I was
> updating
> some product pricing in our database and I accidentally DELETED about 360
> products. I imported a table with new pricing, and I was updating the
> prices
> in our database with the new prices from an excel spreadsheet.
> What is the fastest way I can get back those products? Can I do a roll
> back
> with the trans. log?
> Or should I use a backup copy of the database? My automatic maintenance
> runs
> twice a week, so I have backup of the database and logs. But I don't want
> to
> restore the whole database, maybe just one table in the database. Thanks!
> Merry Christmas!
> Anthony...
>
>|||Thanks for your help. I did it and it work. I'm a SQL novice so I haven't
done much with SQL logs other than back them up.
Have a Merry Christmas!
Anthony...
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OHjywKP6EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Although you can't restore a single table, you can restore the entire
> database to a different database name and apply your log backups, if
> needed. This will allow you to extract the lost data for insertion into
> your live database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Anthony Smith" <anthony@.peconet.com> wrote in message
> news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
>> Good Morning,
>> We have a Win2003 server with SQL2000 running on it. We have an Access
>> Order
>> Entry application front end with the back end on a database. I was
>> updating
>> some product pricing in our database and I accidentally DELETED about 360
>> products. I imported a table with new pricing, and I was updating the
>> prices
>> in our database with the new prices from an excel spreadsheet.
>> What is the fastest way I can get back those products? Can I do a roll
>> back
>> with the trans. log?
>> Or should I use a backup copy of the database? My automatic maintenance
>> runs
>> twice a week, so I have backup of the database and logs. But I don't want
>> to
>> restore the whole database, maybe just one table in the database.
>> Thanks!
>> Merry Christmas!
>> Anthony...
>>
>|||That's better than most novices; at least you know they exist and have the
sense to back them up.
Sincerely,
Anthony Thomas
"Anthony Smith" <anthony@.peconet.com> wrote in message
news:eMsKduP6EHA.1596@.tk2msftngp13.phx.gbl...
Thanks for your help. I did it and it work. I'm a SQL novice so I haven't
done much with SQL logs other than back them up.
Have a Merry Christmas!
Anthony...
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:OHjywKP6EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Although you can't restore a single table, you can restore the entire
> database to a different database name and apply your log backups, if
> needed. This will allow you to extract the lost data for insertion into
> your live database.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Anthony Smith" <anthony@.peconet.com> wrote in message
> news:upQJhAP6EHA.2016@.TK2MSFTNGP15.phx.gbl...
>> Good Morning,
>> We have a Win2003 server with SQL2000 running on it. We have an Access
>> Order
>> Entry application front end with the back end on a database. I was
>> updating
>> some product pricing in our database and I accidentally DELETED about 360
>> products. I imported a table with new pricing, and I was updating the
>> prices
>> in our database with the new prices from an excel spreadsheet.
>> What is the fastest way I can get back those products? Can I do a roll
>> back
>> with the trans. log?
>> Or should I use a backup copy of the database? My automatic maintenance
>> runs
>> twice a week, so I have backup of the database and logs. But I don't want
>> to
>> restore the whole database, maybe just one table in the database.
>> Thanks!
>> Merry Christmas!
>> Anthony...
>>
>

Recordset Modification and Copy

Please Help.

I have written a custom DTS task in an ActiveX Script. My script creates three recordsets from three existing tables in an SQL Server 2k DB by copying all the data in these tables.

My script then modifies the data in these recordsets including dropping several records, creates a new table and inserts the modified data into the new table.

Unfortunately, I need to keep my original data unmodified...and currently my code changes my original data when it modifies the record sets.

Does anyone have a method for modifying a recordset without modifying the source data? I am writing my ActiveX Script through the VB scripting language.

From what I have read on the internet some people suggest creating a new recordset, copying the data from the original recordset to the new recordset, and then modify and insert the new recordset. This is supposed to keep my source data unchanged. Unfortunately, I have not been successful with this method mainly because I am having trouble creating a new recordset and copying my original recordset data into this new object.

Thank you in advance for any help or input you might have!!!

-TRocheI assume you are using ADO? Disconnect your recordset by setting your ActiveConnection property to nothing.|||I don't think this will work. You see I have to manipulate the data through several DO Until loops. The constraint on my DO loop is

"DO UNTIL rs.EOF"

Before I set the recordset ActiveConnection to nothing It tells me I have to first close the recordset. Unfortunately, I can not run the syntax of the above loop if the recrordset is closed, and if I open the recordset with a new connection it again changes my source data.

Does anyone have any additional insight?

Thanks!

-TRoche|||create a function READ UNCOMMITTED transaction isolation level (you can do it with nolock optimizer hint) and do your DO UNTIL against the rs that points to it.|||Wow...I am just a beginner at this stuff...I will look into it, but do you have a sample code for this by chance?

thanks,

TRoche|||create function dbo.fn_select_star_from_your_table (
@.parm1 <data type>,
@.parm2 <data type>,
@.parm3 <data type> ) returns table
as return (
select * from your_table (nolock)
where field1 = @.parm1
and field2 = @.parm2
and @.field3 = parm3)
go|||Hmmmmm....ok to start I am writing a custom DTS Task, using an ActiveX Script in the DTS Designer, coding in VBScript

Well I am having a few problems with the previous comments. First off I can't get the code to drop the function ms_sql_dba advised. Here is my DROP code for a function called FUNSTUFF:

dim Dropx
set Dropx = CreateObject("ADODB.Command")

Dropx = "Drop Function [dbo].[FUNSTUFF]"
connection.execute Dropx

I am only trying to drop the function because if I run the code multiple times it errors saying the the object "FunStuff" already exists in the database...and I looked...and it does...dang Does anyone see something wrong with the above DROP code?

Also, ms_sql_dba, I am not sure I understand what your function does. Here is how I thought to use your advice.

Write a function called ADVICE as follows:
dim ADVICE
set ADVICE = CreateObject("ADODB.Command")

ADVICE = "CREATE FUNCTION dbo.FUNSTUFF (@.time float, @.Position float ) RETURNS Table AS RETURN (select * from GPSy (nolock) where ty = time and GPS_y = Position)"

then:
Open.recordset ADVICE, Connection, adOpenKeyset

Then write my do loop:
DO UNTIL recordset.EOF
blah, blah, blah
Loop

Unfortunately, I run into all kinds of errors like saying the operation can not be performed if the recordset is closed. But if I write an open command like:

open.recordset.connection

I get the error that the function FUNSTUFF alreadyexists in the database.

Hmmmmmmmm...

Does anyone have any advice? Do I have to write the Function code before every loop or a drop code after every loop...or...hmmm...I am just confused about how the function works.

A million thanks to anyone who has any input!!

-TRoche

Records Versioning/Auditing

Howdy,
Forgive me if this is the wrong group. I'm writing a ASP.Net application and
i need to track every change to a table's records. In SQL 2005, is there a
way to easily keep a record change history? Something with rules or triggers
or something? Or am I stuck comparing every field manually before i perform
the UPDATE?
Thanks a lot!
David Lozzi
Delphi Technology Solutions
Blog: www.lozzi.net
A trigger can do what you need (i.e. putting a changed record into an audit
table prior to or after an update).
I recommend checking out ApexSQL's Audit. It can set up everything for you
with a mostly point-and-click interface.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"David Lozzi" <dlozzi(remove-this)@.delphi-ts.com> wrote in message
news:136C1D21-F4AD-4F15-B193-732576A972EA@.microsoft.com...
> Howdy,
> Forgive me if this is the wrong group. I'm writing a ASP.Net application
> and
> i need to track every change to a table's records. In SQL 2005, is there a
> way to easily keep a record change history? Something with rules or
> triggers
> or something? Or am I stuck comparing every field manually before i
> perform
> the UPDATE?
> Thanks a lot!
> --
> David Lozzi
> Delphi Technology Solutions
> Blog: www.lozzi.net
|||Yeah, i saw them but at $600 per license, i'll figure it out myself.
thanks,
David Lozzi
Delphi Technology Solutions
Blog: www.lozzi.net
"TheSQLGuru" wrote:

> A trigger can do what you need (i.e. putting a changed record into an audit
> table prior to or after an update).
> I recommend checking out ApexSQL's Audit. It can set up everything for you
> with a mostly point-and-click interface.
> --
> Kevin G. Boles
> TheSQLGuru
> Indicium Resources, Inc.
>
> "David Lozzi" <dlozzi(remove-this)@.delphi-ts.com> wrote in message
> news:136C1D21-F4AD-4F15-B193-732576A972EA@.microsoft.com...
>
>
|||$600 is a real bargain for what you get in the package. If you get paid $20
per hour that is only 30 hours before you hit the same amount. No way you
can build out a fully functional system like Audit can do for you in that
time frame.
Note too that the license is just for the client that sets up the auditing.
You can audit unlimited servers from that one purchase. See here,
http://www.apexsql.com/sql_tools_audit.asp, 4th bullet point from the top.
And they have a viewer to report on the audited information that is only $50
per client.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"David Lozzi" <dlozzi(remove-this)@.delphi-ts.com> wrote in message
news:F7CA333A-71F4-4B8A-BC90-FD23D60CF3DA@.microsoft.com...[vbcol=seagreen]
> Yeah, i saw them but at $600 per license, i'll figure it out myself.
> thanks,
> --
> David Lozzi
> Delphi Technology Solutions
> Blog: www.lozzi.net
>
> "TheSQLGuru" wrote:

Records NOT in OTHER table - SELECT statement

I am trying to compare 2 tables with similar data. One table has a field named [X Sent] and the other table has a field named [X Setup]. I was trying to extract all of the fields in Table 1 with field [X Sent] that are not yet in Table 2, i.e. field [X Setup]. I was trying some LEFT JOINS and other stuff but I can't seem to get the syntax correct. How can I get a query of only the fields that are not in Table 2, but are in Table 1?

Here are two of my attempts:

SELECT [X Sent], [X Date]
FROM [Table 1]
WHERE ([X Sent] NOT IN
(SELECT [Table 1].[X Sent]
FROM [Table 2] INNER JOIN
[Table 1] ON [Table 2].[X Setup]= [Table 1].[X Sent]))

I don't believe 'NOT IN' is proper syntax!

And my other attempt:

SELECT [Table 1].[X Sent]
FROM [Table 1] LEFT OUTER JOIN
[Table 2] ON [Table 2].[X Setup]= [Table 1].[X Sent]

Any help would greatly be appreciated.An outer join, checking for NULL in [Table 2] will do it.

SELECT [X Sent],[X Date] FROM
[Table 1] t1 LEFT OUTER JOIN [Table 2] t2 ON t1.[X Sent]=t2.[X Setup]
WHERE t2.[X Setup] IS NULL

|||Thanks once again Douglas Reilly!!!!

Greatly appreciative...|||After analyzing the data further, I have noticed that I can't only compare one field, but rather two from each table. I have been trying to work with the following statement, but I can't seem to get it to work. To start off with, I would like to capture all the fields where Field1 and Field2 from Table1 equals Field1 and Field2 of Table2.

SELECT [Field1], [Field2]
FROM Table1 t1 INNER JOIN
Table2 t2 ON t1.Field1 = t2.Field1 AND t1.Field2 = t2.Field2

Once I figure this part out, I will go ahead and search for all of these tuples not in the other table. Your assistance will greatly be appreciated.|||You should pick one of your candidate keys to be the primary key of Table1. Then you can do this:

select * from Table1
where Table1PrimaryKey not in
(select Table1PrimaryKey from Table1
inner join Table2 on Table1.Field1=Table2.Field1 and Table1.Field2=Table2.Field2)

If for some reason you really need the fields, you can use this:

select Table1.Field1, Table1.Field2
from Table1
inner join Table2 on Table1.Field1=Table2.Field1 and Table1.Field2=Table2.Field2

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...

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 state 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 2006-05-16 15:46:14.037 1 0 0
3903059 10 exec sp_execute 2,
1737 NULL NULL 1548 Sync state 197 0 2006-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 2006-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 2006-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 2006-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 2006-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 2006-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 2006-05-16 15:46:14.253 2 0 0
3903140 10 exec sp_execute 1,
818 NULL NULL 3152 Sync castle 266 0 2006-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","paymentFollow","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 2006-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 state 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 2006-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 2006-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 2006-05-16 15:46:14.397 1 0 0
3903172 10 exec sp_execute 2,
1253 NULL NULL 1548 Sync state 197 0 2006-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 2006-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 2006-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 2006-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 2006-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 2006-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 2006-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 2006-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 state 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 2006-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 2006-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 2006-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 2006-05-16 15:46:14.753 1 0 0
3903250 10 exec sp_execute 2,
1286 NULL NULL 1548 Sync state 197 0 2006-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 2006-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 2006-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 2006-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 state 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 2006-05-16 15:46:14.910 2 0 0
3903273 10 exec sp_execute 1,
831 NULL NULL 3152 Sync castle 266 0 2006-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 2006-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...
> >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
> --|||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:
> 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
> >