At 07:54 AM 8/4/2004, you wrote: >Hi > >Does anyone know how to export a table in SQL Server 2k as a insert query? > >Rob Smith I have done this in the past with a free script I found. There are several out there and I found a couple that worked fine for me. You may want to try this one: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=279&lngWId=5 Wes