I have a table inside my DB, I created table manually and I insert values inside that table through a store procedure. Everything went successfully, but now when I'm trying to run any query through this table, none of the queries are executing and even I'm
not getting any error message, only it displays below message as "Executing query............" for a long period of the time, finally I have to kill the query saying message as "Query
was cancelled by user".
I tried all thge below queries to this table, -
SELECT COUNT(*) FROM TABLE-NAME
SELECT TOP (1) * FROM TABLE-NAME
SELECT * FROM TABLE-NAME
DROP TABLE TABLE-NAME
Any help what's going wrong with the table, other tables inside the same db are working perfectly alright.
View Complete Post