Skip to main content

Posts

Showing posts from April, 2014

outlook out of office does not work exchange 2003

I had this issue for a while and decided to sort it out. After googling I found it was a setting on the exchange:

To turn on out-of-office replies to the Internet, follow these steps:
On the Exchange server, start Exchange System Manager.Double-click Global Settings, and then click Internet Message Formats.In the Details pane, right-click a particular domain name, and then click Properties. The default SMTP domain is "*".In the Properties dialog box, click the Advanced tab, and then click to select the Allow out of office responses check box, and then restart the SMTP and Routing Engine services.

Note After you do this, the e-mail messages that are sent from users in the Internet domain that were configured in step 3 receive an Out of Office response from the users in the Exchange organization that have enabled Out of Office on their mailboxes.Stop the Simple Mail Transfer Protocol (SMTP) and Microsoft Exchange Routing Engine services, and then restart them. From http://supp…

Read XML file and run commands in it for C#

Storing of SQL commands When coding we use an offline database (or sandbox) that allows us to change whatever we like duirng development. As we make changes to the database we store the SQL commands that are used to make these changes.

Getting tired of copying and pasting the commands back into the SQL manager once we took the changes live I decided to write a some code to read from an XML file and implement the changes. 
Structure of the XML file The strurcture we decided on was something that was general enough to allow for room to grow, so we came up with this:

XML structure:

<commands>
  <command type="sqlcommandtype">
SQLCommandText
  </command>
  ...
</commands> 

Where:
sqlcommandtype: is the type of commnad: select, insert, update, alter, etc or disabledSQLCommandText: is the actual command Example of XML file Here is an example of the a file:
<?xml version="1.0" encoding="utf-8"?>
<commands>
  <command type="d…