. . .

Tag: SQL

SQL Server Audit

Who did what and when did they do it? SQL Servers has some fantastic audit capability but sometimes a client will want to hand craft their own and this script can act as a place to start. The script will create audit tables that will audit what your users are up to. The script has […]

Database documentation

Documentation is the bane of my life you design a fantastic database and someone tells you that they would like to know how it works, so the task begins. This script will take a look at the database and do the graft for you, if you have been well behaved and added descriptions to objects […]

Database CRUD scripts

The use of a database is always a good idea and not giving users any direct access to the tables is an even better idea but wrapping the tables with stored procedures that you can secure up by group membership is a little bit of a pain, this script will enable you to create all […]