how to get list of tables, functions and stored procedure created last month in sql server

SELECT
        [name]
       ,create_date
       ,modify_date
FROM
        sys.tables where create_date >='03/01/2015'
       
       
       
       
        SELECT * FROM sys.procedures WHERE  create_date >='03/01/2015'

SELECT *
FROM sys.objects
WHERE type IN ('FN', 'IF', 'TF')  -- scalar, inline table-valued, table-valued

Comments

Post a Comment

Popular posts from this blog

How to Use Bing API c#

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)     {         BingService service = new BingService();         //foreach (ImageResult  result in response.Image.Results)         //{         if (!RadioButton1.Checked)         {             if (RadioButtonList1.SelectedItem != null)             {                 if (RadioButtonList1.SelectedItem.Value == "Videos")                 {                     SearchRequest request2 = new SearchRequest();                     request2.AppId = "83DFCBA3482E132EF9837E3B505DFD015773E909";                     request2.Query = TextBox1.Text;                     request2.Sources = new SourceType[]                 {                     SourceType.Video                 };                     SearchResponse response2 = service.Search(request2);                 }                 else                 {                     SearchRequest request = new SearchRequest();                     requ
Read more

Unable to add google gmail in iphone

Hello guys,                  i deleted my account and tried to add again but i was facing problem when i was entering my username and password then screen was flashing once then again go to choose option screen .  solution is you'll get micro second to save your setting . when you entered your details then screen will show save button upper right corner. then quickly press save button and you'll see your account has been added. thnx . hope it'll helpful.
Read more