title: what this Error message "Incorrect syntax near the keyword 'VIEW'."
body: <pre><code>CREATE PROCEDURE ViewCreater
  AS
     BEGIN
     CREATE VIEW [V97] AS    
     SELECT title,type1,Tedat,DATEADD(DAY,-2,DATEADD(YEAR,-1,Tarikh))AS NewDate97, Descrip FROM Test1;  
  Go;
  </code></pre>