calling COM object from store procedure

hi

I have made a DLL , which i am calling from Sql Server 7.0
through sp_oacreate
i am able to run all the methods and properties from back end
but when i try to run a method which displays the form on the screen or show a message box
the store procedure gets stuck ....

is there a way to display the form from store procedure...
i have already tried with both modal and non modal forms
the same problem is coming with active x exe

if any body has any idea regarding this ...
please let me know

regards
Saqib
m_saqib@infozech.com