Hi,
I have a single test.sql file with about 7 stored procedures in it.
create proc xxx1 as
....
.....
go
create proc xxx2 as
....
.....
go
....
....
create proc xxx7 as
....
.....
go
to execute this and registered them through a batch file:
i have it as :
osql -E -e -dTest -iC:\test.sql
osql -E -e -dTest -oC:\test_out.txt -n -Q "EXEC xxx1"
osql -E -e -dtest >>C:\test_out.txt -n -Q "EXEC xxx2"
....
osql -E -e -dtest >>C:\test_out.txt -n -Q "EXEC xxx7"
is this a right way to do???
Thnx.