title: Why is my sqldependancy onchange event not firing?
body: <p>Why is my sqldependancy onchange event not firing ?
  I've enabled broker for my database and even changed database owners; still not firing.
  Here's my c# code :</p>
  <pre><code>            using (SqlConnection connection = new Sqlconnection(connectionstring))
              {
                  connection.Open();
                  SqlCommand sqlcommand= new SqlCommand(commandText, connection);                
                  
                  using (dependancyCommand)
                  {
                      SqlDependency dependency = new SqlDependency(sqlcommand);
                      SqlDependency.Start(commandText);
                      dependency.OnChange += new OnChangeEventHandler(dbChangeNotification);
                  }               `
   private void dbChangeNotification(object sender, SqlNotificationEventArgs e)
          {
               //do stuff
          }
  </code></pre>
  <p>and heres the script for my sql table :</p>
  <pre><code>SET QUOTED_IDENTIFIER ON
  GO
  
  CREATE TABLE [dbo].[USER_CART](
      [USER_ID] [int] NOT NULL,
      [PRODUCT_ID] [int] NOT NULL,
      [QUANTITY_BOUGHT] [int] NULL,
  PRIMARY KEY CLUSTERED 
  (
      [USER_ID] ASC,
      [PRODUCT_ID] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
  ) ON [PRIMARY]
  GO
  
  </code></pre>
  <p>any help would be appreciated</p>