No announcements
Found 1841427 threads
-
2 Votes
Is SQL Audit at database level only for Enterprise Edition?
All editions of SQL Server support server level audits.Answered | 3 Replies | 924 Views | Created by SQL Server dude - Wednesday, November 12, 2014 12:48 AM | Last reply by SQL Server dude - Wednesday, November 12, 2014 5:47 PM -
0 Votes
Auditing User Activity in SQL Server 2008 Enterprise
SQL Server 2008 has introduced Database Level Auditing , Create an Audit First and then Create Database Level Audit U can ...Answered | 8 Replies | 15167 Views | Created by kaitlyn77 - Friday, April 2, 2010 9:39 PM | Last reply by Daniel José - Friday, May 20, 2011 11:32 AM -
0 Votes
Auditing changes in SQL Server 2008
yes audit supports cehck this ...Answered | 2 Replies | 2181 Views | Created by Shahriar Khwaja - Thursday, October 10, 2013 8:26 AM | Last reply by Ramesh Babu Vavilla - Thursday, October 10, 2013 8:31 AM -
1 Votes
ALTER DATABASE AUDIT SPECIFICATION
Hi, I've created a database audit in SQL2008R2 and now can't seem to disable/delete it.Answered | 2 Replies | 1451 Views | Created by The real Slartibartfast - Monday, April 20, 2015 12:41 PM | Last reply by The real Slartibartfast - Monday, April 20, 2015 2:40 PM -
1 Votes
Using Sql Server Audit
SQL Server auditing infrastructure is design to notify about permission usage (both positive & negative attempts to access a resource).Answered | 1 Replies | 6891 Views | Created by Hal Diggs - Monday, November 1, 2010 6:37 PM | Last reply by Raul Garcia - MS - Monday, November 1, 2010 7:12 PM -
0 Votes
Single or Separate database for Audit
There is no technical difference between having the audit/history tables in the same or different database on the same server.Answered | 4 Replies | 1584 Views | Created by Shreepal Bhandari - Wednesday, September 21, 2016 5:20 AM | Last reply by Tom Phillips - Wednesday, September 21, 2016 12:01 PM -
1 Votes
SQL 2008 Last Login Auditing and Server Audit
Hello, You also forgot: Server Side Trace - Audit:login, etc.Answered | 2 Replies | 6944 Views | Created by Forrestsjs - Tuesday, June 26, 2012 10:56 PM | Last reply by Forrestsjs - Tuesday, July 3, 2012 9:24 PM -
0 Votes
SQL Server 2008- All Action Audit and Performance
Based on the test, SQL Server Audit performs significantly better than a comparable SQL Trace which is used in the past SQL Server versions.Answered | 1 Replies | 6790 Views | Created by Madhu K Nair - Saturday, February 13, 2010 2:00 AM | Last reply by Xiao-Min Tan – MSFT - Monday, February 15, 2010 5:59 AM -
2 Votes
Auditing Database create or remove
Hi, BACKUP_RESTORE_GROUP would be better for the server audit.Answered | 6 Replies | 2561 Views | Created by cedric.beaujon - Wednesday, August 1, 2012 8:17 AM | Last reply by cedric.beaujon - Thursday, August 2, 2012 8:00 AM -
0 Votes
Database audit for 1 table
This type of audit triggers fires upon INSERT, UPDATE and DELETE statements, as well on stored procedures that execute DML like operations Here is a good article on this ...Answered | 6 Replies | 2124 Views | Created by happy2bb - Tuesday, September 24, 2013 9:09 AM | Last reply by William-Johnson - Thursday, October 3, 2013 11:35 AM -
0 Votes
SQL Server Auditing on DDL Activities
I would really like if the server audit specification could at least to the DDL auditing by all users, capturing the full DDL change code.Answered | 10 Replies | 13263 Views | Created by Chreddy S - Friday, September 16, 2011 11:42 AM | Last reply by SQLGator - Friday, February 8, 2013 8:59 PM -
0 Votes
Auditing SQL 2005
This sounds like a good reason to upgrade to SQL Server 2008 Enterprise.Answered | 4 Replies | 8484 Views | Created by SUB77 - Monday, April 11, 2011 5:35 PM | Last reply by Rick Byham, Microsoft - Monday, April 11, 2011 10:21 PM -
0 Votes
SQL server audit to capture multiple objects?
Satya, I don´t thing that this is able with only SQL Server, thing this: Imagine if every insert, update or deleted will be ...Answered | 1 Replies | 3623 Views | Created by Satya Krishna - Monday, September 12, 2011 3:00 PM | Last reply by Fabrizzio Caputo - Monday, September 12, 2011 5:21 PM -
0 Votes
SQL Auditing
If i am using LOGIN_CHANGE_PASSWORD_GROUP at database level specification.Answered | 3 Replies | 935 Views | Created by kumar J - Thursday, September 17, 2015 7:43 PM | Last reply by Lydia Zhang - Monday, September 21, 2015 4:02 AM -
0 Votes
Audit of Grants on objects and database roles
Hi, In this scenario, You can go with SQL Server Audit setup.Answered | 1 Replies | 836 Views | Created by grajee - Tuesday, May 3, 2016 7:35 PM | Last reply by bhanu_nz - Tuesday, May 3, 2016 9:26 PM -
1 Votes
Audit Changes Made To SQL Server Table
Hi , Try below links ...Answered | 2 Replies | 1506 Views | Created by IndigoMontoya - Thursday, November 14, 2013 9:38 PM | Last reply by SathyanarrayananS - Friday, November 15, 2013 4:06 AM -
0 Votes
SQL Audit
Hi j.kumar, For all target types(*.sqlaudit file, security log, or application log), the captured audit information is the same.Answered | 3 Replies | 1144 Views | Created by kumar J - Thursday, September 17, 2015 7:51 PM | Last reply by Lydia Zhang - Monday, September 21, 2015 3:35 AM -
0 Votes
SQL Server 2000 auditing on DML changes on user tables to user databases
Hello, You can use triggers as shown in the following ...Answered | 1 Replies | 900 Views | Created by Karunakar Kotha - Wednesday, August 27, 2014 10:42 PM | Last reply by Alberto Morillo - Wednesday, August 27, 2014 11:04 PM -
1 Votes
Auditing SQL Server 2005 Standard Database on Insert Update and Delete operations
A Default trace is available on SQL Server 2005, which you can use to find out DML statements which were executed against the server.Answered | 4 Replies | 2258 Views | Created by Ragu Thangavel - Monday, February 11, 2013 7:15 AM | Last reply by Neil401 - Tuesday, February 12, 2013 11:13 AM -
0 Votes
SQL Server Auditing - Free Reports
SQL Server 2005 Performance Dashboard Reports.Answered | 2 Replies | 7236 Views | Created by Prasanna Prabhu - Thursday, December 30, 2010 11:20 PM | Last reply by Alex Feng (SQL) - Friday, December 31, 2010 8:05 AM
No announcements