Index on Binary Checksum column

I've created a column with binary_checksum, then create an index on that particular column.

When I'm using DTS to transfer some data into that table, I've got this error message:

INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'

any leads?

ThanksI've done a normal insert via query analyser, it works fine.

Odd, after I removed the index, iDTS insert works fine again. :|
Is this a DTS bug? Or are there any settings in DTS I have to configure?

Index not showing up on receiving database after DTS

We have a DTS package from an MS ACCESS database to a SQL Server 2000 database. One of the tables ENGR_ITEM had an index on it in ACCESS, but you can't see it in the object list in Enterprise Manager. The only way you know the index is there is if you try to create a primary key on the table and then save it. It won't let you save it because it says it already has a primary key from the index. You would think you would be able to see it if it existed. Does anybody find that weird?If you run:
exec sp_pkeys 'your_table_name'
it should return the current pk for the table.
Or you can use objectproperty() function to check for existence of index/constraint on a table.
e.g.
select objectproperty(object_id('your_table_name'),'TableHasPrimaryKey')
See book online for more info on objectproperty() function.|||Thank you for your information on how to find the indexs/constraints on tables. Very helpful of you to provide that. I'm still wondering though why the index didn't appear in the Object Explorer. It obviously got created through the DTS package.

Index name conflict

i have a dts package that is going to run at night and pull data from
2 tables in an Oracle db and load it to 2 staging tables that my
package creates in sql server 2000. i then execute a few sprocs to
and columns, indexes, etc. after that all happens successfully i want
to delete the two production tables and rename the staging tables to
take their place.

the problem is that when i run the sproc to add the indexes,
constraints, etc i get an error because objects with the same name
exist on the 2 production tables. i can't delete the production
tables until the very last step. i thought about generating a random
number in my sproc and using it as the name of the index but that
seems crude and messy. any ideas?teddy_theo@.yahoo.com (Ted Theodoropoulos) wrote in message news:<f5682868.0308141318.7b16a1db@.posting.google.com>...
> i have a dts package that is going to run at night and pull data from
> 2 tables in an Oracle db and load it to 2 staging tables that my
> package creates in sql server 2000. i then execute a few sprocs to
> and columns, indexes, etc. after that all happens successfully i want
> to delete the two production tables and rename the staging tables to
> take their place.
> the problem is that when i run the sproc to add the indexes,
> constraints, etc i get an error because objects with the same name
> exist on the 2 production tables. i can't delete the production
> tables until the very last step. i thought about generating a random
> number in my sproc and using it as the name of the index but that
> seems crude and messy. any ideas?

It's not entirely clear from your email what your process is, but you
could use one set of names for the constraints etc. when they're on
the staging tables, then rename them after you rename the tables:

exec sp_rename 'StagingTable', 'ProductionTable'
exec sp_rename 'ProductionTable.StagingIndexName',
'ProductionIndexName', 'INDEX'
exec sp_rename 'StagingPrimaryKeyName', 'ProductionPrimaryKeyName',
'OBJECT'
etc.

If this isn't helpful, perhaps you could clarify the order of events
in your process, and give an example of where the names clash.

Simon|||i fixed the problem by creating another database and naming it
[dbname]_staging. not very elegant but it works.

Index Fill Ratio

Iâ'm trying to copy a very large amount of data about 10,000,000 records from
one table to another using DTS. And while Iâ'm doing the task although I can
select data from the destination table using the sql query analyzer, I canâ't
execute the same select statement using ADO connection through a web site.
Please advise A.S.A.P
Thanks and Best Regards,Hi
I'd doing such tasks at the end of the day where workload is off.
See TRANSACTION ISOLATION LEVEL in the BOL
"Ehab ELGEDDAWY" <Ehab ELGEDDAWY@.discussions.microsoft.com> wrote in message
news:4287D94F-12C2-40F3-8CFC-DD443400FB22@.microsoft.com...
> I?m trying to copy a very large amount of data about 10,000,000 records
> from
> one table to another using DTS. And while I?m doing the task although I
> can
> select data from the destination table using the sql query analyzer, I can?t
> execute the same select statement using ADO connection through a web site.
> Please advise A.S.A.P
> Thanks and Best Regards,
>

Index Fill Ratio

I’m trying to copy a very large amount of data about 10,000,000 records from
one table to another using DTS. And while I’m doing the task although I can
select data from the destination table using the sql query analyzer, I can’t
execute the same select statement using ADO connection through a web site.
Please advise A.S.A.P
Thanks and Best Regards,
Hi
I'd doing such tasks at the end of the day where workload is off.
See TRANSACTION ISOLATION LEVEL in the BOL
"Ehab ELGEDDAWY" <Ehab ELGEDDAWY@.discussions.microsoft.com> wrote in message
news:4287D94F-12C2-40F3-8CFC-DD443400FB22@.microsoft.com...
> Im trying to copy a very large amount of data about 10,000,000 records
> from
> one table to another using DTS. And while Im doing the task although I
> can
> select data from the destination table using the sql query analyzer, I cant
> execute the same select statement using ADO connection through a web site.
> Please advise A.S.A.P
> Thanks and Best Regards,
>

Index Fill Ratio

I’m trying to copy a very large amount of data about 10,000,000 records fr
om
one table to another using DTS. And while I’m doing the task although I c
an
select data from the destination table using the sql query analyzer, I can
t
execute the same select statement using ADO connection through a web site.
Please advise A.S.A.P
Thanks and Best Regards,Hi
I'd doing such tasks at the end of the day where workload is off.
See TRANSACTION ISOLATION LEVEL in the BOL
"Ehab ELGEDDAWY" <Ehab ELGEDDAWY@.discussions.microsoft.com> wrote in message
news:4287D94F-12C2-40F3-8CFC-DD443400FB22@.microsoft.com...
> Im trying to copy a very large amount of data about 10,000,000 records
> from
> one table to another using DTS. And while Im doing the task although I
> can
> select data from the destination table using the sql query analyzer, I can
t
> execute the same select statement using ADO connection through a web site.
> Please advise A.S.A.P
> Thanks and Best Regards,
>