Friday, March 9, 2012

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,
>

No comments:

Post a Comment