I am assuming there is some functionality to copy and paste a table in sql server..however I am not seeing where I can do this what I want to do is this:
create table1 as select * from table 2;
Please let me know how I can create a new table as a replica of an existing table. Thanks so much!Sounds like Oracle syntax there. There is an analog in SQL Server, though
Select * into copytable
from sourcetable
This won't bring over indexes, primary keys, foreign keys, or identity columns, but it does bring the bare table structure, and the data.|||thanks. Yep I am having a big of a syntax issue here. I am more of an Oracle person! Thanks again.
Showing posts with label functionality. Show all posts
Showing posts with label functionality. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Subscribe to:
Posts (Atom)