InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 21:23:23 GMT20http://www.sqlservercentral.com/Forums/Topic621839-59-1.aspx[quote][b]Beginner_2008 (3/5/2012)[/b][hr]Good article,I know to view audit logs, we can right click from SSMS to the audit specification and view them if the object has made the destination to a file. But how to view the audit logs, if the destination has given to windows/application log. Right now i am viewing the audit logs (given to windows/application log) going to event viewer and opening the windows logs. Is there any way that we view these right from SSMS?Thanks..[/quote]I do not have my audit files set up this way, so can not be sure, but have you looked under Management, SQL ServerLogs. here you can select logs for Windows NT, applicationTue, 06 Mar 2012 03:57:08 GMT440692 I am just a numberhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxGood article,I know to view audit logs, we can right click from SSMS to the audit specification and view them if the object has made the destination to a file. But how to view the audit logs, if the destination has given to windows/application log. Right now i am viewing the audit logs (given to windows/application log) going to event viewer and opening the windows logs. Is there any way that we view these right from SSMS? Thanks..Mon, 05 Mar 2012 13:12:59 GMTAchilieshttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxGreat article. Is there a way to roll over the logs on a time basis or manually?I'm thinking of some sort of DBCC ERRORLOG sp_cycle_errorlogequivilantThu, 11 Aug 2011 07:47:29 GMT440692 I am just a numberhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxBrian, thanks much for this article! It was exactly what I needed to get a test system going to explore what the audit offered. I had been fiddling with it to no avail, read your article, and had it running shortly thereafter.I was a little disappointed that the file export was to log format, I was hoping I could get it out as a CSV. There is the export function, I think I'll be looking in to automating dumping the contents to a text file.I think it's basically a good thing, but it still has some growth.Fri, 02 Apr 2010 00:30:31 GMTWayne Westhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxHi,Nice article....You have done good job....Thank you.....---------------------------------------[url=http://www.secure-bytes.com/Auditing+Tools.php]Auditing Tools[/url]Wed, 06 Jan 2010 23:46:09 GMTabbala2008http://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxThis may be one of the weaknesses in the Audit Object. I need to play around a bit more to see if you can capture the parameter, but at first glance, I'm not sure you can.Thu, 20 Aug 2009 20:41:47 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxHi Brian,Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.Ex. If some executed a query as follows:select name, age from dbo.employees where empno = 100.This above query is being audited as follows:select name, age from dbo.employees where empno = @1.How can I get the value of @1?Regards,Atiq RahmanSat, 08 Aug 2009 12:42:14 GMTAtiq Rahman-266579http://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxHi Brian,Very nice article. I was able to configure the auditing but I am not getting the parameter values in the audit.Ex. If some executed a query as follows:select name, age from dbo.employees where empno = 100.This above query is being audited as follows:select name, age from dbo.employees where empno = @1.How can I get the value of @1?Regards,Atiq RahmanSat, 08 Aug 2009 12:42:12 GMTAtiq Rahman-266579http://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxWhat are recommended options for auditing tools and/or utilities for people that are using the MS-SQL standard and web editions? We have a public facing web site where our biggest auditing need (in addition to what we can see in the regular OS event logs) is to track DBA actions.Mon, 11 May 2009 12:28:01 GMTandynoldhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxGreat article...Sun, 21 Dec 2008 01:49:48 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxWhat I said in the article was that just about every edition above Express *could* use it. But Microsoft chose to only put it in Enterprise Edition. For those of us who started using Standard Edition for 2-node HA clusters, this hurts. Standard Edition is economical and meets our needs. Enterprise Edition is pricey. But if we want to use the Audit object, we've got no choice but to use Enterprise. As far as alternatives, there's nothing similar to it in the other versions. Thu, 18 Dec 2008 11:38:01 GMTK. Brian Kelleyhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxYou mention that [b]SQL Server Audit object[/b] is available in any version of SQL other than Express, however, Audit is only available in 2008 Enterprise. Is there a water down version of auditing available in versions other than 2008. What alternatives are available to perform similar auditing when not using Enterprise edition?Thu, 18 Dec 2008 09:53:38 GMTanand.ramananhttp://www.sqlservercentral.com/Forums/Topic621839-59-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Security/65170/">Using the Service Audit Object in SQL Server 2008</A>[/B]Thu, 18 Dec 2008 01:23:17 GMTK. Brian Kelley