14 September 2012

To know the stored procedure created date and modified date in Sql Server

To know the stored procedure created date and modified date in Sql Server
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'sp_name'  -- stored procedure name



-

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

Find number of letter occurence of all letter in c#

  Find number of letter occurence of all letter in c#  namespace ConsoleApp1 {     internal class Program     {         static void Main(st...