Hi,
Is there any concept of java stored procedure in Sql server 2000?

My idea is : I want call a java programme form any sqlserver object
passing 2 parameter - one URL and one String [both varchar].The
java programme will use this url to call a jsp page .

The same idea I have implemented in Oracle . I have created a function which publishes the java method with it. I just give a call to the function from a plsql block passing the url string and the other string value. That function eventually call the java stored proc which in turn connect to the jsp using the url. I need to implement it in Sql Server also.

Please help .

Thanks in Advance.

# the java stored procedure resides in teh database.