I generated a script to recreate all the stored Procedures of a given database on a copy of my database on a second server. I saved this script as a file, named it "My_Script,sql" and put on on 'C' drive.
Then on the command line I typed:
osql -E -sServername -ddatabasename -Q " Execute C:\My_Script,sql"
My stored procedures were not created in my database.
What I am doing wrong?
P.S. The script contains all the code for Create Procs.
Faye