A severe error occurred on the current command - help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

will u plz put the sp , so that we can chk the syntax, and put the
table structure , so we can help u out
 
Found the problem! I made changes to a SP yesterday, that was being executed
by several other SPs and column orders in the temp table where all changed as
a result.

thx
 
Back
Top