THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server'

Database Mail … and then the SMTP Server changed

This blog has moved! You can find this content at the following new location:

Published Friday, July 18, 2014 11:30 PM by Hugo Kornelis

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Argenis said:

This is why DNS CNAMEs are so important.

July 21, 2014 4:05 PM

Gerald Britton said:

If you had more than a few SSIS packages, remembering that they're just XML files, once you figure out the difference from changing one package, you can change them all with a global search/replace.  Notepad++ is handy for tasks like this but there are plenty of alternatives.

Oh, I wouldn't do that if my packages were not source controlled, since that gives you an easy way to check the diffs and to backout the changes altogether if (when?) you mess up.

June 2, 2015 3:59 PM

Leave a Comment


About Hugo Kornelis

Hugo is co-founder and R&D lead of perFact BV, a Dutch company that strives to improve analysis methods and to develop computer-aided tools that will generate completely functional applications from the analysis deliverable. The chosen platform for this development is SQL Server. In his spare time, Hugo likes to visit the SQL Server newsgroups, in order to share and enhance his knowledge of SQL Server.
Privacy Statement