In Azure SQL Database, Audit is configured through the Azure portal. To enable SQL Server audit for the WideWorldImporters sample, run the following statement in the database: EXECUTE. Run the following T-SQL command to enable the use of Full-Text Indexing in the database:ĮXECUTE Application.Configuration_ApplyFullTextIndexingĮnabling auditing in SQL Server requires server configuration.In SQL Server Management Studio, connect to the WideWorldImporters database and open a new query window.Therefore, a post-installation step is required. However, that feature is not installed by default with SQL Server - you need to select it during SQL Server setup (it is enabled by default in Azure SQL Database). The sample database can make use of Full-Text Indexing. If a lower pricing tier is desired, it is recommended to import into a new P1 database, and then change the pricing tier to the desired level. It will a few minutes to complete on a P1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |