Drop login command hangs the connection to sybase. It does not return anything.

[Former Member]

Hello,

I created an login account using 'create login' command and tried to drop the account using 'drop login' command. But the drop login command seems to get stuck somewhere as it does not return anything and connection is stuck. I checked the locks using sp_lock. It shows active 'update row' lock on 'syslogins' table. When I abort the drop login query, it seems to release the locke thenonly. Why is this happening?

In the logs I see the logs as 'tasks are sleeping waiting for space to become available in the log segment for database ***'. Is there any relation of this with my problem. I'm new to sybase. Please help.

'

[former_member89972]

As always excellent feedback/suggestion by Mark.

System databases like master & sybsystemprocs also need some administration and maintenance work.

Usually after taking a full backup, truncate the transaction log of a system database (like master) by the "dump transaction .... truncate_only" command.

Avinash