thanks Gail your solution worked for me.

Thanks Gail Shaw, the solution works for what i had posted.

But my appologies, actually the zoneid is passed as parameter in a sp and the sp has select query in...

Hi,

any one haas found a solution for this error. I am gettting the folwoogin error when i am trying to update the lookup table

Msg 6549, Level 16, State 1,...

thanks again

i got it using bcp as follows

bcp "select * from db.obowner.tablename" queryout c:\200520.txt -Sservername/instancename -T -E -c -CACP

but wanted to know where the option has gone in 2005

thanks

thanks

hi,

Thanks Michael

what you have suggested is correct.

I executed the query in 2k5 and saved the output to file.

then i opened the file in notepad and changed its encoding...

Hi,

I am sorry i dont have the URL for the following microsoft KB. But I have copy pasted it. Hope this helps. The material below ********** can be usefull...