How can I stop SQL Server Management Studio replacing 'SELECT *' with the column list ?
- by Ben McIntyre
SQL Server Mgmt Studio is driving me crazy.
If I create a view and SELECT '*' from a table, it's all OK and I can save the view.
Looking at the SQL for the view (eg.by scripting a CREATE) reveals that the 'SELECT *' really is saved to the view's SQL.
But as soon as I reopen the view using the GUI (right click modify), SELECT * is replaced with a…