Thanks Lee. Will try the updated script.

Hi Lee,

am using your script to build the insert into statements for data export.. then when i run the generated script i see messages like..

Msg 1088, Level 16, State 11,...