SQL 2005: Slow

If you have SQL 2005 then you would have noticed that SQL Management Studio takes a long time to launch.
This is because, as is the best practice, its likely that your server is not connected to the internet and SQL MS is trying to check the internet connectivity!
You need to do this reg hack!

*At your risk*!!!

 

[HKEY_USERS\.Default\Software\Microsoft\Windows\CurrentVersion\WinTrust\Trust
Providers\Software Publishing]
“State”=dword:00023e00

And then you need to blow away your profile! OUCH!

So, do this thing for current user, since you are already logged on.

 

 

 

 

Leave a Comment

Name: (Required)

E-mail: (Required)

Website:

Comment:

Comment moderation is enabled. Your comment may take some time to appear.