Jim Lawrence
accessd at shaw.ca
Sat Apr 3 03:34:14 CDT 2010
Hi John: I was looking up another issue and ran across this article and thought of your question a few dys ago about your speed or lack of it as your databases get older and slower. This might be caused by fragmentation of the indexes and the following link might help you out: http://sqlserverpedia.com/wiki/Index_Maintenance Jim -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Friday, April 02, 2010 10:37 AM To: Access Developers discussion and problem solving; VBA; Sqlserver-Dba Subject: [dba-SQLServer] Initial start of remote desktop fails - Windows 2003 I use RD to work on the servers in my office from my laptop in my office (entirely within my LAN). When I attempt to connect RD, it fails completely and always if I have not first logged in to the server manually, through the keyboard / mouse connected to that machine. IOW I have to use my KVM switch to physically see the machine, AND log in, THEN RD will work from my laptop. If I use the KVM to go to the physical machine and log out, RD from the laptop will continue to work IF ALREADY CONNECTED, but will fail if I close the RD session and try to RD back in. IOW RD simply cannot connect if there is not already a user logged in. Additionally, once I have done that manual / initial login to the physical machine, RD will fail the first time I try it. I have to try to connect, immediately cancel that attempt, then try it again and then it connects right in. I can close the RD session and start it again, no problem (as long as that other user is still connected). So... has anyone seen this behavior? Has anyone seen a solution to that problem such that RD will work first time / every time, regardless of anything? -- John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com