instructions to setup database mail and job notification emails also, if you want to use your companies exchange server, then you need to make sure that smtp is enabled for the server that you want to send email from.

run first: sp_configure ‘show advanced options’, 1; RECONFIGURE; then this: sp_configure ‘Ad Hoc Distributed Queries’, 1; RECONFIGURE; ad hoc opens security issues – use very carefully!! only supposed to use ad hoc if there is infrequent access to the data for any data sources that…

in order to set: sp_configure ‘Ole Automation Procedures’, 1; GO you need to run this first: sp_configure ‘show advanced options’, 1; GO