SqlTableDependency_Changed what permission

Question

User932259438 posted

Hi,

I have 2 database. One is from test with the same database: https://www.codeproject.com/Articles/1029976/SQL-Server-Notifications-on-Record-Change-with-Sig

void SqlTableDependency_Changed(object sender, RecordChangedEventArgs<Posts> e)
{
    if (e.ChangeType != ChangeType.None)
    {
        BroadcastStockPrice(e.Entity);
    }
}

and working exchange

I tried to use asp.net database with aspnet_membership with the same table tbl_posts and not working with the same example.

What permission I need?

Answer 1

User-832373396 posted

<g class="gr_ gr_8 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" id="8" data-gr-id="8">Hi</g> <g class="gr_ gr_5 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="5" data-gr-id="5">progy</g>,

What permission I need?

No, it doesn't need other permission.

I suggest that you could download it and run it on local ;

Download: https://github.com/christiandelbianco/monitor-table-change-with-mvc-signalR-jquery-sqltabledependency 

Then check what missed in your current code;

Good Luck :)

With regards, Angelina Jolie