Problem on deleting table from DB?

This Q&A forum allows users to post and respond to "How Do I Do ....." questions. Please do not use to report (suspected) errors - you must use your regional help desk for this. The information contained in this forum has not been validated by LANSA and, as such, LANSA cannot guarantee the accuracy of the information.
Post Reply
Posts: 1
Joined: Wed Jun 01, 2016 9:02 pm

Problem on deleting table from DB?

Post by kokilasoral » Wed Jun 01, 2016 10:57 pm

I am trying to trim a table ( equal delete ) from my database in the SQL Server. But inappropriately end up with the following error .
Msg 5243, Level 22, State 7, Line 5
An discrepancy was noticed during an interior operation. Please interact with technical support.
The Query i performed is ( its on similar single table)
select COUNT (*) from Compute_CTCSdetail_tmp
truncate table Compute_CTCSdetail_tmp
Any help?

Posts: 1
Joined: Sat Jun 04, 2016 9:48 pm

Re: Problem on deleting table from DB?

Post by MarryJain » Sat Jun 04, 2016 9:50 pm

You should also get something like DBNAME'(ID:01) on page (1:524021)....
Could you please provide the complete error message which you are getting. Please mark as answer if my post is helping to solve your problem and vote as helpful if it helped so that forum users can benefit.

Answer resource: a training on the concepts of SQL from a well experienced trainer from intellipaat made me to find answers to the particular question.

Post Reply