Skip to content

Commit 5f349ff

Browse files
authored
Update database-mail-common-errors.md
Added command to set 'show advanced options' back to false and also fixed the code block that wasn't properly closed.
1 parent b70a7dd commit 5f349ff

1 file changed

Lines changed: 4 additions & 1 deletion

File tree

docs/relational-databases/database-mail/database-mail-common-errors.md

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -85,8 +85,11 @@ Database Mail relies on a number of internal stored procedures. To reduce the su
8585
EXEC sp_configure 'show advanced options', 1;
8686
RECONFIGURE;
8787
EXEC sp_configure 'Database Mail XPs', 1;
88-
RECONFIGURE
88+
RECONFIGURE;
89+
EXEC sp_configure 'show advanced options', 0;
90+
RECONFIGURE;
8991
GO
92+
```
9093

9194
Database Mail may be stopped in the **msdb** database. To check status of Database Mail, execute the following statement:
9295

0 commit comments

Comments
 (0)