http://blogs.msdn.com/b/repltalk/archive/2011/05/11/distribution-agent-unable-to-stream-when-replicating-as-tsql.aspxDistribution Agent unable to STREAM when replicating as TSQL Chris Skorlinski Microsoft SQL Server Escalation Services New for SQL 2008 is the ability for the Distribution Agent to push updates to the Subscriber using multiple connections.&#160; Thisen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/repltalk/archive/2011/05/11/distribution-agent-unable-to-stream-when-replicating-as-tsql.aspx#10163488Wed, 11 May 2011 18:37:48 GMT91d46819-8472-40ad-a661-2c78acb4018c:10163488Ben Thul<p>Two things. &nbsp;</p> <p>1) I remember streams being available in SQL 2005.</p> <p>2) There seems to be a conflict in your interpretation of the 0 value for the hashkey. &nbsp;Specifically, if &quot;Value =0 indicates single stream, Values 0-63 indicates Streams are allowed.&quot; is true, 0 indicates both a single stream and multiple streams. &nbsp;That doesn&#39;t seem quite right.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10163488" width="1" height="1">