Sid_F
asked on
SQL scripts log
Is it possible to check if scripts have been run against a 2008 SQL database.
ASKER
Event viewer is vague. Can I specifically view if a script has been run against a database if the database has been setup with default options. I'm not sure if audit is default?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can read the Windows event logs by using the Event Viewer utility in Windows. For file targets, you can use either the Log File Viewer in SQL Server Management Studio or the fn_get_audit_file function to read the target file.
read this to find out more
http://technet.microsoft.com/en-us/library/dd392015%28v=sql.100%29.aspx
http://technet.microsoft.com/en-us/library/cc280386.aspx