Hi Gurus
I m using SQL Server7.0 with SP2 on Compaq Prolient ML310 PIV 2.2Ghz
Now the problem is when i m executing the "select * statment " on a table with 21000 rows it is taking ard 1min to result for the same.and if i m using the same query without any service pack the result is coming in 4-5 Secs. but with the base system ( without service pack) my system get freeze frequently.
REPLY URGENT
TIAHave you tried downloading the latest service pack? (SP4 for 7.0 I believe)
What changed between having the sp and not having it?|||Originally posted by rhigdon
Have you tried downloading the latest service pack? (SP4 for 7.0 I believe)
What changed between having the sp and not having it?
I have checked with the SP4 even , but the back to square one.sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment