SqlTableDependency Permission Issues
<p>I am trying to use the SqlTableDependency class  in my C# .Net application and I am unable to grant myself the required database permissions needed. Specifically, I need permissions: </p>

<ul>
<li>ALTER</li>
<li>CONTROL</li>
<li>CREATE CONTRACT</li>
<li>CREATE MESSAGE TYPE</li>
<li>CREATE PROCEDURE</li>
<li>CREATE QUEUE</li>
<li>CREATE SERVICE</li>
<li>EXECUTE</li>
<li>SELECT</li>
<li>SUBSCRIBE QUERY NOTIFICATIONS</li>
<li>VIEW DATABASE STATE</li>
<li>VIEW DEFINITION</li>
<li>CONNECT</li>
</ul>

<p>The error message states:</p>

<blockquote>
  <p>"An unhandled exception of type
  'TableDependency.SqlClient.Exceptions.UserWithNoPermissionException'
  occurred in TableDependency.SqlClient.dll. Additional information:
  User with no CREATE MESSAGE TYPE permission"</p>
</blockquote>

<p>I have tried granting myself the permission using this query:</p>

<pre><code>GRANT CREATE MESSAGE TYPE TO dbo
</code></pre>

<p>but I get this error:</p>

<blockquote>
  <p>"Cannot grant, deny, or revoke permissions to sa, dbo, entity owner,
  information_schema, sys, or yourself."</p>
</blockquote>

<p>I have confirmed that dbo is the owner of my database.</p>

<p>I am running Sql Server 2008 R2.</p>

<p>How can I grant myself permissions to my server?</p>