When you create a profile in Database Mail, you have the option of making it a private profile or a public profile.
You also have the option of setting it as the default profile.
Continue readingTag: mssql
Change the Priority of an Account within a Database Mail Profile (SSMS)
Here, I demonstrate how to change the priority of a Database Mail account within a profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Change the Sequence Number of an Account in Database Mail (T-SQL).
The priority and the sequence number are the same thing (when you change it with T-SQL you use the @sequence_number parameter).
Remove a Database Mail Account from a Profile (SSMS)
Here, I demonstrate how to remove a Database Mail account from a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Remove a Database Mail Account from a Profile (T-SQL).
Continue readingDelete a Database Mail Profile (SSMS)
Here, I demonstrate how to delete a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Delete a Database Mail Profile (T-SQL).
Continue readingDelete a Database Mail Account (SSMS)
Here, I demonstrate how to delete a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Delete a Database Mail Account (T-SQL).
Continue readingUpdate a Database Mail Profile (SSMS)
Here, I demonstrate how to update a Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Update a Database Mail Profile (T-SQL).
Continue readingUpdate a Database Mail Account (SSMS)
Here, I demonstrate how to update a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Update a Database Mail Account (T-SQL).
Continue readingHow to Install SQL Server
SQL Server used to be available on Windows machines only. If you didn’t have Windows, you didn’t install SQL Server.
Now, SQL Server is available on Windows, Linux, and even Mac (via Docker containers).
This obviously means that an article titled “how to install SQL Server” is not as simple as it used to be!
Continue readingAdd a Database Mail Account to a Profile (SSMS)
Here, I demonstrate how to add a Database Mail account to an existing Database Mail profile in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see Add a Database Mail Account to a Profile (T-SQL).
Continue readingCreate a Database Mail Account (SSMS)
This article demonstrates how to create a Database Mail account in SQL Server using the SQL Server Management Studio (SSMS) graphical user interface.
If you want to see how to do it using T-SQL, see How to Create a Database Mail Account in SQL Server (T-SQL).
Continue reading