|
Home > Archive > MS SQL Server > March 2006 > what does the message after executing BULK INSERT mean?
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 |
what does the message after executing BULK INSERT mean?
|
|
| Quentin Ran 2006-03-24, 8:23 pm |
| Group,
when I execute the following statement:
BULK INSERT DBName.dbo.TableName from " C:\FolderName\FileNa
me.dat"
with (CODEPAGE = 'RAW', DATAFILETYPE = 'native', TABLOCK)
the Messages pane in Query Analyzer returns the following message:
(159358 row(s) affected)
(27 row(s) affected)
(159358 row(s) affected)
What do these messages mean?
Quentin
| |
|
| It doesn't look like you have insert trigger fired (based on your sample
query). To be sure, turn on Profiler and see what's going on.
--
-oj
"Quentin Ran" < remove_this_qran2@ya
hoo.com> wrote in message
news:ee$KPp5TGHA.736@TK2MSFTNGP12.phx.gbl...
> Group,
>
> when I execute the following statement:
>
> BULK INSERT DBName.dbo.TableName from " C:\FolderName\FileNa
me.dat"
> with (CODEPAGE = 'RAW', DATAFILETYPE = 'native', TABLOCK)
>
> the Messages pane in Query Analyzer returns the following message:
>
> (159358 row(s) affected)
>
> (27 row(s) affected)
>
> (159358 row(s) affected)
>
> What do these messages mean?
>
> Quentin
>
| |
| John Bell 2006-03-26, 8:23 pm |
| Hi
You probably have a trigger firing, although you are not specifying
FIRE_TRIGGERS.
John
"Quentin Ran" wrote:
> Group,
>
> when I execute the following statement:
>
> BULK INSERT DBName.dbo.TableName from " C:\FolderName\FileNa
me.dat"
> with (CODEPAGE = 'RAW', DATAFILETYPE = 'native', TABLOCK)
>
> the Messages pane in Query Analyzer returns the following message:
>
> (159358 row(s) affected)
>
> (27 row(s) affected)
>
> (159358 row(s) affected)
>
> What do these messages mean?
>
> Quentin
>
>
>
|
|
|
|
|