SQLInsider Scripts

A Simply way to implement Audit Trail in SQL 2005

  • Script

In a recent project, I need to record audit trail for some tables (for Insert, Update and Delete).Using SQL 2005's XML datatype and the XML support it is very covenienet to use triggers to perform the audit trail requirement. I create one table (Table_Audit)  to hold all audit trial data. One stored procedure is created […]

5 (2)

2007-09-20

3,282 reads

Get Foreign Key of all the tables for Sqlserver DB

  • Script

This script will create two views and select the data from the TableReferences view. This view will give list of all the foreignkeys of the selected database with its constraint name, the table name and column name(s) on which the constraint is created and the referencing table name and column name(s).

5 (2)

2006-09-25 (first published: )

582 reads

IP Numeric To String

  • Script

A user defined function that converts an integer value to an IP address in dot notation format. This is performed by promoting a 32 bit signed integer value to a signed 64 bit bigint and converted to a binary representation of the integer. The purpose of this script is to allow the storage of an […]

2005-11-01 (first published: )

180 reads

Blogs

The Constant and Constantly Changing Role of the DBA

By

I’ve been working in and around data for over 30 years now. My title...

Power BI Monthly Digest – June 2019

By

In this month’s Power BI Digest with Manuel Quintana [Blog | Twitter] and I...

SQLSaturday Pensacola 2019 Coming Soon, See You There

By

One of my favorite (and my first) SQLSaturday events, Pensacola is this weekend June...

Read the latest Blogs

Forums

unable to install SQL Server 2014

By Srinivas Sista

Hi, I am trying the install SQL Server 2014 enterprise edition on Windows 2016...

What's the CMK?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the CMK?

Spread the Word about Basic Security

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Spread the Word about Basic...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers