You can tell ActiveMQ to use a specific database type by the following configuration:
<jdbcPersistenceAdapter adapterClass="org.apache.activemq.store.jdbc.adapter.ImageBasedJDBCAdaptor"/> Just lookup the correct adapter for SQL-Server. If you get a database locking issue use the modified adapter by Daniel Mueller: JIRA-Issue AMQ-1210 (http://issues.apache.org/activemq/browse/AMQ-1210) Hope to Help Mario
