|
Home > Archive > MS SQL Server > November 2006 > Import Data Status
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Import Data Status
|
|
| Tedmond 2006-11-15, 5:13 am |
| Dear all,
I need to copy data from one DB to another DB using the Import Data
function. When I started the transfer, it ran for a certain period then
stopped at around 50% of progress for few hours. The status shown in the
dialog is 608, another case is showing 703. What is the meaning of the
statuses? How can I get reference information about the statuses?
Thanks for any help!
Tedmond
| |
| Uri Dimant 2006-11-15, 5:13 am |
| Tedmond
I have no idea about these statuses . Consider using T-SQL to copy the data
between the databases
INSERT INTO db1.dbo.Table1 (col1,col2.....) SELECT col1,col2..... FROM
db2.dbo.Table2
"Tedmond" <Tedmond@discussions.microsoft.com> wrote in message
news:234701C5-E121-4499-B291- 3432C8917DA6@microso
ft.com...
> Dear all,
>
> I need to copy data from one DB to another DB using the Import Data
> function. When I started the transfer, it ran for a certain period then
> stopped at around 50% of progress for few hours. The status shown in the
> dialog is 608, another case is showing 703. What is the meaning of the
> statuses? How can I get reference information about the statuses?
>
> Thanks for any help!
>
> Tedmond
>
|
|
|
|
|