Copy/Paste fails in SQL Server Management Studio

Has anyone experience the much frustrated situation of having the copy/paste
functionality fail within the Management Studio query editor environment?
I will be working fine, doing copy/paste within the query editor and then
for some reason the "copy" quits. I can copy from an outside source, e.g.
NotePad or Word and paste within Studio, but it seems like the "copy"
function stops working.
Like-wise, the ability to generate a script into a new window also stops
working.
Any ideas?
Thanks,
DaveDave
You are probably have SQL Server 2005 installed as a named instance, right?
It consumes memory as well
Close SSMS and open again ,see what is going on
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
> Has anyone experience the much frustrated situation of having the
> copy/paste
> functionality fail within the Management Studio query editor environment?
> I will be working fine, doing copy/paste within the query editor and then
> for some reason the "copy" quits. I can copy from an outside source, e.g.
> NotePad or Word and paste within Studio, but it seems like the "copy"
> function stops working.
> Like-wise, the ability to generate a script into a new window also stops
> working.
> Any ideas?
> Thanks,
> Dave|||Thanks for the response.
I did close and reopen and it then works fine. I also had a whole day wwhere
I never experienced any problems.
So, you think it is a memry issue? I was watching my client (PC) memory and
it did not change much when running a series of tests. I really don't think
it is a memory issue but I also haven't beable to figure out any sequence o
r
pattern to the problem.
Dave
"Uri Dimant" wrote:

> Dave
> You are probably have SQL Server 2005 installed as a named instance, right
?
> It consumes memory as well
> Close SSMS and open again ,see what is going on
>
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:053E7262-0707-4065-A0DA-CCC86924441A@.microsoft.com...
>
>|||Dave
Each instance you have on your computer will counsume memory for its needs,
how much memory do you have?
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...[vbcol=seagreen]
> Thanks for the response.
> I did close and reopen and it then works fine. I also had a whole day
> wwhere
> I never experienced any problems.
> So, you think it is a memry issue? I was watching my client (PC) memory
> and
> it did not change much when running a series of tests. I really don't
> think
> it is a memory issue but I also haven't beable to figure out any sequence
> or
> pattern to the problem.
> Dave
>
> "Uri Dimant" wrote:
>|||I have 1 gb of memory. I have monitored the memory usage while doing many
copy/paste scenarios and I haven't noticed any change in usage.
I will shut all my services down tomorrow and see if I run into any problems
.
This problem is very sparatic. Most of the early morning I was running into
this pretty frequently and quickly after shutting down management Studeo and
reopening it. And now for awhile I have been doing many times as many
copy/paste and have not run into the problem.
"Uri Dimant" wrote:

> Dave
> Each instance you have on your computer will counsume memory for its needs
,
> how much memory do you have?
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:B5D0BDC2-6112-4B02-8C87-74C02D15C2A2@.microsoft.com...
>
>|||I've experienced similar with terminal services. Just reconnect/recreate the
session seems to help.
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...[vbcol=seagreen]
>I have 1 gb of memory. I have monitored the memory usage while doing many
> copy/paste scenarios and I haven't noticed any change in usage.
> I will shut all my services down tomorrow and see if I run into any
> problems.
> This problem is very sparatic. Most of the early morning I was running
> into
> this pretty frequently and quickly after shutting down management Studeo
> and
> reopening it. And now for awhile I have been doing many times as many
> copy/paste and have not run into the problem.
> "Uri Dimant" wrote:
>|||I don't beleive this has anything to do with memory. I stopped all SQL
services locally on my PC that I am not using as I am doing my work against
a
differetn sql server on a different server using Managementb Studio.
So, after stopping a bunch of services that freed up
200+ MB of memory, and just after a dozen or so copy/paste, the ability to
do a copy stops.
I didn't think it had to do with memory since I was watching it usage and it
didn't jump when doing a sweries of copies.
I guess it is time to engage a Microsoft support call.
"oj" wrote:

> I've experienced similar with terminal services. Just reconnect/recreate t
he
> session seems to help.
> --
> -oj
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
>
>|||Hi Dave,
I wasn't suggesting it's a memory problem. I've seen similar behavior
through remote desktop ( I do it quite a bit to access the office). Simply
reconnecting helps.
If you contact PSS and have a definite answer, I would love to know for
reference.
-oj
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:276C89F0-67EA-416F-AC70-94C95D8A3CF5@.microsoft.com...[vbcol=seagreen]
>I don't beleive this has anything to do with memory. I stopped all SQL
> services locally on my PC that I am not using as I am doing my work
> against a
> differetn sql server on a different server using Managementb Studio.
> So, after stopping a bunch of services that freed up
> 200+ MB of memory, and just after a dozen or so copy/paste, the ability to
> do a copy stops.
> I didn't think it had to do with memory since I was watching it usage and
> it
> didn't jump when doing a sweries of copies.
> I guess it is time to engage a Microsoft support call.
>
> "oj" wrote:
>