Re: Identifying what Apps are using a database

From: Rick Sawtell (quickening_at_msn.com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 16:07:38 -0600

"Van Jones" <anonymous@discussions.microsoft.com> wrote in message
news:012401c4f75f$6fe0e520$a601280a@phx.gbl...
> I'm looking for a little insight on identifying what apps
> are updating a particular database. Basically we have a
> front end developed for the db but some people may have
> created Access dbs and processes in Access to do updates.
> I need to determine if this is happening since we may be
> moving the db to a different sql server. SQL Profiler
> would work, but it's hit and miss. Plus I'd have to let
> it run for a few days which would create a huge trace
> file. If I did let it run for a few days, I still may not
> capture and activity from Access if they didn't happen to
> run any Access updates during that time. Is there
> anything out there that can help me?
>
> Thanks,
>
> Van Jones

I would still go with Profiler. Take a look at the Filters tab. You can
do things like: NOT LIKE and add all of the known applications that will
log in. You can weed out just about all the activity that you don't want
to see. Then your trace file will not be enormous.

The other suggestion is to turn on profiler and ask everyone to hit the
server with their updates so that you can capture everything in one go.

Rick Sawtell
MCT, MCSD, MCDBA

Relevant Pages

  • Re: Identifying what Apps are using a database
    ... >> capture and activity from Access if they didn't happen ... >> run any Access updates during that time. ... >I would still go with Profiler. ... Then your trace file will not be enormous. ...
    (microsoft.public.sqlserver.server)
  • Re: Identifying what Apps are using a database
    ... >>I would still go with Profiler. ... Then your trace file will not be enormous. ... >>server with their updates so that you can capture ...
    (microsoft.public.sqlserver.server)
  • Re: Application Trace Profiler
    ... intercept the Trace statements of another running .NET application. ... OutputDebugString API. ... Take SQL Server Profiler as an example. ... process and capture Trace.WriteLine calls like in SQL Server ...
    (microsoft.public.dotnet.general)
  • RE: No Video Capture...Please Help
    ... Do you have any idea which Updates were conflicting with Image ... capture from the Cannon anymore. ... I hit capture in Movie Maker I get "An Unknown Error Has Occurred". ... computer using the same Firewire cable and MovieMaker so it's not the camera ...
    (microsoft.public.windowsxp.moviemaker)
  • RE: XP Updates and Video Capture problem using Pinnacle Moviebox DV f
    ... I have spent a lot of time on the phone with pinnacle tech support but have ... > killed any video capture using any capture software and Pinnacle Moviebox DV ... > times to a handful of possible updates. ... Microsoft wont listen to the problem. ...
    (microsoft.public.windowsxp.video)
Loading