You can still use SSNS to get your 'updates'. If the app is reading from the database, then it depends on how the database is being populated. If the populating procedure locks the table, then the app will need to wait. If it's doing a nolock or a transaction isolation level read uncommitted, then your app will get data regardless of the update which may mean that some rows are out of date.