If you really want to be slick and save some work you could create the table as a datatable first then use SqlServer Management Objects to create the table at run time based on your in memory datatable. This only works with Sql2005 and Express2005, but it really save time in the code and verifies that what you have in memory matches with the database. If you are interested: http://www.codeproject.com/useritems/DataTableToDataBase.asp[^] Yes, this is one of my articles( currently my only one as I have been swamped) but SMO has become a pet project of mine as I am fascinated by it. Take a look and see if it helps. Aaron
_____________________________________________________________________ Our developers never release code. Rather, it tends to escape, pillaging the countryside all around. The Enlightenment Project (paraphrased comment) Visit Me at GISDevCafe