News

Created this SPROC after realizing that SQL Server does not provide a way to programatically create DDL for tables / views. The only way that I am aware of to get this information in SQL Server is ...
Includes all available fields, including non-default v3 and v4 fields. NOTE: VPC flow fields must be configured in the order listed when configured, if they were configured in a different order you'll ...
The new triggers that we are discussing now fire in response to DDL events, for example CREATE TABLE. Hence they are called DDL triggers. The code samples presented here run on an instance of SQL ...
If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...
The new triggers that we are discussing now fire in response to DDL events, for example CREATE TABLE. Hence they are called DDL triggers.