From the course: SQL Server 2016: Administer a Database Infrastructure
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Configure an Azure SQL Database audit - SQL Server Tutorial
From the course: SQL Server 2016: Administer a Database Infrastructure
Configure an Azure SQL Database audit
- [Instructor] If you're connecting to an Azure Sequel Database through Sequel Server Management Studio and tried to set up the audit running the scripts in the last couple of movies, then you probably notice that it didn't work as expected. Right now I'm connected to my Azure Sequel database instead of the local database. And if I try and run the T sequel command to create a new database audit like I have online six through ten, you'll notice I get this error. What's interesting is that the error isn't a problem that I don't actually have a server audit already created, but it's that the create audit specification isn't even supported in this version of Sequel Server. Also if you go into the databases folder and expand the security folder, you won't even find a folder for the database audit specification, so obviously auditing in Azure Sequel databases works a little bit differently than in the stand alone local installation version of sequel server. We'll need to configure it…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.