Page 1 of 1

Problem on deleting table from DB?

Posted: Wed Jun 01, 2016 10:57 pm
by kokilasoral
Hi,
I am trying to trim a table ( equal delete ) from my database in the SQL Server. But inappropriately end up with the following error .
Err;
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?

Re: Problem on deleting table from DB?

Posted: Sat Jun 04, 2016 9:50 pm
by MarryJain
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.