RE: Stored Procedure(s) update

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 12/08/04


Date: Wed, 8 Dec 2004 08:41:02 -0800

You can create a batch to alter the procedure and execute the batch using
osql utility. Take a look in BOL.

AMB

"vul" wrote:

> I'm working for a company as consultant. Sometimes I need to make some
> changes in some SP on their SQL Server. I do not have a remote access to
> their server. Is there any way (script, utility, my own program) to update
> SP without visiting this company? They are pretty far from me and I would
> like to save some time by avoiding visits for a small change.
> I see it this way:
> I send something (file, files whatever) as an attachment. Regular user with
> no experience saves that attachment and double clicks on some of the files.
> Of course I test this scenario before I start to use it.
> Thank you
> Al
>
>
>



Relevant Pages

  • RE: Stored Procedure(s) update
    ... You can create a batch to alter the procedure and execute the batch using ... osql utility. ... "vul" wrote: ... > changes in some SP on their SQL Server. ...
    (microsoft.public.sqlserver.programming)
  • RE: Stored Procedure(s) update
    ... You can create a batch to alter the procedure and execute the batch using ... osql utility. ... "vul" wrote: ... > changes in some SP on their SQL Server. ...
    (microsoft.public.vb.database)
  • Re: Stored Procedure(s) update
    ... I said about the user with no experience with SQL Server (just a regular ... but I didn't know how to use osql utility before your answer. ... > You can create a batch to alter the procedure and execute the batch using ...
    (microsoft.public.vb.general.discussion)
  • Re: Stored Procedure(s) update
    ... I said about the user with no experience with SQL Server (just a regular ... but I didn't know how to use osql utility before your answer. ... > You can create a batch to alter the procedure and execute the batch using ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored Procedure(s) update
    ... I said about the user with no experience with SQL Server (just a regular ... but I didn't know how to use osql utility before your answer. ... > You can create a batch to alter the procedure and execute the batch using ...
    (microsoft.public.vb.database)