>Thanks for your fast reply
>I place several new sp in one file named update.sqlor update.txt
>
>how can I can Call this sql programically
>Thanks
>such as
>Use branch1
>do update.sqll...... etc

First it's common to use .sql as extension. Second check osql,wsql.

If you're putting it inot a file then you could simply open that in query analyzer and execute:

use db1
go
sp
go
use db2
go
sp
go
use db3
go
sp
go
...

Agnes you have VFP, no? You could simply do it via SQLExec().
Cetin