Related Tags:
SQL SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. Learn More, SQL Server Management Studio (SSMS) SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server. Learn More, MSSQL Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. It's one of the three market-leading database technologies, along with Oracle Database and IBM's DB2. Learn More,

how to track down the recent updates that are made in my database ?

Description:I am using a cms and some recent updates are made in my mssql database , I have no clue about in which table record is inserted or updated !!!
any sql query which can help me in this regard

Posted by: | Posted on: May 28, 2018

1 answers

Replies

1

You can use following query to track the the recent updates in the database
 
SELECT OBJECT_NAME(OBJECT_ID) AS TableName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID('YourDatabaseName')

Replied by: | Replied on: May 28, 2018



Reply