January 3, 2006 at 3:10 pm
I have a database (X) that was created before I started working here and it is being modified every day. I have checked store procedures in the databases where all our data is stored and VB programs and none seem to access this X database. Is there a way to check the log or something and find out what or how is this database being accessed/modified? We need to move it to a different server but don't know what will it affect.
January 3, 2006 at 3:17 pm
Run SQL Profiler. Set it to trace all T-SQL activity and apply a filter on the database name so that only this 1 database gets profiled.
January 4, 2006 at 9:26 pm
I would filter on the database ID instead. You can get that from sp_helpdb. I haven't ever gotten profiler to filter properly on the database name.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply