You can also trace SSMS (like any application) by running SQL Profiler in the background ... The new feature in 2008 is stopping the re-creation of a table by default. I used the ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

SQL Server Management Studio (SSMS) is the principal interface for ... explorer pane drill down and highlight a container, such as Tables. Then click View => Object Explorer Details from the ...