To know database changes ---
SELECT *
FROM
    sys.dm_db_index_usage_stats AS usage_stats
INNER JOIN
sys.tables AS tables ON tables.object_id = usage_stats.object_id
WHERE
    database_id = DB_ID() AND
    tables.name in (select name from sys.tables)

Comments

Post a Comment

Popular posts from this blog

To know the max  size in SQL Server 2012 The maximum database size in SQL Server 2012 is: By FOR SQLSERVER Answer:   524,272 terabytes
Read more
Update one table from another table :- UPDATE #temp1 SET #temp1.t3=#temp 2.t3,   #temp1.t4 = #temp2.t4   FROM #temp1, #temp2   WHERE #temp1.row = #temp2.row
Read more
Comparing a value in between two columns I have a table TblControl. Data type of both field is int. StartRange End Range BMIClassification Table startval endvalue 0 100 200 300 500 600 900 950 SELECT StartRange, EndRange FROM Control WHERE 225 BETWEEN StartRange AND EndRange eg:- Declare @BMIValue int set @BMIValue=34 SELECT * FROM BMIClassification WHERE @BMIValue between startval and endvalue    
Read more