Re: Copying Stored Procedures from One Database To Another

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 02/18/04 

Date: Wed, 18 Feb 2004 16:14:31 +0530

hi brad,

with msde you can use command line utility osql to run script file. Following is sample
example. Go to command prompt and run "osql /?" to get all the options available with osql. To
get more info on these parameters, see books online.
Ex:
osql /S<server> /Usa /P<password> /d<database> /i"c:\scriptfile.sql" 

-- 
Vishal Parkar
vgparkar@yahoo.co.in

Relevant Pages

  • Re: MSDE 2000 help please
    ... > databases by using osql in a command prompt but is there an easier way? ... The data and objects are stored in MDF files on your hard drive. ...
    (microsoft.public.sqlserver.server)
  • Service Pack 3
    ... MSDN tells me to go to a Command Prompt ... >and enter osql -U sa and then enter the password. ... >Hal Fliegelman ...
    (microsoft.public.sqlserver.security)
  • Cannot connect to SQLEXPRESS via MS Enterprise Library??
    ... Windows XP ... ..NET 2.0 {for SQLExpress} ... This works from a command prompt ... osql -E -S localhost\SQLEXPRESS ...
    (microsoft.public.dotnet.languages.csharp)
  • Service Pack 3
    ... Service Pack 3 will not run unless I create a "strong" ... MSDN tells me to go to a Command Prompt ... and enter osql -U sa and then enter the password. ...
    (microsoft.public.sqlserver.security)
  • Re: Installing a database
    ... - Restore a backup of an empty database with OSQL ... Create it using a script file ran by OSQL ...
    (microsoft.public.sqlserver.msde)