![]() Parameters are identical to those used by sp_send_dbmail. All parameters are optional except for You must specify at least one of or Otherwise, sp_sentry_dbmail_20 returns an error. ![]() sp_sentry_dbmail_20 ParametersĪ list of sp_sentry_dbmail_20 parameters is shown in following the table. For more information about enabling 'Ad Hoc Distributed Queries', search for 'Ad Hoc Distributed Queries' in SQL Server Books Online.Īdditional Information: Microsoft documentation for Ad hoc distributed queries Server Configuration Option. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. Note: You may receive an error if the required components are not turned on: Msg 15281, Level 16, State 1, Line 26 ![]() Note: For sp_sentry_dbmail_20 to function, SMTP settings must be configured first.
0 Comments
Leave a Reply. |