[dba-SQLServer] SELECT INTO question

OK, you guys seem to disagree. :) Who's right????? ;) 

Susan H. 


SQL Server 2000 also fails with an error. I don't have SQL Server 2005 so I
can't test that.

James Barash 


In Jet SQL, the SELECT INTO statement will overwrite an existing table if
the target table already exists. I just checked SQL Server Express and it
did NOT overwrite an existing table -- the statement failed with an error. I
uninstalled SQL Server awhile back, so I can't check it -- can anybody tell
me how SQL Server responds?