dbTalk Databases Forums  

Once a week or once a month

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Once a week or once a month in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #21  
Old   
Greg D. Moore \(Strider\)
 
Posts: n/a

Default Re: Once a week or once a month - 12-09-2007 , 10:10 AM






"Neil" <nospam (AT) nospam (DOT) net> wrote

Quote:
"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote in
message news:13lla9gfb13pp76 (AT) corp (DOT) supernews.com...

"Neil" <nospam (AT) nospam (DOT) net> wrote in message
news:q5i6j.4985$fl7.132 (AT) newssvr22 (DOT) news.prodigy.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.


Quote:



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




Reply With Quote
  #22  
Old   
scoots987
 
Posts: n/a

Default Re: Once a week or once a month - 12-09-2007 , 10:20 AM






On Dec 6, 2:05 pm, "Neil" <nos... (AT) nospam (DOT) net> wrote:
Quote:
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...


Reply With Quote
  #23  
Old   
Neil
 
Posts: n/a

Default Re: Once a week or once a month - 12-20-2007 , 05:04 PM



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 (AT) socal (DOT) rr.com> wrote

Quote:
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.



Reply With Quote
  #24  
Old   
Greg D. Moore \(Strider\)
 
Posts: n/a

Default Re: Once a week or once a month - 12-20-2007 , 07:25 PM



"Neil" <nospam (AT) nospam (DOT) net> wrote

Quote:
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


Quote:


"Ed Murphy" <emurphy42 (AT) socal (DOT) rr.com> wrote in message
news:4759bb35$0$2384$4c368faf (AT) roadrunner (DOT) 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




Reply With Quote
  #25  
Old   
Neil
 
Posts: n/a

Default Re: Once a week or once a month - 12-20-2007 , 11:12 PM



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_deleteth1s (AT) greenms (DOT) com> wrote

Quote:
"Neil" <nospam (AT) nospam (DOT) net> wrote in message
news:PyCaj.568$se5.316 (AT) nlpi069 (DOT) 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 (AT) socal (DOT) rr.com> wrote in message
news:4759bb35$0$2384$4c368faf (AT) roadrunner (DOT) 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





Reply With Quote
  #26  
Old   
Greg D. Moore \(Strider\)
 
Posts: n/a

Default Re: Once a week or once a month - 12-21-2007 , 09:18 AM



"Neil" <nospam (AT) nospam (DOT) net> wrote

Quote:
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.


Quote:
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




Reply With Quote
  #27  
Old   
Neil
 
Posts: n/a

Default Re: Once a week or once a month - 12-21-2007 , 04:39 PM




"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote

Quote:
"Neil" <nospam (AT) nospam (DOT) net> wrote in message
news:YXHaj.33923$Pv2.8297 (AT) newssvr23 (DOT) news.prodigy.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...:-(




Reply With Quote
  #28  
Old   
Neil
 
Posts: n/a

Default Re: Once a week or once a month - 12-23-2007 , 07:07 PM




"Greg D. Moore (Strider)" <mooregr_deleteth1s (AT) greenms (DOT) com> wrote

Quote:
"Neil" <nospam (AT) nospam (DOT) net> wrote in message
news:YXHaj.33923$Pv2.8297 (AT) newssvr23 (DOT) news.prodigy.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.




Reply With Quote
  #29  
Old   
Piero 'Giops' Giorgi
 
Posts: n/a

Default Re: Once a week or once a month - 01-03-2008 , 07:10 PM



On Dec 23 2007, 5:07*pm, "Neil" <nos... (AT) nospam (DOT) net> wrote:
.
Quote:
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


Reply With Quote
  #30  
Old   
Neil
 
Posts: n/a

Default Re: Once a week or once a month - 01-03-2008 , 10:48 PM




"Piero 'Giops' Giorgi" <giorgi.piero (AT) gmail (DOT) com> wrote

On Dec 23 2007, 5:07 pm, "Neil" <nos... (AT) nospam (DOT) net> wrote:
..
Quote:
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.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.