Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Audit Script Expand / Collapse
Author
Message
Posted Thursday, September 23, 2010 5:36 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 30, 2010 1:44 AM
Points: 2, Visits: 6
Im new at sql...
We have a sql server 2000. SQL Profiler is not running on this server.
I need to info on/audit all scripts that were run (successfull or not) that was run for last month (august 2010)on all databases... Somebody/Anybody please assist.
Post #991911
Posted Thursday, September 23, 2010 7:48 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
imraanm (9/23/2010)
Im new at sql...
We have a sql server 2000. SQL Profiler is not running on this server.
I need to info on/audit all scripts that were run (successfull or not) that was run for last month (august 2010)on all databases... Somebody/Anybody please assist.



What were in that script which you have run last month(Aug 2010).

If you have run any sps,table,view,trigger etc.. script you can use the following query to get

Select * from sysobjects where month(crdate)=8 and YEAR(crdate)=2010

If you have inserted any datas in the tables it is not possible unless you have datetime column in the table you inserted.

Thanks
Parthi


Thanks
Parthi
Post #992022
Posted Monday, September 27, 2010 12:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, September 30, 2010 1:44 AM
Points: 2, Visits: 6
Parthi hi,

THank you for the reply. I have tried the script, and still not luck. Doesn't display the desired info.

Perhaps if you have a script to audit all the log_in to that database for August 2010, from there i can maybe 'dig' for more data?
Post #993457
Posted Monday, September 27, 2010 10:03 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
imraanm (9/27/2010)
Parthi hi,

THank you for the reply. I have tried the script, and still not luck. Doesn't display the desired info.

Perhaps if you have a script to audit all the log_in to that database for August 2010, from there i can maybe 'dig' for more data?


Doesn't display the desired info. What is the desire info ?
What do u need actually briefly explain.

I think u have to use 3rd party tool like Red Gate to know what datas are begin inserted in the DB.


Thanks
Parthi
Post #993776
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse