Search SQL Server metadata

I need to search SQL Server's metadata for all stored procedures that were changed between specific dates.

So far I have following query that looking for specific value in the SP.

SELECT DISTINCT sysobjects.name AS [Object Name]
FROM sysobjects,syscomments
WHERE sysobjects.id = syscomments.id
and syscomments.text like '%Stock%'

In the example above I am looking for all SP that have word Stock in it.

But how can I search for all SP's that were changed between specific dates?

Answers


USE AdventureWorks;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspUpdateEmployeeHireInfo'
GO

source: http://blog.sqlauthority.com/2007/08/10/sql-server-2005-find-stored-procedure-create-date-and-modified-date/


Need Your Help

Using default constructors in C++

c++ class inheritance methods

Hi all I am in Intro to Programming and am a little unsure about member initialization and default constructors. We are learning the basics of classes and structures but we haven't even gotten to

replace all occurence of a string with a character using javascript

javascript regex string replace

I wan to replace all occurrence of a string with single quote but with str.replace it only replaces the first occurrence of the script:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.