FMTONLY / BCP process hangs

[arrowhouse]

Dear All,

I am having an intermitent problem with BCP'ing data into a MS SQL 2000 database.

If I use dbcc inputbuffer to check what is happening with the process I can see the following:

SET FMTONLY ON select * from <owner>.dbo.<tablename> SET FMTONLY OFF

I think this should just return the column names to the process & let get on with the bcp in. But the process just hangs at this point. In Enterprise manager I can see that there are no blocking processes or other processes accessing this table.

This only happens for one particular table & does not always happen.

The bcp command is:

bcp <owner>.dbo.<tablename> in &quot;d:\bcpfilename.csv&quot; -Sserver -Uusername -Ppassword -c -t; -r\n -ed:\errorfile.err -E -m100

My hunch is that the SQL statement is where the problem is, that for some reason it gets stuck. Has any body seen anthing like this before?

Thanks

 

[arrowhouse]

Just in case someone gets this problem later.

The 'solution' we applied was to recreate the table. This was OK for us as it is a table we truncate & repopulate on a daily basis.

If anybody has seen this before I'd be really grateful to know of the cause & any less radical solutions.

Thanks.

Liz.