Hi got kind of situation, we have one sql user on the database now we need to figureout who is actually using it because we plan to delete it but not known exactly who is using it from application end. what is the best way to do it or trace it out using profiler or any other way to figureout it. I Need to know which applications are using it actively
What I done in the past is keep the database in READONLY for 3 weeks or so, if no complaints on updates/inserts/deletes then go ahead to keep in SINGLE-USER for next 3 weeks, so if no further complaints it is good to drop it.
I Cannot take the database into single user mode or readonly mode. because this databases are actively used But my problem is need to figureour which applications are connecting to server. i am using in the profiler , hostname loginname and application name , i can see host name but really icannot say which applicationis it using in the application it shows me like .net sqlclient data provider. jtds or Mocrosoft@windows @operatin system. it would not help me at all do we have any column filter to find out the actuall application touching ti.
