Sql-Server-Query-World

Query to check default Database Mail profile in SQL Server? SELECT TOP 1 name FROM msdb.dbo.sysmail_profile p JOIN msdb.dbo.sysmail_principalprofile pp ON pp.profile_id = p.profile_id AND pp.is_default = 1Suppose if you want to take the value in a variable then you

Read More