C# – BinaryFormatter.Deserialize is “Unable to find assembly”

While testing a SQL CLR procedure recently I came across an issue with the binary formatter deserialization failing because it could not find the assembly for the type (even though the type is within the same assembly as the deserialization code).
Continue reading C# – BinaryFormatter.Deserialize is “Unable to find assembly”

SQL Server – Service Broker – Message Types across Databases

If the message is being sent to another database then the “message type” and “message contract” must exist on both databases, regardless of whether the destination database is on the same or a different server.

See: Back To Basics: Service Broker Message Types