2018-08-18

Backup all databases in Microsoft SQL Server

Find here, a cool SQL script to backup all SQL Server databases. Of course, you can put it in a Scheduled Job to execute each ...
Posted in SQL ServerTagged ,Leave a Comment on Backup all databases in Microsoft SQL Server

SQL View to search in all columns of all tables

Often, I need to search a column name in a database… but I’ve not the table name. If you are like me, this SQL View ...
Posted in SQL Server, Tips and othersTagged Leave a Comment on SQL View to search in all columns of all tables

SQL Server Nested Triggers

This is my first post in English… so 😉 In our current project, we developed many SQL Triggers (on each tables). We diagnosed than when ...
Posted in SQL Server, Tips and othersTagged ,4 Comments on SQL Server Nested Triggers