Sometimes you might need to terminate a process in sql server.
1. Open Sql server management studio
2. Open a new query
3. execute command below, processID is the sql process number
kill processID
NB. Ensure you terminate a correct process or seek advise from a database consultant.
| Database Warning |
| These steps require knowledge of database engines and application databases (DBs) used by your Sage product (including Microsoft/Transact SQL, Pervasive SQL, or MySQL, etc.). Customer Support is not responsible for assisting with these steps and cannot be responsible for errors resulting from changes to the database engine or DBs. Before making changes, backup all system and application DBs required for a full restore. Contact an authorized business partner or DB administrator for assistance. |