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 or
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...
> > 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
>
>|||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...
> 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:
>> 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...
>> > 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
>>|||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...
> > 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:
> >
> >> 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...
> >> > 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
> >>
> >>
> >>
>
>|||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...
>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...
>> > 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:
>> >
>> >> 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...
>> >> > 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
>> >>
>> >>
>> >>
>>|||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 the
> session seems to help.
> --
> -oj
>
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
> >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...
> >> > 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:
> >> >
> >> >> 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...
> >> >> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||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...
>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
>> the
>> session seems to help.
>> --
>> -oj
>>
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:06C6807E-B946-43A4-B95D-BE17B38DD135@.microsoft.com...
>> >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...
>> >> > 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:
>> >> >
>> >> >> 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...
>> >> >> > 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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>