SQLTeam.com | Weblogs | Forums


Running out of space due to the size of the WS_Logging_ db. I shrank the db. I also found the largest tables When I look at the data in most of these tables the machineID is from a separate sharepoint server we don't use for sharepoint any longer. The userLogin is the login from an ex admin. How can I find the task or job that is sending info to this db and the tables? Can I just delete the tables as there are over 500,000,000 records that are from an invalid user and invalid machine?

Run a profiler for busiest activity time of that account. Could there be something: sql service, web service or anything else running under ex admin's account?

is ex admin's account still active in Active DIrectory?