title: creating view in sqlserver
body: <p>I trying to create view linking 2 tables admins and news</p>
  
  <pre><code>create view v_news as
  SELECT [n_id]
    ,[n_title]
    ,[n_detail]
    ,[n_date]
    ,[n_sdate]
    ,[n_edate]
    ,[n_admin]
    ,[a_name]
    ,[a_email]
    ,[a_role]
    ,[a_status]
  FROM hed2.dbo.hed_news,hed2.dbo.hed_admins
  where hed_admins.a_id=hed_news.n_admin
  </code></pre>
  
  <p>This message is displayed:     </p>
  
  <pre><code>Command(s) completed successfully.
  </code></pre>
  
  <p>but there is no view in VIEWS folder.</p>
  
  <p>When I try to run the same query again then it says:</p>
  
  <pre><code>There is already an object named 'v_news' in the database.
  </code></pre>
  
  <p>I am connected with windows authentication<br>
  I tried reconnect and restart sql server but ....</p>