From: esquel@sommarskog.se   
      
   Toni Alfirevic (toni.alfirevic@gmail.com) writes:   
   > Client as a application on IIS or client as a Microsoft SQL Server   
   > Management Studio?   
      
   More specifically it could be an error in the client API. Which is in this   
   case is SqlClient in ADO .Net.   
      
   > Anyway the story goes like this. It has been brought to my attention that   
   > something is not working as intended so I've tried runing that specific   
   > stored procedure manually from management studio, same stored p. that ASP   
   > aplication runs. And the problem is as I've described.   
      
   Do you see different results in SSMS and the ASP application?   
      
   > @@version is on this specific system is:   
   >   
   > Microsoft SQL Server 2008 (SP1) - 10.0.2766.0 (X64)   Feb 25 2010 12:51:37   
   > Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition (64-bit)   
   > on Windows NT 6.1  (Build 7600: )   
      
   There is a Service Pack 2 out for SQL 2008. But whether it address the   
   issue you're seeing I don't know.   
      
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)