No announcements
Found 2863608 threads
-
0 Votes
powershell for auditing Active directory users logged into SQL SERVER DATABASE.
For auditing the users and what they did, you can use a server audit.Answered | 6 Replies | 856 Views | Created by winnie aj - Tuesday, August 29, 2017 2:10 PM | Last reply by Tom Phillips - Wednesday, August 30, 2017 4:59 PM -
0 Votes
Audit Active Directory Group
There may be a way to determine AD Members in a Group from SQL Server; but if these logins are members of other AD groups with access to the same SQL ...Answered | 6 Replies | 1883 Views | Created by ArashMasroor - Saturday, July 2, 2016 11:40 AM | Last reply by Anthony C-UK - Monday, July 4, 2016 3:53 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 ...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
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 | 15235 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
SQL Server Audit Logs
To audit SELECT statements To audit changes in database settings , refer my answer inAnswered | 3 Replies | 2708 Views | Created by Siraj Ahmed Admin - Sunday, October 27, 2013 7:18 AM | Last reply by SathyanarrayananS - Monday, October 28, 2013 4:28 PM -
0 Votes
SQL user login activity log
Hello, You can use SQL Server Aduit to trace the user logging information from connection pool to the database server.Answered | 3 Replies | 4246 Views | Created by Jamal Meeran - Sunday, March 31, 2013 7:52 AM | Last reply by Jamal Meeran - Monday, December 16, 2013 6:47 AM -
0 Votes
SQL server and database auditing
Rick Byham, Microsoft, SQL Server Books Online, Implies no warrantyAnswered | 6 Replies | 1310 Views | Created by jori5 - Monday, July 13, 2015 9:35 AM | Last reply by TiborK - Tuesday, July 14, 2015 5:13 PM -
0 Votes
Audit Log Reports Automation With Powershell in SharePoint 2013
Recommendation to microsoft - add this to your sharepoint powershell suite!Answered | 4 Replies | 10518 Views | Created by M. Emerson Bruce - Tuesday, December 8, 2015 7:34 PM | Last reply by M. Emerson Bruce - Monday, January 4, 2016 7:38 PM -
0 Votes
Log Shipping to a SQL Server in separate Active Directory Forrest
Log shipping is simply an automated process of copying log backups from a source and restoring it from a destination database.Answered | 1 Replies | 2220 Views | Created by Jasedace - Tuesday, June 4, 2013 6:53 PM | Last reply by Edwin M Sarmiento - Tuesday, June 4, 2013 10:26 PM -
4 Votes
How to intergrate SQL Server with Active Directory users ?
The SQL 2005 used to have a builtin Adminstrators User assigned in SQL Server, this included any one who was a local admin on the box.Answered | 7 Replies | 2824 Views | Created by TonyJK - Tuesday, February 19, 2013 4:46 AM | Last reply by Rick Byham, Microsoft - Friday, February 22, 2013 4:26 PM -
1 Votes
SqlServer Audit - How to audit a User on multiple Databases
Server audits can track activity on server-level objects by server logins.Answered | 1 Replies | 1329 Views | Created by ArashMasroor - Wednesday, September 17, 2014 12:33 PM | Last reply by Rick Byham, Microsoft - Wednesday, September 17, 2014 3:56 PM -
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 | 13338 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
DATABASE AUDIT SPECIFICATION ON SPECIFIC USERS
Hi Han, Are your Windows login accounts member of the SQL Server sysadmin role?Answered | 2 Replies | 1320 Views | Created by Harn - Monday, March 30, 2015 7:23 AM | Last reply by Harn - Wednesday, May 6, 2015 2:21 AM -
0 Votes
Users Logged in SQL Server
Hello Varun, If you haven't implemented an Login Audit yet, then you can't get the Information for the past.Answered | 2 Replies | 940 Views | Created by Raje14 - Friday, June 12, 2015 2:15 PM | Last reply by Olaf Helper - Friday, June 12, 2015 2:25 PM -
3 Votes
Database auditing on Azure SQL db
Yes, there is the Audit & Threat Detection feature for Azure SQL Database.Answered | 4 Replies | 1442 Views | Created by Samantha v - Thursday, March 22, 2018 3:11 AM | Last reply by Samantha v - Sunday, March 25, 2018 5:33 AM -
0 Votes
SQL server 2008 database access audit
Hi Thanks for replies, I just want to see certain Windows user whether accessing a database.Answered | 5 Replies | 1549 Views | Created by Mira Pimbi - Sunday, April 27, 2014 10:49 AM | Last reply by Shanky_621 - Monday, April 28, 2014 9:10 AM -
0 Votes
SQL Server Audit
Created SQL Server Audit for few tables and it works great.Answered | 3 Replies | 1477 Views | Created by SQLmaddy - Wednesday, August 15, 2018 3:22 PM | Last reply by Shanky_621 - Thursday, August 16, 2018 7:24 AM -
1 Votes
Retrive list of all active users from active directory using powershell.
Alternatively, if Active Directory Web Services are available in your environment, you can use the Active Directory PowerShell cmdlets.Answered | 1 Replies | 2964 Views | Created by abc67 - Tuesday, December 18, 2012 6:29 PM | Last reply by Trevor Seward - Tuesday, December 18, 2012 6:57 PM -
0 Votes
Retrieving Active Directory infomation from SQL Server
Please refer the below link for incremental loading of data from ...Answered | 4 Replies | 791 Views | Created by Peter The Spate - Thursday, January 15, 2015 3:03 PM | Last reply by Peter The Spate - Friday, January 16, 2015 4:40 PM -
0 Votes
User Administration Audit Log Report - SQL Server Reporting Services
I have downloaded, installed, configured and used the log viewer tool but I wasn't able to see any event which records user activity pertaining ...Answered | 5 Replies | 5326 Views | Created by Aibo - Sunday, February 26, 2012 5:39 AM | Last reply by Chaitanya Medikonduri - Wednesday, February 29, 2012 6:02 AM - Items 1 to 20 of 2863608 Next ›
No announcements