CFF KB - Carrz-Fox-Fire Promotions Knowledge Base
CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.Knowledge Base
- Breadrumbs:
Refresh the Live Data View (Open Table View)
- Article ID:
123 - Date Created
Wednesday, March 23, 2011 - Last Updated
Wednesday, March 23, 2011 - This Article Has been Viewed
1651 times - Short Desc
When you view the Live Data sheet, otherwise known as the [Open Table] view within SQL Server, you may have the need to view the live data as it is happening. - Details
When you need to view the live data within the [Open Table] view of SQL Server 2005 (Other versions may also apply) - Recreate Issue
To recreate this issue:
Right click on your [Table Name]
choose [Open Table]
There is no [Refresh] button (or) menu option like you have in Microsoft Office Access. - Resolve Issue
To resolve this issue.
Right click on your [Table Name]
choose [Open Table]
Above the table you will see the red ! Explanation Mark.
Click it to get LIVE data streamed into the table.
Warning!
This may take some time to process depending on the amount of records within the table and rather you are connecting over lan or internet.
Share With Friends (Updated 6-8-2010)
Recent Articles
All Topics
- Coming Soon - Knowledge Exchange
Trending Articles
- Microsoft VBScript runtime error '800a0046' Permission denied FileSystemObject 24694
- Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. or The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. 21297
- ADODB.Parameters error '800a0e7c' Parameter object is improperly defined 19544
- After Effects warning: Audio conforming failed for the following file .cfa. Perhaps due to disk space 17785
- The backup set holds a backup of a database other than the existing 16825