SQL Server 2005 Tidbit 005

  • Article

SQL Server 2005 Tidbit 005

Happy SQL People

SQL Server 2005 Tidbit number FIVE..

This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me.

—

"Can 2005 Express be part of the multiserver environment? In SQL Server 2000, target servers running MSDE cannot be enlisted.”

According to the SQL Server 2005 Express information page (https://www.microsoft.com/sql/express/default.mspx), SQL Express can participate as a Transactional and Merge Replication Subscriber, as a client for the SQL Service Broker, and will support distributed transactions.  Sweet!

—

Got an IT question?  Give me a comment, or contact me.