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: Yesterday @ 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 @ 11:08 AM
Points: 5,992, Visits: 12,941
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: Yesterday @ 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 @ 11:08 AM
Points: 5,992, Visits: 12,941
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: Yesterday @ 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 @ 11:08 AM
Points: 5,992, Visits: 12,941
pleasure.

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

Post #1428986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse