Once a week or once a month

[Erland Sommarskog]

Re: Once a week or once a month

Neil (nospam@nospam. net) writes:

One problem with remote desktop is that you can't transfer files or
transfer the clipboard contents (or can you?). I use those two functions
all the time.

You can. You can configure this under Local Resources. I think clipboard
is shared by default, so if you put something on the clipboard on the
remote machine, it makes it to the local machine automatically.

The way to transfer files, is a little funny, though. You make the local
drives available to the remote machine, so that they appear as shared
there. Since this is a security issue, it's not recommendable to always
expose your disks.

We don't use PC Anywhere in our shop, but we use PC Duo which is a
similar product. About all customers has PC Duo clients on their
servers, and that's how we connect to them. The major advantage is
that with Remote Desktop, is that if someone else connect, you may lose
your session. With PC-Duo you can see that someone else is there.
And moving files is easier with PC-Duo than Remote Desktop.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Neil]

Re: Once a week or once a month


"Erland Sommarskog" <esquel@sommars kog.sewrote in message
news:Xns99FFEF5 871026Yazorman@ 127.0.0.1...

Neil (nospam@nospam. net) writes:

>One problem with remote desktop is that you can't transfer files or
>transfer the clipboard contents (or can you?). I use those two functions
>all the time.

>
You can. You can configure this under Local Resources. I think clipboard
is shared by default, so if you put something on the clipboard on the
remote machine, it makes it to the local machine automatically.
>
The way to transfer files, is a little funny, though. You make the local
drives available to the remote machine, so that they appear as shared
there. Since this is a security issue, it's not recommendable to always
expose your disks.
>
We don't use PC Anywhere in our shop, but we use PC Duo which is a
similar product. About all customers has PC Duo clients on their
servers, and that's how we connect to them. The major advantage is
that with Remote Desktop, is that if someone else connect, you may lose
your session. With PC-Duo you can see that someone else is there.
And moving files is easier with PC-Duo than Remote Desktop.
>
>

So you'd recommend PC Duo over Remote Desktop? Is the performance as good?

[Greg D. Moore \(Strider\)]

Re: Once a week or once a month


"Neil" <nospam@nospam. netwrote in message
news:q5i6j.4985 $fl7.132@newssv r22.news.prodig y.net...

>

>>

>
>
One problem with remote desktop is that you can't transfer files or
transfer the clipboard contents (or can you?). I use those two functions
all the time.

You can transfer the clipboard settings in Win2K.

(Though I think you need Server 2003 for the file transfer function (it maps
the drives from your client to the server. I use that a lot.)

>
>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Erland Sommarskog]

Re: Once a week or once a month

Neil (nospam@nospam. net) writes:

So you'd recommend PC Duo over Remote Desktop? Is the performance as good?

It depends on the purpose. When I want to connect to machine at work,
I definitely prefer Remote Desktop over PC-Duo. At least in the past I
have had issue with PC-Duo redrawing the screen like crazy, or it has
stopped redrawing. A crazy one I remember was that if I connect to my
machine with PC-Duo, and I had Query Analyzer up with a query grid, it
would halt somewhere. I was able to get it to resume if I minimiezed QA.
Now, since PC-Duo had not drawn the entire screen, I had to find the
minimize button as if I was blind-folded. Even more fun, if other windows
were on top of QA. But I should stress that this was quite a few years
and versions of PC-Duo ago.

So for performance and access to a workstation I prefer Remote Desktop.

But if several people need to access the same server console, I think
PC Duo is better. It's also better if you need to move files in any
direction.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Neil]

Re: Once a week or once a month


"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co mwrote in message
news:13lla9gfb1 3pp76@corp.supe rnews.com...

>
"Neil" <nospam@nospam. netwrote in message
news:q5i6j.4985 $fl7.132@newssv r22.news.prodig y.net...

>>

>>>

>>
>>
>One problem with remote desktop is that you can't transfer files or
>transfer the clipboard contents (or can you?). I use those two functions
>all the time.

>
You can transfer the clipboard settings in Win2K.
>

"Can" transfer, or they're transferred automatically?

[Greg D. Moore \(Strider\)]

Re: Once a week or once a month

"Neil" <nospam@nospam. netwrote in message
news:RPP6j.5129 $fl7.785@newssv r22.news.prodig y.net...

>
"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co mwrote in
message news:13lla9gfb1 3pp76@corp.supe rnews.com...

>>
>"Neil" <nospam@nospam. netwrote in message
>news:q5i6j.498 5$fl7.132@newss vr22.news.prodi gy.net...

>>>
>>>>
>>>
>>>
>>One problem with remote desktop is that you can't transfer files or
>>transfer the clipboard contents (or can you?). I use those two functions
>>all the time.

>>
>You can transfer the clipboard settings in Win2K.
>>

>
"Can" transfer, or they're transferred automatically?
>

Transferred automatically.

>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[scoots987]

Re: Once a week or once a month

On Dec 6, 2:05 pm, "Neil" <nos...@nospam. netwrote:

Running a SQL 7 system on a Windows 2000 server using Access 2000 on client
machines as a front end. System administrator currently reboots the server
once a month. Yesterday we had some weird thing with the database where
users were getting ODBC errors when trying to access it. Rebooted the
server, everything was fine. Suggested to the sa that he reboot the server
once a week. He said he already does it once a month, and that's sufficient.
>
My POV is that: a) doing it once a week might prevent situations such as the
one yesterday; b) even without situations like the one yesterday,
performance may be degrading over the course of the month, without our being
aware of it, and rebooting once a week might help performance.
>
Any thoughts on this?
>
Thanks!
>
Neil

Neil, along with the great suggestions I would explore upgrading your
box and software. Even look at client configurations, how do they
login, are they booting up daily or are the client machines left on
over night or several days thus causing the problem in itself. Does
your SA have that power to dictate what is sufficient? What does it
harm? Granted rebooting and shutting down a server box is not good for
the long term.

HTH...

[Neil]

Re: Once a week or once a month

OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I can
send a Ctrl+Alt+Del and bring up Task Manager. How would one do that in
remote desktop?



"Ed Murphy" <emurphy42@soca l.rr.comwrote in message
news:4759bb35$0 $2384$4c368faf@ roadrunner.com. ..

Neil wrote:
>

>One problem with remote desktop is that you can't transfer files or
>transfer the clipboard contents (or can you?). I use those two functions
>all the time.

>
The clipboard contents are auto-copied whenever they change on either
side. I don't think you can transfer files, but you can work around
that with an FTP server.

[Greg D. Moore \(Strider\)]

Re: Once a week or once a month

"Neil" <nospam@nospam. netwrote in message
news:PyCaj.568$ se5.316@nlpi069 .nbdc.sbc.com.. .

OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I
can send a Ctrl+Alt+Del and bring up Task Manager. How would one do that
in remote desktop?

http://support.microsoft.com/kb/186624

CTRL-ALT-END

>
>
>
"Ed Murphy" <emurphy42@soca l.rr.comwrote in message
news:4759bb35$0 $2384$4c368faf@ roadrunner.com. ..

>Neil wrote:
>>

>>One problem with remote desktop is that you can't transfer files or
>>transfer the clipboard contents (or can you?). I use those two functions
>>all the time.

>>
>The clipboard contents are auto-copied whenever they change on either
>side. I don't think you can transfer files, but you can work around
>that with an FTP server.

>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Neil]

Re: Once a week or once a month

Hey, thanks, that's great.

I was also wondering about toggling between full screen and windowed mode
(Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
I'm glad that TS has a shortcut for that, that's a bit unwieldy, especially
since Break on my laptop is Fn+Break!! Guess I'll just have to use the mouse
to toggle.

Neil


"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co mwrote in message
news:13mm5akkg0 q5l4b@corp.supe rnews.com...

"Neil" <nospam@nospam. netwrote in message
news:PyCaj.568$ se5.316@nlpi069 .nbdc.sbc.com.. .

>OK, here's another one: no way to sent Ctrl+Alt+Del. With PCAnywhere, I
>can send a Ctrl+Alt+Del and bring up Task Manager. How would one do that
>in remote desktop?

>

http://support.microsoft.com/kb/186624

>
CTRL-ALT-END
>
>

>>
>>
>>
>"Ed Murphy" <emurphy42@soca l.rr.comwrote in message
>news:4759bb35$ 0$2384$4c368faf @roadrunner.com ...

>>Neil wrote:
>>>
>>>One problem with remote desktop is that you can't transfer files or
>>>transfer the clipboard contents (or can you?). I use those two
>>>functions all the time.
>>>
>>The clipboard contents are auto-copied whenever they change on either
>>side. I don't think you can transfer files, but you can work around
>>that with an FTP server.

>>
>>

>
>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com

http://www.greenms.com/sqlserver.html

>
>

[Greg D. Moore \(Strider\)]

Re: Once a week or once a month

"Neil" <nospam@nospam. netwrote in message
news:YXHaj.3392 3$Pv2.8297@news svr23.news.prod igy.net...

Hey, thanks, that's great.
>
I was also wondering about toggling between full screen and windowed mode
(Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
I'm glad that TS has a shortcut for that, that's a bit unwieldy,
especially since Break on my laptop is Fn+Break!! Guess I'll just have to
use the mouse to toggle.
>

Yeah there were a few there that I didn't even know about.

Very useful.

Neil

>>
>>
>--
>Greg Moore
>SQL Server DBA Consulting Remote and Onsite available!
>Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>>

>
>

--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Neil]

Re: Once a week or once a month


"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co mwrote in message
news:13mnm3t85t ebm62@corp.supe rnews.com...

"Neil" <nospam@nospam. netwrote in message
news:YXHaj.3392 3$Pv2.8297@news svr23.news.prod igy.net...

>Hey, thanks, that's great.
>>
>I was also wondering about toggling between full screen and windowed mode
>(Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
>I'm glad that TS has a shortcut for that, that's a bit unwieldy,
>especially since Break on my laptop is Fn+Break!! Guess I'll just have to
>use the mouse to toggle.
>>

>
Yeah there were a few there that I didn't even know about.
>
Very useful.
>

You'd think (just a thought) that MS would give use a dropdown with some of
the functions. Or maybe just a list of shortcuts so we could have them
handy. I guess that's too much to ask for...:-(

[Neil]

Re: Once a week or once a month


"Greg D. Moore (Strider)" <mooregr_delete th1s@greenms.co mwrote in message
news:13mnm3t85t ebm62@corp.supe rnews.com...

"Neil" <nospam@nospam. netwrote in message
news:YXHaj.3392 3$Pv2.8297@news svr23.news.prod igy.net...

>Hey, thanks, that's great.
>>
>I was also wondering about toggling between full screen and windowed mode
>(Alt+Enter in PCAnywhere). I see that's CTRL+ALT+BREAK in TS. But, while
>I'm glad that TS has a shortcut for that, that's a bit unwieldy,
>especially since Break on my laptop is Fn+Break!! Guess I'll just have to
>use the mouse to toggle.
>>

>
Yeah there were a few there that I didn't even know about.
>
Very useful.
>
>

Hey, you know, I just found out that there's an option when you connect
through RDC to apply Windows key combinations to the remote computer!
Doesn't seem to work for Ctrl-Alt-Del. But seems to work for Alt-Tab.
Haven't tried it with others yet. But that's a great thing.

[Piero 'Giops' Giorgi]

Re: Once a week or once a month

On Dec 23 2007, 5:07 pm, "Neil" <nos...@nospam. netwrote:
.

Hey, you know, I just found out that there's an option when you connect
through RDC to apply Windows key combinations to the remote computer!
Doesn't seem to work for Ctrl-Alt-Del.

It's replaced by Ctrl+Alt+End

P

[Neil]

Re: Once a week or once a month


"Piero 'Giops' Giorgi" <giorgi.piero@g mail.comwrote in message
news:3b776dc7-53a1-4904-a5ee-685c1b4e969c@u1 0g2000prn.googl egroups.com...
On Dec 23 2007, 5:07 pm, "Neil" <nos...@nospam. netwrote:
..

Hey, you know, I just found out that there's an option when you connect
through RDC to apply Windows key combinations to the remote computer!
Doesn't seem to work for Ctrl-Alt-Del.

It's replaced by Ctrl+Alt+End

===============

Thanks, but what I was saying was that there's anoption when you connect to
apply the actual Windows key combinations to the remote computer, not the
assigned shortcuts. I was saying that it doesn't work for Ctrl+Alt+Del. In
that case you have to use Ctrl+Alt+End. But with the others, you can use the
actual keys.