<div>
Well, you dont get to see what actually changed, jut that the query registered resulted in a change event.<br />
<br />
That change event is telling you to reload the page (essentially), it is not saying that the third column has been updated from 3 to 4<br />
<br />
Does that make sense ?<br />
<br />
If you want to keep track of specific changes, you might need to look at CDC : <a href="https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server" rel="ugc">https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server</a>&nbsp;but, what you have with SQL Dependancy (from your last question) should suit your purposes....
</div>


Well, you dont get to see what actually changed, jut that the query registered resulted in a change event.

That change event is telling you to reload the page (essentially), it is not saying that the third column has been updated from 3 to 4

Does that make sense ?

If you want to keep track of specific changes, you might need to look at CDC : https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server [https://docs.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-data-capture-sql-server] but, what you have with SQL Dependancy (from your last question) should suit your purposes....

nmiller61

<div>
<div class="content wysiwyg-content">
I have been working with SQLDependency to address a business rule problem. One of my last problems I am encountering is, &quot;How can I see what record got added or updated from using SQLDependency?&quot;<br />
<br />
I have an example MVC Project using SingalR to automatically refresh a page but not sure how to see just the changed data.
</div>
</div>


I have been working with SQLDependency to address a business rule problem. One of my last problems I am encountering is, "How can I see what record got added or updated from using SQLDependency?"

I have an example MVC Project using SingalR to automatically refresh a page but not sure how to see just the changed data.

SQLDepenency - Find out what changed or was inserted

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Microsoft’s ASP.NET MVC is a web application framework that implements the model–view–controller (MVC) pattern. As an open-source software, it’s set apart from the ASP.NET Web Forms component, which is proprietary.

.NET MVC

T-SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft. It is used to develop computer programs for Microsoft Windows, as well as web sites, web applications and web services. Visual Studio uses Microsoft software development platforms such as Windows API, Windows Forms, Windows Presentation Foundation, Windows Store and Microsoft Silverlight. It can produce both native code and managed code.