Monthly Archives: May 2005

Kill its own session in SQL Query Analyzer

We all know that using KILL can terminate the connection of a  client to SQL server. But how to terminate its own connection in SQL Query Analyzer? KILL does not work because it cannot kill its own process. However, we can … Continue reading

Posted in SQL server | 1 Comment

OPENXML and memory leak

This was a post I replied in a newsgroup to answer a question about OPENXML and memory leak. This is a common problem when xml is passed to an SP and is converted to relational data in the SP. If you have OPENXML inside your … Continue reading

Posted in SQL server | 3 Comments