Check the following article by Merrill

http://www.sql-server-performance.com/ma_finding_duplicate_indexes.asp

Could you check the data types of customerID coulmn in both the tables.

If the owner is 'dbo', your statement should work otherwise include (replace .. with .<>.) the schema name

Fetch all indexes using this script

SELECT

t.[name],

i.[name] as IndexName

FROM

SYS.INDEXES AS i WITH (NOLOCK)

INNER JOIN

SYS.TABLES AS t WITH (NOLOCK)

ON

i.[object_id] = t.[object_id]

INNER JOIN

SYS.INDEX_COLUMNS AS ic WITH (NOLOCK)

ON

i.[object_id] =...

Try with dynamic SQL

declare @t table (

item varchar(40)

)

insert into @t values ('foo')

insert into @t values ('foo')

insert into @t values ('foo')

insert into @t values ('foox')

insert into @t values ('foox')

insert into @t values ('fooy')

insert into...

update Customer

set address = LEFT (address, LEN(address) - CHARINDEX(',', REVERSE(address)))

Your Drop statement should be dynamic... EXEC ('Drop Procedure '+ @spname)

If you are using SQL 2005 and explore PIVOT operator

will wait untill execution of the called sp is completes.

declare @Table1 table

(

IDint,

Numberint,

DTvarchar(10),

[Name]varchar(10))

insert into @table1 values (1, 1, NULL, 'a')

insert into @table1 values (2, 1, NULL, 'b')

insert into @table1 values (3, 2, NULL, 'c')

insert into @table1 values (4,...

declare @t table (srno int)

insert into @t values (100001)

insert into @t values (100001)

insert into @t values (540053)

insert into @t values (550008)

insert into @t values (550008)

insert into @t values (550008)

insert into...

Yes. With SQL 2005. check DDL triggers.

alter Procedure testLoad

(

@FileName varchar(50),

@Logon varchar(20),

)

As

SET NOCOUNT ON

DECLARE @File_Exists int,

@textfile char(150), --> Should be varchar

@BusArea char(2),

@PayId char(3),

@login varchar(20),

@CycleNo char(15),

@FHBusArea char(2),

@FHPayId char(3),

@FHCycleNo char(15),

@TrBatchPoNo char(10),

@rename varchar(255),

--@file_extn datetime -- Should be varchar

@file_extn...

Use single select SELECT @BusArea, @PayId,@CycleNo instead of three select statements