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
    1719 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.
  • Article 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.