Auto-refresh the output of the 'Open Table" action

15 Mar 2006 9:43 PM

Gaetan

I checked the options in SQL 2005 Management Studio and it does not appear to be an
available functionality.

Is it possible to have the output of the "Open table" action to refresh the output at a
specified interval?

Thanks.

16 Mar 2006 12:52 AM

Andrew J. Kelly

Probably not as it was never designed for that. There are few reasons to
use that functionality in the first place. The query editior is far more
flexible and does not run the risk of editing data by mistake just from
viewing the data.

--
Andrew J. Kelly SQL MVP

Show quote

"Gaetan" <m*@somewhere.com> wrote in message
news:ge2h125kt8381rls43qv4ie3181j1c981r@4ax.com...
>I checked the options in SQL 2005 Management Studio and it does not appear
>to be an
> available functionality.
>
> Is it possible to have the output of the "Open table" action to refresh
> the output at a
> specified interval?
>
> Thanks.

16 Mar 2006 7:41 PM

Gaetan

I understand the limitations of "Open table". The Query Editor is far more flexible but
unless I missed something, it too does not allow the SQL statements to be auto-rerun at
configurable interval.

Show quote

On Wed, 15 Mar 2006 19:52:00 -0500, "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote:

>Probably not as it was never designed for that. There are few reasons to
>use that functionality in the first place. The query editior is far more
>flexible and does not run the risk of editing data by mistake just from
>viewing the data.

17 Mar 2006 12:18 AM

Andrew J. Kelly

Not as a built in feature but a simple while loop will do it for you. This
will rerun the query every to seconds for 10 loops. Or what ever you need
it to do.

DECLARE @X INT
SET @X = 0

WHILE @x < 10
BEGIN
SELECT *****

WAITFOR DELAY '00:00:10'
END

--
Andrew J. Kelly SQL MVP

Show quote

"Gaetan" <m*@somewhere.com> wrote in message
news:6kej12dd7b63n4cq7tr61j26iejd9g7pv9@4ax.com...
>I understand the limitations of "Open table". The Query Editor is far more
>flexible but
> unless I missed something, it too does not allow the SQL statements to be
> auto-rerun at
> configurable interval.
>
>
>
> On Wed, 15 Mar 2006 19:52:00 -0500, "Andrew J. Kelly"
> <sqlmvpnooospam@shadhawk.com> wrote:
>
>>Probably not as it was never designed for that. There are few reasons to
>>use that functionality in the first place. The query editior is far more
>>flexible and does not run the risk of editing data by mistake just from
>>viewing the data.