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)
To send automatic email window services http://www.intstrings.com/ramivemula/articles/sending-automated-emails-asynchronously-using-a-c-windows-service-in-conjunction-with-database-email-records-part-ii/
Comments
Post a Comment