Thanks Grant....am clear now.....

This has given some direction but not serving my need exactly...

can any one please post any query( may be using dmv) to get unused objects list directly..

Nope..you misunderstood..

overlapping indexes are the indexes which overlapped over the columns...for example..if i have 3 indexes..

index 1 is on Table1 on col1,col2,col3

index 2 is on Table1 on col1,col2

index 3 is...

Second one is so sweet and fast as you....thanks again......

Wonderful coldcofee..you deserve a great Applause...

Thanking all for responses..

I did some work on this procedure..rewritten the code without using while loops...tried having tally table to insert the values from comma separated string into temp tables...

One more question which i missed in Original Post..

Does it require to have an index on FK columns. can any one please post possitives and negatives of having an index...

Thanks for the query. It works great.........

Is this you are looking for?

declare @tblStr varchar(max)

declare @intMnth int

set @intMnth =1

while @intmnth < 12

begin

set @tblStr = 'CREATE TABLE [dbo].[DERInfo_2010'+cast(@intmnth as varchar(10))+'](

[trnxid] [int] IDENTITY(1,1) NOT NULL,

[DDate] [datetime] NOT NULL,

[TID]...

Thanks ALZDBA...

Thanks Bru..i donot have access to Server. i will ask DBA to set this permission..

Thanks....how / where to set the permission?

Thanks Bru...

Thanks bru for response..

One more thing i missed in my original post is...compatiblilty level for the DBs in SQL 2005 is set to 80. does it have any dependency on...

Thanks..I will try when i post next query ...