If this is a long term app, you'd be better off writing your own VB App, but
if this is temporary while you are debugging your query, you can create your
own "auto refresh" within QA by wrapping your query into a loop lie this:
begin
<your query>...
waitfor delay "00:00:05"
end
Thanks
Susan, Mel
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
> Andrew,
> Currently I'm using Query Analyzer, my query looks something like:
> SELECT LogTime, LogLevel, ModuleName, Message FROM Logs ORDER BY
LogTime
> DESC
> This is only something I'll use while developing these modules, and
although
> they will still be logging to the DB when they go "live", it will only be
> viewed if something goes wrong. Profiler might work, but is there any way
I
> can configure it to display columns for the data as query analyzer does?
> If only query analyzer had an auto-refresh...
> I'll have a look at the link you gave me, thanks... but I think I might
end
> up writing a small app to do this myself, shouldn't take too long... just
a
> datagrid a dataset and a timer...
> Alex
> > Don't know what type of info your looking to see but the only way I know
> to
> > do that for free and without writing code is to use profiler. You can
> > filter it so that it only looks for that specific table but this isn't
> > something I would use as a long term solution. There is a 3rd party app
> > from http://www.sqlpower.com/ that monitors network traffic that will
> > probably do something such as this and is relatively cheap.
> > --
> > Andrew J. Kelly
> > SQL Server MVP
> > > Hello all,
> > > Sorry for the cross-post, I have no idea what category this falls
under.
> > > I'm looking for a tool that will allow me to monitor records in a SQL
> 2000
> > > table as they are entered. Reason being I am writing an application
that
> > > sends logging output to SQL, and would like to view this output in
> > realtime
> > > without having to refresh a query in query analyzer or similar.
> > > I guess I could write a quick VB app with a datagrid that refreshes
> every
> > > second, but I dont want to reinvent the wheel.
> > > Is there anything out there (preferably free) that will do the job?
I'm
> > only
> > > monitoring a single table (no joins) ordered by a single field.
> > > Thanks,
> > > Alex
> > > < a l e x _ m 7 4 at h o t m a i l dot c o m >
by