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

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: Thursday, August 7, 2014 6:46 AM
Points: 49, Visits: 176
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: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
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: Thursday, August 7, 2014 6:46 AM
Points: 49, Visits: 176
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: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
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: Thursday, August 7, 2014 6:46 AM
Points: 49, Visits: 176
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: Thursday, August 21, 2014 3:52 PM
Points: 5,988, Visits: 12,923
pleasure.

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

Post #1428986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse