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.
  • Breadrumbs:
  • Refresh the Live Data View (Open Table View)

  • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • 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.