Check Last Modified DateTime for An Object (Table,Stored Procedure,Trigger etc.) in SQL Server

preview_player
Показать описание
We as SQL Server developers send our DDL Scripts ( Add New Column, Drop some column from table, or Alter Stored Procedure) to DBA. After deployment we verify those changes and sometime it happens that the changes are not done. Maybe DBA has missed one of the script to run. If we can get the last modified date for object ( Table,Stored Procedure, View etc) that can confirm the changes are done on given date.

blog post link for scripts used in this video
  1. TechBrothersIT
  2. Check Last Modified DateTime for An Object (Table
  3. Stored Procedure
  4. Trigger etc.) in SQL Server
  5. SQL
  6. Server
Рекомендации по теме
Check Last Modified 0:04:23

Check Last Modified DateTime for An Object (Table,Stored Procedure,Trigger etc.) in SQL Server

How To Quickly: 0:01:05

How To Quickly: Change A File's 'Created' OR 'Modified' Date/Time

Salesforce: Query Cases 0:02:26

Salesforce: Query Cases based on Last Modified DateTime and Last Modified By User (2 Solutions!!)

How to get 0:00:40

How to get DATE from DATETIME in SQL

How do I 0:03:59

How do I get the modified datetime of a file in Python

How do you 0:03:23

How do you get a REFRESH DATE in your Power BI report???

Recursively touching directories' 0:03:08

Recursively touching directories' last modified datetime as the same datetime of the last...

Sharepoint: Get 'lastModifiedDateTime' 0:01:39

Sharepoint: Get 'lastModifiedDateTime' with MS Graph or REST

Array : glob() 0:01:11

Array : glob() - sort array of files by last modified datetime stamp

SQL : Getting 0:01:36

SQL : Getting DATETIME for rows inserted/Modified

How to Enter 0:01:03

How to Enter an Automatic Time Stamp into Microsoft Excel

Find last login 0:01:22

Find last login datetime for SQL Server login

C# : How 0:01:06

C# : How do I get the correct modified datetime of a FAT32 file, regardless of timezone in .NET?

Keep most recent 0:02:16

Keep most recent record on a table with Power Query | Improved solution

Automatically Add Date/Time 0:02:52

Automatically Add Date/Time to a Cell When You Enter || Record Date and Time when Value is Changed

SQL Query | 0:06:23

SQL Query | How to find employees hired in last n months | Datediff

Databases: Find tables 0:01:40

Databases: Find tables with modified data after a specified datetime

How to Automatically 0:03:47

How to Automatically Enter Date & Time After Data Entry In Excel

Get Date and 0:00:56

Get Date and Time From Current DateTime - SQL in Sixty Seconds #025

Date and Time 0:07:36

Date and Time in C# 10 and .NET 6 In 10 Minutes or Less

MVC - C# 0:00:40

MVC - C# - Check if DateTime is today

How To Timestamp 0:08:48

How To Timestamp Cells In Google Sheets

SQL : How 0:00:57

SQL : How to update datetime field to contain only the date or time part

SQL : How 0:01:07

SQL : How to update all datetime records to UTC time in a SQL Server database?

Комментарии
Автор

Just what I wanted to know. Concise. Thanks.

andrestevenson
Автор

Do you know how I can see which data set/row has been modified in which table if I want to reverse engineer a frontend function in order to automate it?

Vritas
Автор

how to add inserted date and updated date in already creating and updating table

sweetamruth