I'm a newbie to the site, but have been playing with SQL for some time now.
We recently upgraded from SQL7 to SQL2000 and now when I design a new view and use CREATE VIEW ... the code does not change to ALTER VIEW after compiling.
This worked fine before our upgrade. Any insites on this?