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,290 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

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

T-SQL Tuesday Gifts (#121)

By

It’s that time of month. I missed last month while traveling, but I wanted...

Speakers wanted for the Richmond (VA) SQL Server Users Group – 2020

By

Are you a speaker in SQL Server topics? Come on out to Richmond, VA...

Read the latest Blogs

Forums

Opening and Closing balance of each activity

By farooq.hbs

<!--more--> Hi Guys, I am working on MySQL to get opening and closing balance...

SSRS 2016 Subscription File Share Option Doesn't Exist in Dropdown

By dlsql

Hi all, Having trouble finding anything specifically on this issue. Previously I have always...

revering columns into rows in a specific way

By sivaay1223

I have a table id    pid     aid    vid 8    1301 ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers