How do you find when was a stored procedure last modified?

How do you find when was a stored procedure last modified?

You can use sys.proceedures to find the date of the most recent modification for stored procedures;

1. SELECT [name], create_date, modify_date.
2. FROM sys.procedures.
3. ORDER BY 3 DESC;

How can I tell when a SQL Server table was modified?

Columns

1. schema_name – schema name.
2. table_name – table name.
3. create_date – table creation date.
4. modify_date – last update time of table (by ALTER statement)

How can I tell who modified the SP in SQL Server?

In SSMS, right click on Server Name, choose Reports / Standard Reports / Schema Changes History. The list is in time order with most recent at the top.

How do I change a stored procedure?

Using SQL Server Management Studio

1. In Object Explorer, connect to an instance of Database Engine and then expand that instance.
2. Expand Databases, expand the database in which the procedure belongs, and then expand Programmability.
3. Expand Stored Procedures, right-click the procedure to modify, and then click Modify.

How to modify a stored procedure in SQL Server?

You create a stored procedure with a create proc statement. You modify a previously created stored procedure with an alter proc statement; this statement does not change the create_date column value in the sys.objects view, but it does freshly populate the modify_date column value.

How to track the creation of a stored procedure?

Two aspects of a stored procedure that you can track are when it was initially created and when it was last modified. You create a stored procedure with a create proc statement.

How to check date of last change in stored procedure or?

I found that in SQL Server 2000 it wasn’t possible to check modify date ( look at this post: Is it possible to determine when a stored procedure was last modified in SQL Server 2000?) Is it possible to check it in SQL Server 2008?

When to enable or disable alter procedure in SQL?

If the settings are different from those in effect when stored procedure was originally created, the behavior of the stored procedure may change. If a previous procedure definition was created using WITH ENCRYPTION or WITH RECOMPILE, these options are enabled only if they are included in ALTER PROCEDURE.