Jose Valverde
Reputation: 29
How to unlock table in sybase?
im trying to change some types on my table in sybase, but when i change it, the output is this one.
User 'DBA' has the row in 'table' locked
How to unlock this?
Upvotes: 2
Views: 18383
Answers (1)
Boggio
Reputation: 1148
I would:
- determine the connection_id using sa_locks (documentation here)
- issue the drop connection *connection_id* statement to the connection that is causing the lock to the table.
Use it with care!
Upvotes: 3
Related Questions
- How do I unlock an SQLite database?
- How to unlock table in SQL Server 2012?
- Unlock a table of a ingres database
- How to lock and unlock a SQL SERVER table?
- How to find out table lock or row lock in Sybase
- find locks on a table with specifc row sybase
- How to lock a table in SQL Server
- Is there an equivalent of NOLOCK table hint of MSSQL in Sybase 15.5 T-SQL?
- SQL Server: How to unlock a table / row?
- adding lock option to Create Table statement in Sql Server 2005