> If you need a quick way to duplicate a table structure in SQL Server > and can't get into EM, you can use the following SQL: or this -- SELECT * INTO newtable FROM oldtable where 1=0 no subsequent truncate required who uses EM for this type of stuff anyway? QA rulez!! rudy