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

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Concurrency error when deleting a record?

Author  Topic 

sbt1
Yak Posting Veteran

89 Posts

Posted - 2004-10-28 : 06:48:58
I'm getting a concurrency error when I try to delete a record from one of my tables. No clients are attached to the table or have it open.

Thoughts?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-28 : 13:04:21
Please post the error and the delete command.

Tara
Go to Top of Page

sbt1
Yak Posting Veteran

89 Posts

Posted - 2004-10-29 : 07:21:09
Well, I'm doing this from MSDE Admin, and the error is a "DB.ConcurrencyException".

So I guess my question is, in general, what is a concurrency exception?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-29 : 12:30:32
What is MSDE Admin? Is that a third party tool? MSDE doesn't come with GUI tools, just command line tools and one of them is not MSDE Admin.

Tara
Go to Top of Page

sbt1
Yak Posting Veteran

89 Posts

Posted - 2004-10-29 : 13:25:20
Correct. It's a 3rd party admin tool.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-29 : 13:27:50
I'd contact the owner of the tool then as that error is not a SQL Server error.

Try the delete from osql.exe.

Tara
Go to Top of Page
   

- Advertisement -