Software : SQL Server 7.0
- I have one database.
- Database have several Tables
- One Particular table contain 2000,000 Records.
- I execute the Simple SQL(Select statement) statement in the particular table,
- First four execution working properly, After that SQL Hang, (Upto Last week Everything working Fine.)
(It open 4 or 5 User name,password Window), Rest of the tables are working properly
- After that serveral time I tried the Simple SQL statement, SQL Hang.
- I restart the NT Server after that I execute the SQL statement it is working properly.
- My Database Size - around 800 MB, Available Free Space - around 225MB
What is the problem, I need immeditely reply from your side.
Thanks & regards..
Thirumalai,
Engineer,
+65 - 97458378
