This trigger will work even if you don't have the primary key on any table. Mechanism to configure the primary key in config table has been provided. This can be very helpful to solve the system audit requirements without much efforts.
Disclaimer : Audit Log trigger has performance overhead. It’s meant for table which is not frequently updated, deleted or inserted. Please take precaution when creating the trigger on the table having too many columns.
2019-10-15 (first published: 2019-10-10)
3,116 reads
Compare the content of two tables for differences
2019-10-14 (first published: 2018-08-28)
896 reads
Fix orphaned users on a restored db
2019-10-07 (first published: 2010-11-02)
3,490 reads
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2019-10-04 (first published: 2017-02-21)
1,414 reads
Calculates total length of services for a employee. Calculates( addition or subtraction) two internships in form of yy.mm.dd
2019-10-04 (first published: 2016-10-03)
503 reads
Data calculation in form yy mm dd
2019-10-04 (first published: 2016-10-03)
872 reads
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2019-10-04 (first published: 2017-02-21)
1,295 reads
The Resource name is most important information in the blocked process report.
The purpose of this script is to decode this information.
The script is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCLR.
2019-10-04 (first published: 2017-02-20)
2,034 reads
I am using database properties to add some useful information for each database. Tired of exploring each database from the menu in SSMS to look for specific information, I decided to make a script listing the extended properties for all my databases. I am pleased to offer this to the community 🙂
2019-10-01 (first published: 2019-09-20)
1,530 reads
Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.
2019-09-24 (first published: 2019-09-04)
3,740 reads
