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
…