AUDIT WITH A TWIST

First the SP_TABLECOMPARE was used from the site and all credit must go to the author (greate script). This script is for the creation of an audit trial. It is generic and can be used on any sql database. It deals with legasy naming conventions as well. The script creates the audit tables and triggers. […]

4.25 (4)

2007-03-13 (first published: )

1,326 reads

Blogs

Daily Coping 2 Dec 2020

By

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

SQL Database Corruption, how to investigate root cause?

By

Introduction: In this article, we will discuss the MS SQL Server database corruption.  So, first, we...

Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?

By

I have held various certifications through my DBA career, from CompTIA A+ certification back...

Read the latest Blogs

Forums

vbs failing

By Sailor

This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile =...

SQL Server Load

By narayanamoorthy.a

Hi, The application team is pushing more than 7 lakhs records per day to...

Converting minutes to hh:mm:ss

By DaveBriCam

I'm trying to develop a formula to convert minutes (my raw data) to hh:mm:ss...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

WHILE in R

See possible answers