dev

The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:

1
2
3
4
–This example shows how to terminate SPID 55.
KILL 55
–This example generates a status of the rollback process for the specific spid.
KILL 55 WITH STATUSONLY

–This is the progress report.
spid 55: Transaction rollback in [...]

sql server 2000 one of most powerful and easy to use database application. It’s nicely handle giga size data. Unfortunately the growth of the log file can be very frustrating. Sometimes there’s a certain difficulty when we want to shrink the log file, mainly because the database still running a process.
usually we can use the [...]