Re: Can I use profiler to watch a table from an application?

Tech-Archive recommends: Fix windows errors by optimizing your registry

OK, I'll forget the profiler idea

"Keith Kratochvil" <sqlguy.back2u@xxxxxxxxxxx> wrote in message
news:OUznc70zFHA.3408@xxxxxxxxxxxxxxxxxxxxxxx
> How do your applications insert and update data?
>
> If they insert/update multiple rows within one statement you will have to
> code your trigger in such a way as to handle that.
>
> If the applications insert and update data via stored procedures you could
> just add a second insert (or update) statement to the stored procedure so
> that the appropriate data would be added to your log table.
>
> I would stay away from the profiler trace idea. This is more for
> monitoring than for firing off events.
>
> --
> Keith
>
>
> "Graham Morris" <Graywing@xxxxxxxxxxxxxxxx> wrote in message
> news:%23tjrpF0zFHA.3720@xxxxxxxxxxxxxxxxxxxxxxx
>>I want to detect changes to the data. I am trying to minimise the impact
>>on the database schema - creating new columns in the table is completely
>>out I'm afraid, but I can get away with adding triggers.
>>
>> I was hoping that if I can tap in to a profiler trace, I can watch for
>> changes to the table. It seems though that I can't do this
>> programmatically the way the profiler interface does.
>>
>> "Keith Kratochvil" <sqlguy.back2u@xxxxxxxxxxx> wrote in message
>> news:e1ACFJzzFHA.1252@xxxxxxxxxxxxxxxxxxxxxxx
>>> Are you watching for changes to the table or to the data? If you are
>>> watching for data changes why not just add a column (or two or three)
>>> along the lines of
>>> Created datetime
>>> Updated datetime
>>> Processed datetime
>>>
>>> When data is insert or updated the corresponding column can be set with
>>> the current date. The application that would monitor the table could
>>> use these columns along with the Processed column to determine if it
>>> needs to do anything.
>>>
>>> --
>>> Keith
>>>
>>>
>>> "Graham Morris" <Graywing@xxxxxxxxxxxxxxxx> wrote in message
>>> news:%234sjY0yzFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
>>>>I need to create an application which watches for changes to one or two
>>>>tables in a SQL Server database.
>>>>
>>>> I originally considered adding a trigger to the table which would add a
>>>> row to another table recording some information about the change. This
>>>> second table would then be scanned by the application (it would delete
>>>> rows it had processed - in fact it would be a queue).
>>>>
>>>> However I was wondering if I could instead create a trace which the
>>>> application could monitor in real time. It seems that traces can be
>>>> created which are written to a file, but you have to stop the trace to
>>>> look at the file.
>>>>
>>>> Any suggestions?
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: ADO.NET paremeters
    ... The newline may be due to lack of spaces in the beginning of the call, ... and the profiler is just trying to find a place to wrap. ... This should be declared as a datetime parameter. ... then it is failing because it cannot parse what you are giving it. ...
    (microsoft.public.dotnet.framework.adonet)
  • Javascript minimizer and profiler
    ... I'm interested in two applications for javascript. ... but I am hoping to hear with which applications some of you guys have a good experience. ... The minimizer should make the javascript small. ... The profiler should show all functions, how much time was spent inside it, with and without calls to other methods, etc. ...
    (comp.lang.javascript)
  • Is C++ developed in Microsoft .NET Framework considered a .NET application?
    ... I am developing ANSI C++ applications using the following environment: ... Microsoft Development Environment 2003 Version 1.13088 ... What is the placement of my application. ... I'm asking this because I'm looking for a C++ profiler, ...
    (microsoft.public.vc.ide_general)