Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

stored procedures / batch file Expand / Collapse
Author
Message
Posted Thursday, May 4, 2006 4:27 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 9:17 AM
Points: 614, Visits: 326

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.

 

Post #277794
Posted Monday, May 8, 2006 8:00 AM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
Post #278300
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse