Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 

53 Results Found

SCRIPT

Trigger Generator for data audit

This Procedure generates 3 triggers (for Insert, Update & delete). The purpose of these triggers is to keep a SIMPLE audit trail. Create the table and the procedure in the database to which you want to have the auditing facility. To include a table for auditing run the procedure with Table Name as the parameter.

SCRIPT

Find Duplicate Indexes (Updated)

This script returns the Duplicate indexes on any database (if any). Compatible with SQL Server 2000 only. Latest update Checks for possible duplications and removes them. Further, additional fields are displayed to support decision making.

SCRIPT

Compare the structure & code of 2 databases

We often make changes in the test databases. But failure in making even the smallest change in the production database may lead to unwanted situations. This utility compares 2 databases. Parameters to be passed   @DB1  Database 1 (SysName)  @DB2  Databse 2 (SysName)  @ShowDifferentOnly see later (Bit)  Parameters 1, 2 may include server name as  well. But the server should be either local or linked server. This Procedure is devided into 2 parts  Part I Checks the tables and Vi...

SCRIPT

Script Generator for Triggers

This Stored Procedure creates the script of all existing triggers Optionally it creates the script to drop the triggers too. Triggers may belong to different owners. This procedure takes care of it. In SQLServer Enterprise Manager there is a facility to generate scripts for Tables, Views, Stored Procedures etc. But it won't generate script for triggers unless we include the tables/views too for scripting This will do the scripting only for triggers.

SCRIPT

DateDiff2 Function

A Modified Version of dateDiff.  DateDiff Fucntion checks the "datepart" only of the dates. This modified function returns how many "date part" is exactly passed.

SCRIPT

Get the Latest Currency Rate as at a date

Have you faced a situation where you want to have the latest currency rates available upto a particular date. Normally you may have to run sub queries but derived tables is the easiest way to do.

SCRIPT

Change the User Defined Data type

User Defined Data Types (UDF) is one of the useful concepts in SQL Server. However UDF can't be modified after they are being used. You would have to remove your User Defined Data Type from each table before you can change it. This will be a big job under certain circumstances. This procedure changes all tables when you change the UDF. At present I do this only for Tables. This procedure will work only if only tables refer the UDF.

SCRIPT

Compare the data of 2 Tables (Updated)

The SP compares the data in 2 tables and reports the different data. Tables could be from different servers, different databases or different schemas. This accepts 7 parameters 1, 2: Name of the 2 tables 3 : List only the differences 4. : Compare only the structure 5. : Check timestamp fields too 6. : Verbose mode 7. : Field List Thanks to: iecdba (Sript id 452) for giving the idea.

SCRIPT

Number serial Generation

This script generates seril numbers (0, 1, 2, 3.4,,,) In this example I use 0 - 9999

SCRIPT

Prime Numbers Generator (Updated)

This a modification to the script given by eugene_b. It generates prime numbers to the upper bound you specify. I have done some simple modifications to speed the process