June 20, 2006 at 7:46 am
Hi there,
I am running SQL Server 2005 Development Edition. I control this database with SQL Server management studio. Strange thing that happens is the following. If I connect to this database from another PC over TCP/IP and SQL server management studio, it all works very smoothly. However if I use management studio local on the SQL server, then it takes sometimes minutes to update the table list of my database, remotely it is there in a flash.
Any ideas?
Erik
June 23, 2006 at 8:00 am
This was removed by the editor as SPAM
June 23, 2006 at 10:54 am
How is overall performance on the machine locally? Is this a server operating system? If so, remember that it'll give higher priority to background operations than foreground ones (like refreshing information in the logged on console).
K. Brian Kelley
@kbriankelley
June 21, 2007 at 10:07 am
Saw that this was still unanswered...
For good measure, here's what I found.
http://support.microsoft.com/kb/555686
AND/OR
http://support.microsoft.com/kb/906892
Enjoy!
A Brown
Manage all of your backups in one simple job using this script.
June 22, 2007 at 1:37 am
By default loclz connections use shared memory protocol, are you sure that the protocol being used us TCP/IP. you can check this with DMvs.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply