Viewing 6 posts - 1 through 6 (of 6 total)
There's no script. SQLProfiler is an application which gets shipped with sql an allows you to trace activity on an SQL instance.
April 2, 2009 at 8:51 am
Sounds like an ideal solution would be to use the SQLProfiler, filtering on the Databases you require.
Try and limit what you select. Then you can see who access the...
April 2, 2009 at 7:29 am
Use SQL Profiler to track SQL events Login/Logout or even Prepare SQL stratements.
be careful to use the filter to limit the data returned or you'll have too much information to...
April 1, 2009 at 5:18 am
Using the procedure below enables us to check which DTS Packages are actually used and rename/delete unused packages after appropriate time to save confusion
create procedure RunPackage
as
declare
...
April 1, 2009 at 4:59 am
That is just the data file. The database is used for BI purposes and updated once a day therefore is set to simple recovery mode.
The machine...
March 20, 2009 at 11:03 am
the database is 28GB with 16GB free - will post on SQL2000 forum instead
March 20, 2009 at 10:50 am
Viewing 6 posts - 1 through 6 (of 6 total)