former_SQLA_member1694880
Participant
Member since ‎2009 Nov 10

User Statistics

  • 116 Posts
  • 0 Solutions
  • 790 Kudos given
  • 126 Kudos received

User Activity

SA10: cannot delete foreign key

2010 Nov 10
SA 10.0.1.4116 / Win64 + mirroring. An attempt to delete foreign key fails with the following message: [Sybase][ODBC Driver][SQL Anywhere]User 'fk_dividend_received_store' has the row in '???' locked SQLCODE: -210 SQLSTATE: 40001 SQL Statement: ALT...

SA10: cannot drop connections

2010 Nov 08
SA 10.0.1.4116 / Win64 + mirroring. Recently I've noticed some strange connections than hang around on server and cannot be dropped: an attempt to disconnect them using DROP CONNECTION statement yields 'User "DBA" dropped connection xxx' message on ...

DBTools: DBBackup was not working (looking for a better solution)

2009 Dec 03
Recently, I've tried to update a custom backup program written in Borland C++ Builder from dbtools 9 to dbtools 10, and I've started getting strange error messages. After some investigation using MSVC I discovered that size of chkpt_log_type member i...

User 'another user' has the row in 'mytable' locked

2009 Dec 03
SA 10.0.1.3960 / Win64 + mirroring running on Windows 2003 Server. When trying to create a foreign key, I get the following error message: User 'another user' has the row in 'mytable' locked I know it may happen due to the running out of locks. Ho...