A Server Error Occurred On The Current Command
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta a severe error occurred on the current command sql server 2008 r2 Discuss the workings and policies of this site About Us Learn more a severe error occurred on the current command sql server 2012 about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack a severe error occurred on the current command the results if any should be discarded Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, msg 0 level 11 state 0 line 0 a severe error occurred on the current command helping each other. Join them; it only takes a minute: Sign up SQL Server error on update command - “A severe error occurred on the current command” up vote 13 down vote favorite 2 Running the following query in SQL Server Management Studio gives the error below. update table_name set is_active = 0 where id = 3 A
A Severe Error Occurred On The Current Command Sql Server 2014
severe error occurred on the current command. The results, if any, should be discarded. The logs have been truncated there is an update trigger but this isnt the issue the transaction count is zero (@@trancount) I have tried the same update statement on a couple of other tables in the database and they work fine. DBCC CHECKTABLE('table_name'); gives DBCC results for 'table_name'. There are 13 rows in 1 pages for object "table_name". DBCC execution completed. If DBCC printed error messages, contact your system administrator. sql-server sql-server-2005 tsql share|improve this question edited Sep 14 '12 at 15:12 p.campbell 55.8k49186270 asked Jul 24 '09 at 0:34 Paul Rowland 4,939114367 add a comment| 6 Answers 6 active oldest votes up vote 19 down vote accepted I just had the same error, and it was down to a corrupted index. Re-indexing the table fixed the problem. I realise this thread is a year old, but I thought it would be worth mentioning incase someone comes across it in future (like I just did). share|i
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered
How To Reindex A Table In Sql Server 2008
by: A severe error occurred on the current command. The a severe error occurred on the current command linked server results, if any, should be discarded. SQL Server > Transact-SQL Question 0 Sign in to vote system.data.sqlclient.sqlexception (0x80131904): a severe error occurred on the current command. on an sql server instance (version: 10.0.1600.22) i have a table which has no pk no index no constraint no key with several columns. when http://stackoverflow.com/questions/1175244/sql-server-error-on-update-command-a-severe-error-occurred-on-the-current-com I execute the following commands in management studio, i get the error: "A severe error occurred on the current command. The results, if any, should be discarded." SELECT * FROM mySchema.MyTable SELECT * FROM mySchema.MyTable where id = 203679 SELECT sum(col1) FROM mySchema.MyTable deletemySchema.MyTable where id = 203679 However the https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7c4dd91f-4ca6-4cb9-ad8b-c8f32e9d25e7/a-severe-error-occurred-on-the-current-command-the-results-if-any-should-be-discarded?forum=transactsql following sql commands executed properly without error select * from mySchema.MyTable where id <> 203679select ID from mySchema.MyTable where id = 203679DBCC CHECKtable('mySchema.MyTable')DBCC CHECKDB(MyDB) what should i do? Sunday, December 30, 2012 10:48 AM Reply | Quote Answers 3 Sign in to vote So the error indicates that there was a crash either in the server or in the client API. If the problem is in the server, you should find a stack dump in the SQL Server error log. To determine if the error is on the client side, try running the same commands from SQLCMD that uses OLE DB, in difference to SSMS that uses SqlClient. Since you have the RTM version of SQL 2008, my recommendation is that you install Service Pack 3 to see if this resolves the issue, before you make any other investigations. Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Marked as answer by ShahyadSAt
ASP.NET Community Standup Forums Help Home/ASP.NET Forums/Data Access/SQL Server, SQL Server Express, and SQL Compact Edition/How to resolve http://forums.asp.net/t/2028471.aspx?How+to+resolve+A+severe+error+occurred+on+the+current+command+The+results+if+any+should+be+discarded+The+statement+has+been+terminated+Error+ "A severe error occurred on the current command. The... How to resolve "A severe error occurred on the current command. The results, if any, should be discarded. The statement has been terminated" Error? RSS 10 replies Last post Jan 20, 2015 05:18 AM by Michelle Ge - MSFT ‹ Previous Thread|Next Thread › error occurred Print Share Twitter Facebook Email Shortcuts Active Threads Unanswered Threads Unresolved Threads Support Options Advanced Search Reply kaviyarasan Member 78 Points 93 Posts How to resolve "A severe error occurred on the current command. The results, if any, should be d... Jan 10, 2015 05:42 AM|kaviyarasan|LINK Hi all, I have used the database error occurred on server with SQL SERVER 2008R2 (Operating system: win server 2008) for .net web application and console tools, the application working fine. in the same, i have changed the database server with SQL Server 2014 (OS: win server 2012), now the application gets the following exception while the tool running (while the tool try to execute the select query), Error: A severe error occurred on the current command. The results, if any, should be discarded. The statement has been terminated., stacktrace : at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() I confused myself, what's wrong with the SQL Server 2014. I've been looking at this, but can't find why this error is occur when the database server change? What s the cause and How to solve this error? please advice me. Thanks