A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...
450793 – Import Wizard in SQL 2005 cannot import from text file that was exported from SQL 2000 The current UI enforces a maximum of 1000 sampled rows so there is no way for a customer to scan more ...
I'm an Oracle DBA for a large software company. We have many customers using Oracle but some of our older software has installed user bases on both SQL Server 2000 and SQL Server 2005. I don't know ...