Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log File Viewer- 1000 records Expand / Collapse
Author
Message
Posted Saturday, March 9, 2013 12:03 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:43 AM
Points: 49, Visits: 178
hi All,


Using the Log file viewer in sql auditing i can see only 1000 record....How can we see more than 1000 records or earlier data...


thanks in advance
Post #1428921
Posted Saturday, March 9, 2013 1:06 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 6,073, Visits: 13,426
from msdn:

The number of rows that are displayed for audit logs can be configured on the SQL Server Object Explorer/Commands page of the Tools/Options dialog box


---------------------------------------------------------------------

Post #1428926
Posted Saturday, March 9, 2013 1:36 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:43 AM
Points: 49, Visits: 178
Thank you very much for you reply....is it posible to get the result using the Query result..?

Post #1428929
Posted Saturday, March 9, 2013 2:30 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 6,073, Visits: 13,426
hopefully this URL will get you started and answer your queries

http://msdn.microsoft.com/en-us/library/cc280728.aspx


---------------------------------------------------------------------

Post #1428937
Posted Sunday, March 10, 2013 7:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 19, 2014 3:43 AM
Points: 49, Visits: 178
Thank you George...Thank you very much.
Post #1428982
Posted Sunday, March 10, 2013 8:42 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:31 PM
Points: 6,073, Visits: 13,426
pleasure.

---------------------------------------------------------------------

Post #1428986
Posted Monday, October 5, 2015 6:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 2, 2016 9:33 PM
Points: 240, Visits: 445
To view a log file in SQL Server, the SQL log file viewer is a good option. In which we can perform audit, view and open log file tasks. But, to access these task we must have some permissions to connect to an offline log file. Also it is a very time consuming process. So, it is better to have a SQL log file viewer tool which gives a better result and saves your time.
Post #1725405
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse