I will do it when next time it hangs, But My Concern is that It works great through SSMS at the very same time but hangs through the application. My Understanding is that if it has to impact performance it should be consistent through SSMS or Application