Re: Return to previous stored procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: John (jk_at_rt.com)
Date: 08/15/04 

Date: Sat, 14 Aug 2004 19:59:28 -0700

Thanks David,

I will forward this along.

John

"David G." <david_nospam@nospam.com> wrote in message
news:OuyLlrcgEHA.3916@TK2MSFTNGP11.phx.gbl...
> John wrote:
>> I am very weak on SQL 2000 so I am not sure if I am asking this right.
>>
>> My customer would like the ability to reurn to a previous stored
>> procedure. i.e. Last procedure done at 3pm an realized there is a
>> problem and would like to go back to the 2nd stored procedure that he
>> did at 1pm. Is this possible?
>>
>>
>> TIA
>>
>> John
>
> Tell your customer to use a source code control program like MS
> SourceSafe or an SQL IDE tool like Imceda Speed IDE for stored procedure
> development. It's never a good idea to edit direcly on the server,
> especially in a production environment. SQL Server does not keep
> revisions or your edits.
>
> If you have no way to recreate the old stored procedure, you could try
> restoring the database to another server.
>
>
> --
> David G.
>

Relevant Pages

  • Re: Importing CSV File
    ... Thanks, John. ... the file would need to be visible to the Database server. ... Do While StartPos < Len ... I've never needed to use an ADP and don't have an instance of SQL server ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem using SP as record source with Access2002 & SQL Server 7
    ... I've installed a brand new copy of SQL Server 2000 with the original ... I've created the folowing stored procedure for the resync ... Resync Command: ALL_CUSTOMERS_RESYNC? ... I need to upgrade to a newer version of Microsoft SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Creating a database
    ... Please do yourself a favor, find a local user group, or buy a beginning book on SQL Server or take a class, you will save yourself a great deal of pain in the long run. ... CREATE DATABASE Products ... I can create a stored procedure from within the Server Explorer and from ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: Breakpoints in T-SQL not hit from VS 2005 with SQL 2005
    ... Open stored procedure in server explorer and set breakpoint ... Run the procedure from SQL Server Management Studio ... SQL Server 2005 Developer Edition installed on local PC. ... I created a windows project and called stored procedure using ...
    (microsoft.public.vsnet.debugging)