SQLInsider Scripts

Technical Article

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,302 reads

Technical Article

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: )

588 reads

Technical Article

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: )

184 reads

Blogs

SQL Homework – October 2022 – Replication part 2

By

In August we started taking a look at replication. We learned some of the...

Function Vs. Performance

By

Recently I was looking through DBA.StackExchange when I saw a pretty simple question that...

Daily Coping 3 Oct 2022

By

Today’s coping tip is to write down three things you appreciate about yourself. I...

Read the latest Blogs

Forums

Data replication tools and review

By SQL Galaxy

Hello expertise, Could you please suggest best tool for database replication? data replication on...

Version Controlling Lambdas

By barakgodi

I know there are lambda versions. But I want to know if this can...

subscriber part of ALWAYSON

By SQL Galaxy

Hi. Publisher stop sending transaction to AOAG primary replica whenever AG failover.  It seems...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers