Hi,

has anyone ever encountered a problem with MSSQL that would manifest like
this.

If you run specific code outside of transaction. it runs just fine. But if
you put that code within a transaction - transaction fails and does a
rollback.

Issue has occured on different SQL versions (2000, 2008 x86 and 64bit too)
on different OSes (2003, 2008R2).

What I have concluded so far is... That ammount of data that is being
handled with specific code is not big, on contrary it's rather small, tens
of kilobytes and that isolation levels have absolutely no affect to the
outcome. It just fails every time.

Also, code is being run on one server, no network activity is being
triggered by that specific part of code.

Anyone, any clues? Suggestions? Ideas? Anything?

Thank you,
T.

On Thu, 16 Dec 2010 15:55:20 +0100, Toni Alfirevic
<toni.alfirevic (AT) gmail (DOT) com> wrote:

(snip)
Without seeing the code, or the error messagesd (if any) returned when
running the code?

No.
--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

On Thu, 16 Dec 2010 16:19:33 +0100, Toni Alfirevic wrote:


and the error returned is...

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any,
should be discarded.

Toni Alfirevic (toni.alfirevic (AT) gmail (DOT) com) writes:
So this is a bug. If you look in the SQL Server error log, you will
probably find a stack dump. That is, SQL Server ran into some internal
error like an access violation, and had to kill your process.

It is also possible that the error happens on the client-side - in fact
the severity of 11 indicates this possibility.

Try running the same command from SQLCMD and OSQL, this may or may
not give more information.

What does SELECT @@version return?


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) 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

On Fri, 17 Dec 2010 00:07:36 +0100, Erland Sommarskog wrote:

Client as a application on IIS or client as a Microsoft SQL Server
Management Studio?

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.

@@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 <X64> (Build 7600: )

Same issue occurs on:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010
15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit)
on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

And on one version of SQL 2000 currently the VPN server is down so i cant
run @@version.

Odd stuff.

Toni Alfirevic (toni.alfirevic (AT) gmail (DOT) com) writes:
More specifically it could be an error in the client API. Which is in this
case is SqlClient in ADO .Net.

Do you see different results in SSMS and the ASP application?

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 (AT) sommarskog (DOT) 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