A severe error occurred on the current command - help

[=?Utf-8?B?SlA=?=]

Im posting this in both the .NET general group and SQL group since several
other post mention that this may be a problem with ASP.NET and not SQL

Out of the blue, any SQL 2005 SPs we have that execute dynamic SQL generate
the following error:

A severe error occurred on the current command. Results if any should be
discarded.

All other SPs appear to be working properly. After going though Google and
MSN for more then an hour, I cant seem to find a solution that will fix the
issue.

The server has the latest service packs, NOCOUNT is ON, there are no PRINT
statements, and the users and applications have DBO access. Networking says
that have changed a thing in the system configuration.

Anyone else run into this problem?
--
JP
..NET Software Developer

[dotnet_seeker]

On Sep 27, 7:17 pm, JP <[e-mail]:

Im posting this in both the .NET general group and SQL group since several
other post mention that this may be a problem with ASP.NET and not SQL

Out of the blue, any SQL 2005 SPs we have that execute dynamic SQL generate
the following error:

A severe error occurred on the current command. Results if any should be
discarded.

All other SPs appear to be working properly. After going though Google and
MSN for more then an hour, I cant seem to find a solution that will fix the
issue.

The server has the latest service packs, NOCOUNT is ON, there are no PRINT
statements, and the users and applications have DBO access. Networking says
that have changed a thing in the system configuration.

Anyone else run into this problem?
--
JP
.NET Software Developer

will u plz put the sp , so that we can chk the syntax, and put the
table structure , so we can help u out