| Subject | Dropping a Table causes "OBJECT IS IN USE" |
|---|---|
| Author | robertgilland |
| Post date | 2006-05-17T03:51:32Z |
Trying to drop a table which I created in the same session
I get the below error.
What can I Do
- the table is external
- the table had a stored procedure using it.
- i have successfully dropped the stored procedure.
ISC ERROR CODE:335544345
ISC ERROR MESSAGE:
lock conflict on no wait transaction
unsuccessful metadata update
object MYTABLE is in use
I get the below error.
What can I Do
- the table is external
- the table had a stored procedure using it.
- i have successfully dropped the stored procedure.
ISC ERROR CODE:335544345
ISC ERROR MESSAGE:
lock conflict on no wait transaction
unsuccessful metadata update
object MYTABLE is in use