SP Source Control Options

From: Guy (Guy_Schuler@Kumtor.com)
Date: 02/19/03


From: "Guy" <Guy_Schuler@Kumtor.com>
Date: Wed, 19 Feb 2003 03:37:59 -0800


I am new to an environment (located in Central Asia) that
relies heavily on Stored Procedures on SQL 7. It is clear
that many of the problems we experience are from poor
update and recovery controls of these SPs.

What options are there to implementing Source Control on
MS Stored Procedures?



Relevant Pages

  • SP Source Control Options
    ... I am new to an environment (located in Central Asia) that ... relies heavily on Stored Procedures on SQL 7. ... update and recovery controls of these SPs. ... MS Stored Procedures? ...
    (microsoft.public.sqlserver.security)
  • How do I do Paging through a large dataset via Stored Procedures
    ... Paging by dynamically altering the SQL Query ... Create stored procedures ... SELECT * FROM STUDENTS ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help with Stored Procedure
    ... I did mean stuff like system stored procedures (even ... build the query, compile it, and optimize it, then, then this is less ... very not easy using dynamic sql. ...
    (microsoft.public.sqlserver.programming)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.databases)
  • Re: choices regarding where to place code - in the database or middle tier
    ... Sure, the DBMS is a good place for simple referential integrity constraints, ... to 4 separately-running-but-pipelined stored procedures, ... A typical user would enact a 100 or so business functions per day. ... own stored procedures' by storing the SQL for every business query in the DBMS ...
    (comp.lang.java.programmer)