>Thank you again for your help.
>
>>
>>In order to create/update sproc in DB you do

>>-- create
>>CREATE PROCEDURE myproc
>>...
>>-- update
>>ALTER PROCEDURE myproc
>>...

>>After that you can excute sproc

>>myproc ...
>>-- or
>>EXEC myproc ...
>>

>
>Do I understand correctly that the above commands are to be typed in the Query window? This is like VFP Command Window, right?

They all are T-SQL statements/batches. You can run them in a query window, from some frontend using ODBC/OLE DB connection, e.t.c.