can anyone pls tell me what this thing do

insert bulk dbo.test

Jose G. de Jesus Jr MCP, MCDBA wrote:
Looks like someone performed a bulk insert into a table called "test"
probably using the "Bulk Insert" command. Can you glean more information
from the application and user name?

if you run that statement in analyzer  it doesnt create an error.
it creates an error when you perform the next operation

if this is a bulk insert why does it reads "insert bulk  dbo.test"
why not the source statement. maybe becuase its unlogged

Show quoteHide quote

Jose G. de Jesus Jr MCP, MCDBA wrote:
Can you see what application and user executed the command? You can
probably back trace the command that way. There are very few unlogged
DML operations (with the small exception of some mods to text, ntext,
and image data that must be specifically coded for). It could be a
minimally logged operation. What event are you looking at?

Cursor working in this stored Procedure??
Best solution, iterate over millions records and call extended sp
convert INT
A difficult Combining Rows problem
very simple query problem