Why don't you try to get the distinct entries first

Select credcardno, ccname, Count(*) from findets Group by credcardno, ccname

Please check whether you have proper indexes. I suggest you to on...

Try this:

Update syscolumns Set Colstat=0 Where id = object_id(<your table Name>) and name =(,Identity Column Name>)

Warning: Microsoft does not recommend directly modifying the system tables

there are a few scripts available at SQLServerCentral.com

try one (It is mine so that I may help you)

http://www.sqlservercentral.com/scripts/contributions/221.asp

There are a few other scripts as well. Please try some...

1. identity columns can't have null values

2. To change an identity column into another one add another column with same data type, update the new columns value and remove the...

In most of the cases I handle this type of situation from the client.

If you use ADO connection to connect to the database It has a Commandtimeout property

You can set...

--Try this Procedure

Create Procedure CreateTable (@Table sysname, @Target sysname, @Condition varchar(1000))

As

Declare @sql varchar(8000)

Select @sql =''

Select @sql = @sql +', '+

Case

when...

I use a different method.

I use one temporary table with an additional field (Session_ID)

This Session ID isgenerated by the application.