title: How to add SQL Server 2008 admin
body: <p>Ok I don't know what I am doing wrong.</p>
  
  <p>I am connected to SQL Azure via SQL Server 2008.</p>
  
  <p>Later on, created a database called <code>MyDatabase</code> and added a few tables in it.</p>
  
  <p>So, I am trying to add another user who will have admin roles (update, drop...)</p>
  
  <p>I created user Michael:</p>
  
  <pre><code>CREATE LOGIN Michael 
  WITH PASSWORD = 'Some password';
  </code></pre>
  
  <p>and then:</p>
  
  <pre><code>CREATE USER Michael FOR LOGIN Michael;
  GO 
  </code></pre>
  
  <p>Now, I can connect to database server with <code>Michael</code> credentials and see the database, but I don't see any tables in it.</p>
  
  <p>Tnx in advanced! :)</p>
  
  <p><strong>EDIT:</strong>
  When i connect to SQL Azure Management it says the following:</p>
  
  <pre><code>The current user does not have VIEW DATABASE STATE permissions on this database.
  </code></pre>