>Can i call a stored procedure from Sql Server. The procedure is stored in a foxpro database. I need to call this procedure to prepare data sql server has to modify.
>
>Thanks.

Michele,
It is not clear what you want to do.

Yes you can call a VFP stored procedure from within SQL server. Check linked server, openquery(), openrowset(). ie:

* Add the linked server - must be done once

EXEC sp_addlinkedserver
    @server = N'VFP_SERVER',  -- Your linked server name here
    @srvproduct=N'Visual FoxPro 9',  -- can be anything
    @provider=N'VFPOLEDB',
    @datasrc=N'"C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\Samples\data\testdata.dbc"'

After your linked server is setup you can make calls to SPs etc. ie:

insert mySQLTable (orderId, orderDate,shippedTo)
Select * From openquery(VFP_SERVER,
'Select
  order_ID,
 Cast(Evl(order_date,Null) As DateTime) As order_Date,
 TRIM(to_Name)
 from customer')

Cetin