Calling stored procedures

[mswaim1]

I've been trying to call a stored proc on a note post save. Ive implemented a logic hook and get the proc to call....partially. I am passing the note id and it will complete some of the procs functions and stops however, when i call it independently in SQL Server, passing a note id, it runs sucessfully. When it fails to complete all functions after being called in note_post_save there are no SQL errors thrown. Is this a locking issue? I have played with config settings such as dump_slow_queries.. still no luck, any ideas?

Added some of the custom code:

\sugar\custom\modules\Notes\logic_hooks.php
$hook_array['after_save'][] = Array(1, void, 'custom/modules/Notes/Notes_cstm.php', 'Notes_cstm', 'note_after_save_1');

\sugar\custom\modules\Notes\Notes_cstm.php
class Notes_cstm
{
function note_after_save_1()
{
//sleep(5);
$query = "EXEC postSaveHandler '$this->id';";
$db->query($query, false,"Error running users proc: ");

}
}

Sugar 4.5.1h
SQL Server 2005
IIS 6