Thanks using this style SQL worked :

InsertCmdRefreshCmd="SELECT f_IDENTITY, f_TIMESTAMP FROM #CAAutoRefreshDemo WHERE f_IDENTITY=@@IDENTITY"


>Hi Patrick,
>
>You don't have to wait for the final release and you don't have to use ADO to try the AutoRefresh functionality.
>Mark's example sets INSERTCMDREFRESHCMD property to an incorrect command:
>

>INSERTCMDREFRESHCMD = [SELECT KeyID, Last_Update FROM Presidents]
>

>