No announcements
Found 1841372 threads
-
0 VotesHow to audit actions on a particular database
http://blog.sqlauthority.com/2011/12/16/sql-server-2012-auditing-enhancement-on-audit-log-failure-options-maximum-rollover-files/ ...Answered | 2 Replies | 1213 Views | Created by Fluidetom - Thursday, December 5, 2013 9:06 AM | Last reply by Nigel Rivett - Thursday, December 5, 2013 9:20 AM
-
0 Votes
Auditing in SQL Server Reporting services
In order to achieve this, we need to connect to Report Server in SQL Server Management Studio.Answered | 3 Replies | 7337 Views | Created by Dheeraj Marwaha - Saturday, September 10, 2011 9:25 AM | Last reply by Elvis Long - Wednesday, September 14, 2011 1:43 AM -
0 Votes
Audit SQL Server 2005 Database Modifications, record IP source
SQL Server 2005/2008 is shipped with SQL PROFILER (Under performance tools).Answered | 5 Replies | 8515 Views | Created by SAMIR FARHAT - Wednesday, May 25, 2011 1:16 PM | Last reply by SAMIR FARHAT - Thursday, May 26, 2011 3:10 PM -
0 Votes
Auditing our SQL Server 2005/2008
What edition of SQL Server 2008 are you using?Answered | 2 Replies | 3534 Views | Created by JR SQL DBA - Sunday, August 21, 2011 9:55 PM | Last reply by Dan Guzman - Monday, August 22, 2011 2:41 AM -
1 Votes
AUDITINg IN SQL 2008
You can audit sysadmin users as you can do it for every other user, it don't make a difference.Answered | 3 Replies | 1150 Views | Created by SQL Kitchen - Sunday, August 24, 2014 9:15 AM | Last reply by Olaf Helper - Monday, August 25, 2014 9:29 AM -
0 Votes
specific Database auditing
Hi, Thanks Pradeep, is the same navigation for sql server 2005 Enterprise edition also?Answered | 11 Replies | 3994 Views | Created by Praneethy - Monday, September 19, 2011 7:03 AM | Last reply by Praneethy - Tuesday, September 20, 2011 8:37 AM -
0 Votes
SQL Login Password Change in Audit (SQL 2016)
USER_CHANGE_PASSWORD_GROUP is for users in a contained database who authenticate directly against the database.Answered | 5 Replies | 1931 Views | Created by xia0lin - Thursday, August 17, 2017 9:06 AM | Last reply by Erland Sommarskog - Friday, August 18, 2017 9:11 PM -
0 Votes
Audits of database query
Also the last (successful) login of users are not logged by default; you have to implement an audit logging on your own.Answered | 6 Replies | 899 Views | Created by Manoj Kumar Mahto - Thursday, August 21, 2014 5:24 AM | Last reply by Olaf Helper - Thursday, August 21, 2014 11:37 AM -
0 Votes
DATABASE AUDIT SPECIFICATION ON SPECIFIC USERS
Hi Han, Are your Windows login accounts member of the SQL Server sysadmin role?Answered | 2 Replies | 1317 Views | Created by Harn - Monday, March 30, 2015 7:23 AM | Last reply by Harn - Wednesday, May 6, 2015 2:21 AM -
0 Votes
Audit Report - Database and Instance
Dear Dhananjay, Please Find the link to create server audit in SQL Server 2012 How to set up and use ...Answered | 4 Replies | 859 Views | Created by Dhananjay Phadke - Monday, April 11, 2016 11:04 AM | Last reply by Chetan Vishwakarma - Monday, April 11, 2016 1:24 PM -
4 Votes
Database Audit feature logs SQL statements partially/trimmed, is this a bug?
Go to your SQL Server audit records, and you’ll figure it out. :-) If you have any other questions, please let me know.Answered | 6 Replies | 1458 Views | Created by Ekrem Önsoy - Wednesday, January 10, 2018 2:08 PM | Last reply by Ekrem Önsoy - Friday, January 12, 2018 6:42 AM -
0 Votes
Auditing an SQL Server 2005 prior to re-installation
I suggest that you back up ALL your user databases and system databases before installing SP4.Answered | 1 Replies | 2985 Views | Created by Sukh S - Saturday, August 11, 2012 9:43 AM | Last reply by Shahfaisal Muhammed - Saturday, August 11, 2012 3:55 PM -
0 Votes
Powershell: View Azure Database Audit log
Hi Sakurai, Please review the following documentation: Analyze audit logs and reports There is a means to manage Azure SQL ...Answered | 3 Replies | 1124 Views | Created by sakurai_db - Saturday, August 18, 2018 3:49 PM | Last reply by sakurai_db - Wednesday, August 29, 2018 3:27 PM -
0 Votes
No . of Logins in SQL Server Database
Hi All, I want to know how many users logged in to or accessed my database in a given time frame.Answered | 4 Replies | 923 Views | Created by Anuj Pareek - Wednesday, September 21, 2016 8:36 AM | Last reply by Shanky_621 - Wednesday, September 21, 2016 6:11 PM -
0 Votes
audit trail for permissions granted on sql server instance
In SQL Server 2005, one already exists in the Default Trace, but depending on how long ago the change was made it may have been rolled over and removed from the system.Answered | 2 Replies | 5764 Views | Created by sqlstar - Friday, July 23, 2010 7:27 PM | Last reply by Jonathan Kehayias - Saturday, July 24, 2010 12:28 AM -
0 Votes
Audit Trails / Digital Signatures in SQL Server
The feature that comes closest at hand is SQL Server Audit, but it is not available in all editions of SQL Server.Answered | 1 Replies | 733 Views | Created by kraemerpw - Sunday, January 7, 2018 4:26 PM | Last reply by Erland Sommarskog - Sunday, January 7, 2018 4:39 PM -
0 Votes
I need to audit just one login - server audit?
I don't believe Server Audit existed in SQL 2005 so that might not be a solution for all these versions.Answered | 7 Replies | 1180 Views | Created by pellet88 - Tuesday, March 24, 2015 11:26 AM | Last reply by Dan Guzman - Tuesday, March 24, 2015 12:17 PM -
0 Votes
SQL Server Login Auditing Setting Not Sticking
Hi Sundeev, Firstly, when you change the Login auditing settings in SQL Server Management Studio, it will call a stored procedure to ...Answered | 5 Replies | 1353 Views | Created by Sundeev - Wednesday, June 15, 2016 9:24 PM | Last reply by Lin Leng - Thursday, June 30, 2016 3:10 AM -
0 Votes
DATABASE Audit for SELECT statement [only] on a table
You can consider using SQL Server profiler and SQL Server traces (besides manual auditing), but it could get very complex and difficult.Answered | 3 Replies | 2438 Views | Created by Raju Angani - Wednesday, October 2, 2013 5:19 AM | Last reply by Phillipp Fleischer - Monday, October 14, 2013 8:21 AM -
4 Votes
audit
If you refer to the functionality incotruced in SQL Server 2008 called "Server Audit", then you decide where the audit is written when you create ...Answered | 7 Replies | 2183 Views | Created by SLNSH - Tuesday, May 28, 2013 2:00 PM | Last reply by TiborK - Wednesday, May 29, 2013 7:00 AM
No announcements
