Link to home
Start Free TrialLog in
Avatar of LifeLine_sa
LifeLine_sa

asked on

Connection Time out

while running  a heavey query at Sql Server 2000 i get Error "Lock Time Out" "Connection Time out".

while troubalshoot i find out, i am running SQL Servic Pack2 which means i need to update to service pack 4,

now what can be the best way to update the service pack????
to avoid any disacter, i am not quite sure after update what problem i can face.

please suggest best adoptable method
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of LifeLine_sa
LifeLine_sa

ASKER

If I run the same query on XP or Server it works but if run it over VISTA I get Lock Time out.

Why on VISTA I get problem