track all the versions of stored procedure which is modified multiple times

If a stored procedure is modified 10 times , i want to log or track it in a table in a column in 10 rows from initial stored procedure to the latest that is 10 different versions of the same stored procedure , could any one suggest how to do this?

-------------Problems Reply------------

You don't say which version of SQL server you're using, but have you looked at DDL triggers?

I know I'm not directly answering your question, but did you consider using a source control tool for it? Like svn, source safe, ...

In case you are using dot net it will be a good idea to create a Database project where you can store the SP as well as scripts for all other objects and use some source control where you will be able to maintain version history.

Category:sql server Views:0 Time:2009-05-14

Related post

  • What's the name of MS's (ongoing?) embedded (serverless) SQL Server version with stored procedures support? 2011-05-27

    Some months ago I've read an announce of Microsoft to be going to release an embedded (serverless, linked to an application as a library/assembly and using a simple file to store data) SQL Server version to replace (for those needing this, not to rep

  • Is it possible to determine when a stored procedure was last modified in SQL Server 2000? 2008-10-02

    I know that you can do this in SQL Server 2005, but I'm at a loss for 2000. --------------Solutions------------- Not to my knowledge. To get around this, I manage my stored procedures in a Visual Studio database project. Every stored procedure is in

  • SQL Server 2005 seperate stored procedure CSV value into multiple columns? 2010-09-28

    I'm a SQL Server 2005 newb and I have to do something that should be easy but I'm having difficulties. For the time being my stored procedure is storing csv in one column in my db. I need to break apart the csv into multiple columns. The number of va

  • Stored Procedures - How to return multiple values after an Insert 2010-11-17

    I'm trying to write a Mysql Stored Procedure that returns two values after inserting a record. I want it to return the auto-generated ID and the value of one column. How would I go about doing this? Here's what I got so far: delimiter // drop procedu

  • Wish to observe stored procedures that exist on multiple database and across multiple servers 2011-05-25

    Having an issue on MS SQL 2005 Enterprise multiple servers where I want to get a collection of meta data across multiple servers and multiple databases. I saw on Stack Overflow a good example on using the magical sp_MSforeachdb that I altered a littl

  • sql stored procedure - Having problems retreiving multiple rows of data with Idatareader 2011-06-09

    I have a stored procedure that does this: SELECT TOP 4 FROM dbo.test (table contains 5 rows) My c# code is: IDataReader test= ((IDataReader)(DataProvider.Instance().ExecuteReader("fetchtest"))); test.Read(); title1.Text = test.GetString(0); title2.Te

  • How do I find out when a stored procedure was last modified or compiled in Oracle? 2008-11-17

    I'm preferably looking for a PL/SQL query to accomplish this, but other options might be useful too. --------------Solutions------------- SELECT LAST_DDL_TIME, TIMESTAMP FROM USER_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE' AND OBJECT_NAME = 'MY_PROC'; L

  • stored procedure in MYSQL with multiple row fetching is not working? 2011-11-29

    I created one procedure called Sample1 delimiter ;; drop procedure if exists Sample1;; CREATE PROCEDURE Sample1(IN lft1 INT,IN rgt1 INT) BEGIN declare emp1 VARCHAR(20); SELECT emp into emp1 FROM personnell WHERE lft>lft1 and rgt < rgt1; insert

  • Version changes for Stored Procedures 2009-08-06

    I have an application that relies very heavily on stored procedures (SQL 2005/2008). We are doing a minor update that will modify 25-35 of these stored procedures. The application is such that both versions of the stored procedure must be available.

  • versioning stored procedures/PLSQL? 2010-03-05

    Is there an efficient way to version store procedures written in PL/SQL? (I only mention PL/SQL because there may exist a particular tool, any answer directed to versioning of stored procedures is ideal). --------------Solutions------------- In my cu

  • How do you manage and organize you stored procedures 2008-12-04

    How do you organize your stored procedures so you can easily find them and keep track of their dependencies? --------------Solutions------------- I tend to name them according to a convention. Typically {TableName}_{operation}{extra} where the extra

  • Disadvantage of stored procedures 2008-10-22

    Would like to get a list of advantages and disadvantages of using Stored Procedures. The main advantage of SPs seems to be precompiled and an abstraction of data from the application. Give me your thoughts.... --------------Solutions------------- Cor

  • Stored Procedures - End of days 2008-10-24

    I’m listening to the Hanselminutes Podcast; "StackOverflow uses ASP.NET MVC - Jeff Atwood and his technical team". During the course of the Podcast they are speaking about SQL server and say something along the lines of 'The days of the Stored Proced

  • Exporting/Importing Stored Procedures between DBs 2009-01-15

    I have two SQL Server 2005 databases, one is for development and the other is on the final production server. I would like to know the fastest way of ensuring that the production database has the exact same stored procedures (number and most recent v

  • When is it better to write "ad hoc sql" vs stored procedures 2010-04-29

    Possible Duplicate: Inline SQL vs Stored Procedures I have 100% ad hoc sql through out my application. A buddy of mine recommended that I convert to stored procedures for the extra performance and security. This brought up a question in my mind, besi

  • Ad hoc queries vs stored procedures vs Dynamic SQL 2010-05-29

    Ad hoc queries vs stored procedures vs Dynamic SQL. Can anyone say pros and cons? --------------Solutions------------- Stored Procedures Pro: Good for short, simple queries (aka OLTP--i.e. add, update, delete, view records) Pro: Keeps database logic

  • Calling stored procedure from Java / JPA 2010-08-26

    I am writing a simple web application to call a stored procedure and retrieve some data. Its a very simple application, which interacts with client's database. We pass employee id and company id and the stored procedure will return employee details.

  • SQL Server error logging from a Stored Procedure 2011-04-21

    Our application is Windows Service (native .EXE written in C++) that calls stored procedures in SQL Server. In most cases errors in stored procedures (in 90% of the cases these errors mean something was wrong in our business logic) are re-thrown as e

  • SQL Server last called stored procedures with parameters 2012-03-21

    I am using ASP.NET environment. Is it possible to track last N number of stored procedures called with parameters info? I see in this article "Recently executed stored procedures";

Copyright (C), All Rights Reserved.

processed in 0.686 (s). 11 q(s)