title: Error : When Using SqlDependency Without Providing an Options Value
body: <p>I am working on query notification. I have created <strong>Queue, Service</strong> and <strong>Route</strong> in my Database. I am accessing my Database on <strong>Network</strong> by <strong>IP Address</strong>, so i created a <strong>Route</strong> in <strong>Sql Server</strong> like this..</p>
  
  <pre><code>ALTER ROUTE [NotificationMessagesRoute]   
  WITH  SERVICE_NAME  = N'MyNotificationService' ,  
  ADDRESS  = N'TCP://myIPAddress:PortNo' --
  </code></pre>
  
  <p>on FrontEnd it have used SqlDependency like this..</p>
  
  <pre><code>SqlDependency dependency = new SqlDependency(command), "Service=MyNotificationService;local database=Test", int.MaxValue);
  </code></pre>
  
  <p>Its working Perfectly, if i am using <strong>Local Connection String</strong> and also <strong>Route</strong> in <strong>Sql Server</strong> as <strong>Local</strong>, but if i access DB on my organizations <strong>local Network</strong>, it do not show me <strong>notification</strong> on <strong>new Insertion</strong>.</p>
  
  <p>I have also used <strong>SqlDependency</strong> object as below, but it gives me below <strong>Error</strong>.</p>
  
  <pre><code> SqlDependency dependency = new SqlDependency(command);
  </code></pre>
  
  <p><em><strong>Error</strong> : When using SqlDependency without Providing an options value, SqlDependency.Start() must be called prior to execution of a command added to the SqlDependency instance.</em></p>
  
  <p>Plz Help...</p>