Re: Mass loading SQL SERVER stored procedure

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 13:51:38 -0500

osql is a command line tool that can be used for this purpose.
You just need to specify the server, database, user (and password) as well
as the file name. 

-- 
Keith
"robert song" <robert.song@modelsoftcorp.com> wrote in message
news:Ow6yfM9qEHA.2900@TK2MSFTNGP12.phx.gbl...
> Hi All,
>
> We are during the coding of SPs in one project. Each SP is one .sql file
> and these files are becoming more and more. We use Query Analyzer to
> open .sql file and execute the script to create SPs one by one. It is
> obviously time cosuming and bring some mistake. Do anybody have a good
> way of mass loading SQL Server SPs(not cut and patse all scripts into
> one single big script). It would be helpful if I had a way to mass
> reload all of them with a single command or with executing one Dynamic
> SQL to read these script. Any ideas?
>
> Cheers,
>
> Robert Song
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: FTP delete problem
    ... But i have wrote that manually the delete command it's OK!!! ... Dim strLocalFolderName, strFTPServerName, strLoginID ... In my script I use the options -s for the file. ... If i am in session in the server the scheduled script result OK. ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: FTP in ASP.NET C#
    ... It has native .NET classes that will allow you to use the FTP protocol. ... >I would like to have my application FTP a file to a server after a user ... > ' This script assumes the file to be FTP'ed is in the same directory as ... > ' If there are multiple files to put, we need to use the command ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: replace field contents - record locking
    ... (windows, server 8, clients 8.5) ... If a user is in a record, then it is locked, and the replace command ... You can script navigation to force a record commit. ... successive editions of Filemaker have been successively slower. ...
    (comp.databases.filemaker)
  • Re: Perl and IIS - script runs but The page cannot be displayed
    ... > one with the variables passed to the script hard coded (although there ... > with absolute paths rather the relative ones the server doesnt mind. ... When executed from a command line, ... CGI programs do not use this function, ...
    (comp.lang.perl.misc)
  • Re: DNS Management tools for Large hosting environment
    ... like things simple without having to script something (seeing as I have never ... nowhere do I see a command to SEARCH for a host record and REPLACE ... Server in multiple domains. ... >> manualy, thus my need for a global search and replace, which it appears, ...
    (microsoft.public.windows.server.active_directory)
Quantcast