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

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

181 reads

Blogs

Daily Coping 27 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

How do I test if a linked server works using T-SQL?

By

I get that linked servers are almost as despised as the dreaded cursor or...

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Read the latest Blogs

Forums

identify sql backup strategies

By mtz676

how do I identify if the dbs are getting backed up (full,diff,log) without looking...

schedule a job in CMS

By mtz676

Is it possible to schedule a sql job in CMS ? As of now...

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers