Hi all, I just havea general question I hope you guys could answer.
What is the best way to both backup my Report Development (i.e. visual
studio report project) and also my deployment on the Report Server?
Thanks for any advice.
Kind regards
TazBackup Report Project:
Do file backup (NTBackup Utility) of the folder containing both project
(rptproj), solution (sln), data source (rds) and report definition (rdl)
files.
Or use Visual Source Safe or similar products to have a centralized code
base, and backup that according to best practices for that product.
Backup Report Server:
Do file backup on the config files for Report Manager and Report Server
Do backup of IIS metadata for the virtual directories
Extract the encryption key and save this, using RSKeyMgmt.exe
These two only needs to be done when making changes to the Report Server,
which shouldn't be too often.
Then do SQL backup of the ReportServer database once a day.
Kaisa M. Lindahl Lervik
"Tarun Mistry" <nospam@.nospam.com> wrote in message
news:OpTQd092GHA.4924@.TK2MSFTNGP05.phx.gbl...
> Hi all, I just havea general question I hope you guys could answer.
> What is the best way to both backup my Report Development (i.e. visual
> studio report project) and also my deployment on the Report Server?
> Thanks for any advice.
> Kind regards
> Taz
>|||Fantastic,
excellent post.
Taz
"Kaisa M. Lindahl Lervik" <kaisaml@.hotmail.com> wrote in message
news:%23KpG4f%232GHA.476@.TK2MSFTNGP06.phx.gbl...
> Backup Report Project:
> Do file backup (NTBackup Utility) of the folder containing both project
> (rptproj), solution (sln), data source (rds) and report definition (rdl)
> files.
> Or use Visual Source Safe or similar products to have a centralized code
> base, and backup that according to best practices for that product.
> Backup Report Server:
> Do file backup on the config files for Report Manager and Report Server
> Do backup of IIS metadata for the virtual directories
> Extract the encryption key and save this, using RSKeyMgmt.exe
> These two only needs to be done when making changes to the Report Server,
> which shouldn't be too often.
> Then do SQL backup of the ReportServer database once a day.
> Kaisa M. Lindahl Lervik
>
> "Tarun Mistry" <nospam@.nospam.com> wrote in message
> news:OpTQd092GHA.4924@.TK2MSFTNGP05.phx.gbl...
>> Hi all, I just havea general question I hope you guys could answer.
>> What is the best way to both backup my Report Development (i.e. visual
>> studio report project) and also my deployment on the Report Server?
>> Thanks for any advice.
>> Kind regards
>> Taz
>
Showing posts with label studio. Show all posts
Showing posts with label studio. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Copying Tables and Data
Is there any simple way to copy tables from one database to another in SQL Management Studio or VS 2005? I sometimes work split work between home and work and I often need to copy and table and its data (data, stored procedure, etc) to a different database, but having to create a new database then copy the data is a pain.
Is there an easier way?
You can back up and restore the DB. Less painful than copying each table.
|||I apologize ndinakar, what I meant was a need a way of copyingtables, not databases, between databases.
|||You can use SELECT INTO to copy table along with data in it to another location.
|||Or you can BCP OUT the data into text files, carry them home and BCP IN into the destination tables.
|||Thanks guys, exactly what I needed.
Thursday, March 22, 2012
Copying table structure using VS 2005
I is possible to copy the structure of an existing SQL 2000 table to make a new table with Visual Studio 2005?Definetely. Just generate the script either in Query Analyzer of using Enterprise Manager and execute it ont he SQL 2005 server.|||
The database is SQL 2000 and I was wondering if Visual Studio 2005 offered any native capability to copy table structure. It offers editing, query, and stored procedure contructors - I thought it might have a copy table or duplicate table feature.
sqlSunday, March 11, 2012
Copying Database table to another Database
I am using Visual Studio 2005 to connect to a database on a remote SQL2000 server. I need to copy a table in a database on my local machine up to the server. How can I do that?
Thank you,
Do you have enterprise manager or sql management studio?
If so do use the Import/Export wizard to copy the table from A to B.
|||no - I have Access 2007 and it is nothing like Access 2000 which made this act easy
|||
Part of my problem is that I am using Vista and it is giving me fits.
|||This is "long ago at school" kind of knowledge for me. But can't u connect the sql server to your access database and copy the data across from within access?
|||Finally got it - the adp setup in Access 2007 is completely different but you are correct it does work and actually quite well - now that I learned how to use it. The brain always stops with learning incomplete.
THank you
Thursday, March 8, 2012
Copying Data Problem with Export data tool
I Have a problem when copying data from one server to another in Management studio, I need to create and exact copy of the original because of primary key relationships,
Currently when I export the data the data will run through an insert type statement, which means that all PKs are reissued, rather than being duplicated from the original, How can I be sure that the data will be copied exactly how it is on one server to the other.It sounds as though the table that you want to copy the data into, has an identity column assigned to it. For the situation that you have described, there are two solutions available, each depends on how this secondary table will be used.
If the new table will be used in a transactional environment and it must maintain correct relationships with other tables, then you will need to maintain the same list of primary key values. To do this, we need to understand how your values for the primary key column is generated. I'm assuming a non-composite (single column) key for your system.
If it's an identity column, then you will want to maintain this property for future inserts directly into the new table, but you will also need to insert existing rows from the current table with the correct ID values. This situation is common and can be solved elegantly using the identity_insert option.
Using identity_insert, you can override the SQL Server automatic generation process of the column value for the identity column of table, and explicitly supply your own values. Once you have finished inserted these values, you can turn the identity_insert column off, to allow the column to behave normally and generate sequential identity values. You will have to research this particular aspect of behaviour to understand exactly how the identity column will respond after you turn identity_insert back off, and having inserted a random series of values. From experience a few years ago mind you, I don't believe there is any problem here and that SQL Server just resume the identity column counter by adding one to the maximum integer value in the column.
If on the other hand your table will be used in a more static context, for example bespoke data analysis, then I would suggest creating a table without the identity column. The corresponding column in the new table will have the same data type as the source table and will maintain a foreign key relationship back to the source column to ensure integrity throughout the lifetime of the table use in analysis.
Using this approach, without the identity column, you can copy the data using a simple multiple row insert operation. A example of this is below:
insert into destinationTable
columnA,
columnB,
columnC
select
columnA,
columnB,
columnC
from
sourceTable
It's important to remember that there are no restrictions, or very very few, that apply to a select statement when used as the source for a multiple row insert. Therefore, you should not hesitate to use any conditional constructs any other elements of the SQL language to ensure you insert only the data that you want. Often this feature is overlooked and people forget that the select statement need not be a simple one set query.
Regards,|||I think it is the identity insert option I need to use, I will give it a go in three days when I do the test transfer, then post on the outcome,
There is the Identity insert option on the Export data tool, Is this the option your talking about? or is there an option in the table properties?|||There is only one way to apply identity_insert, which is as a table option applicable only to the current session and for the duration of that session or until the option is explicitly turned off.
I would say that the option to enable identity_insert from within an ETL package is accomplished by the tool transparently issuing the option directly to SQL Server on your session's behalf. In this way, the ETL tool serves as just a GUI to execute SQL DDL and DML.
Nonetheless, you are correct in your thinking to investigate the identity_insert option. Just remember that column names must be specified when using this option, a requirement that often many people overlook and which can cause unnecessary frustration. This is one area where a tool similar to the one you describe can be helpful, in ensuring little compliance issues like this.
Regards,|||Got it worked a Treat, Use The Export Data tool in Management Studio, Not sure what I did differently to before, but I set the
Delete Rows in Destination table to true (even though it was empty)
And Enable Identity insert to true
Copied all the data as it was, missing all the PKs It had been including, and the PK count after the insert of the data starts at the last record it doesn't fill in the gaps, thanks for your help.
Currently when I export the data the data will run through an insert type statement, which means that all PKs are reissued, rather than being duplicated from the original, How can I be sure that the data will be copied exactly how it is on one server to the other.It sounds as though the table that you want to copy the data into, has an identity column assigned to it. For the situation that you have described, there are two solutions available, each depends on how this secondary table will be used.
If the new table will be used in a transactional environment and it must maintain correct relationships with other tables, then you will need to maintain the same list of primary key values. To do this, we need to understand how your values for the primary key column is generated. I'm assuming a non-composite (single column) key for your system.
If it's an identity column, then you will want to maintain this property for future inserts directly into the new table, but you will also need to insert existing rows from the current table with the correct ID values. This situation is common and can be solved elegantly using the identity_insert option.
Using identity_insert, you can override the SQL Server automatic generation process of the column value for the identity column of table, and explicitly supply your own values. Once you have finished inserted these values, you can turn the identity_insert column off, to allow the column to behave normally and generate sequential identity values. You will have to research this particular aspect of behaviour to understand exactly how the identity column will respond after you turn identity_insert back off, and having inserted a random series of values. From experience a few years ago mind you, I don't believe there is any problem here and that SQL Server just resume the identity column counter by adding one to the maximum integer value in the column.
If on the other hand your table will be used in a more static context, for example bespoke data analysis, then I would suggest creating a table without the identity column. The corresponding column in the new table will have the same data type as the source table and will maintain a foreign key relationship back to the source column to ensure integrity throughout the lifetime of the table use in analysis.
Using this approach, without the identity column, you can copy the data using a simple multiple row insert operation. A example of this is below:
insert into destinationTable
columnA,
columnB,
columnC
select
columnA,
columnB,
columnC
from
sourceTable
It's important to remember that there are no restrictions, or very very few, that apply to a select statement when used as the source for a multiple row insert. Therefore, you should not hesitate to use any conditional constructs any other elements of the SQL language to ensure you insert only the data that you want. Often this feature is overlooked and people forget that the select statement need not be a simple one set query.
Regards,|||I think it is the identity insert option I need to use, I will give it a go in three days when I do the test transfer, then post on the outcome,
There is the Identity insert option on the Export data tool, Is this the option your talking about? or is there an option in the table properties?|||There is only one way to apply identity_insert, which is as a table option applicable only to the current session and for the duration of that session or until the option is explicitly turned off.
I would say that the option to enable identity_insert from within an ETL package is accomplished by the tool transparently issuing the option directly to SQL Server on your session's behalf. In this way, the ETL tool serves as just a GUI to execute SQL DDL and DML.
Nonetheless, you are correct in your thinking to investigate the identity_insert option. Just remember that column names must be specified when using this option, a requirement that often many people overlook and which can cause unnecessary frustration. This is one area where a tool similar to the one you describe can be helpful, in ensuring little compliance issues like this.
Regards,|||Got it worked a Treat, Use The Export Data tool in Management Studio, Not sure what I did differently to before, but I set the
Delete Rows in Destination table to true (even though it was empty)
And Enable Identity insert to true
Copied all the data as it was, missing all the PKs It had been including, and the PK count after the insert of the data starts at the last record it doesn't fill in the gaps, thanks for your help.
Saturday, February 25, 2012
Copying a database to another server
Im running SQL Server 2005 Express with SQL Server Management studio installed on my laptop. After updating my database, how do I copy the entire contents to the main server in the office, which is running windows server 2003 and SQL Server 2000 Developer Edition.
And is it possible to do it all from my laptop?
And is it possible to do it all from my laptop?
right click the database an you will see a context menu. on one of the sub menus here you will see generate script. In the wizard, one of the options is to specify sql 200 compatible
After running the script on the office server, right click on the database, select export, follow the steps in the wizard to export the data.
copying a database in the same SQLserver instance
Hi
Im using SQL server express and Management studio express, and i have a database attached called database1.
Now i would like to have an exact copy of this database, named database2.
I would only need the tables, and not the data in them, is there somehow i can do this?
There is no copy button in managment studio...
Create a new database called Database2, make Script of the database1 and open a query analyser window, change the database in the dropdown combo to datbase 2 (or run Use database2) and run the script
Steps to script database
(a) Right Click on DB
(b) Tasks Generate SQL Script and follow the instruction. You will get script without data.
Madhu
|||Thank you for that..
I have no idea what it did with those scripts and such, but it made a perfect copy like i wanted..
Copy/Paste text into a field
I've encountered a strange problem with the Microsoft SQL Server Management Studio.
When I manually edit a record in a table and want to insert text with more lines, only the first line is copied into the field.
The field type I use is nvarchar(max) but it doesn't really matter what type it is.
The problem only exists in the Management studio. When I perform the same task in the "old" Entreprise Manager it works fine.
Am I doing something wrong or does anybody have a key to whats wrong?
Thanks!
Ken
I don't think you are doing anything wrong. I suspect the edit control in the grid just doesn't support multi-line text.
Please report this issue here: http://lab.msdn.microsoft.com/productfeedback/Default.aspx
We use defect reports and feature requests filed at the feedback center to make decisions about future versions and service packs of SQL Server.
As a work around, you could write a T-SQL update statement to make the change you want. That's how the grid control updates the table behind the scenes.
Thanks,
Steve
I'm also having a similar problem. I often copy/paste text between database tables (usually a development table and later a production table).
This works fine in Enterprise Manager, but Management Stuido(2005), cells that contain multi-lines are not copied (it seems to be "blowing up" on the crlf; it dosen't seem to be an issue with the length of the text copied).
Its possible that there is a setting somewhere to change the behavior of the Results grid to allow this, but thus far I haven't found anything.
I followed the link provided above, but eventually decided it would be easier to write my own interface than to follow all the trails now necessary submit feedback. :)
At least I can complain here. :)|||
I just did a quick search on Microsoft Connect for any bug that was reported by customers, but did not find anything.
https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=copy+paste
Could you this suggestion on http://connect.microsoft.com/SQLServer/?
Thanks,
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
Copy/Paste text into a field
I've encountered a strange problem with the Microsoft SQL Server Management Studio.
When I manually edit a record in a table and want to insert text with more lines, only the first line is copied into the field.
The field type I use is nvarchar(max) but it doesn't really matter what type it is.
The problem only exists in the Management studio. When I perform the same task in the "old" Entreprise Manager it works fine.
Am I doing something wrong or does anybody have a key to whats wrong?
Thanks!
Ken
I don't think you are doing anything wrong. I suspect the edit control in the grid just doesn't support multi-line text.
Please report this issue here: http://lab.msdn.microsoft.com/productfeedback/Default.aspx
We use defect reports and feature requests filed at the feedback center to make decisions about future versions and service packs of SQL Server.
As a work around, you could write a T-SQL update statement to make the change you want. That's how the grid control updates the table behind the scenes.
Thanks,
Steve
I'm also having a similar problem. I often copy/paste text between database tables (usually a development table and later a production table).
This works fine in Enterprise Manager, but Management Stuido(2005), cells that contain multi-lines are not copied (it seems to be "blowing up" on the crlf; it dosen't seem to be an issue with the length of the text copied).
Its possible that there is a setting somewhere to change the behavior of the Results grid to allow this, but thus far I haven't found anything.
I followed the link provided above, but eventually decided it would be easier to write my own interface than to follow all the trails now necessary submit feedback. :)
At least I can complain here. :)|||
I just did a quick search on Microsoft Connect for any bug that was reported by customers, but did not find anything.
https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx?SearchQuery=copy+paste
Could you this suggestion on http://connect.microsoft.com/SQLServer/?
Thanks,
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
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:
>
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:
>
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
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Copy/Paste Fails in Management Studio
After opening Management Studio and doing some editing it is possible to copy/paste things in the query editor. After a while (working in another app) I come back to Management Studio and I can't copy/paste anything anymore. If I try to copy from the results window I get an error message that the clipboard operation did not succeed. If I try to copy from the query editor window it just doesn't copy. I can copy/paste in other apps without a problem.
I have seen this problem described in other forums so I'm not alone but I have 3 other computers where this problem does not occur. The one machine with the problem is hyper-threading. I wonder ....
Any other ideas? It is not the clipboard getting full but I can't rule out much else.
What is the configuration of those machines?
I believe the copy/paste cache is depend upon the operating system and resource usage, I don't see any problem with SSMS here. If it is a normal text then based on the memory usage that shouldn't be a problem.
|||You are not alone, I had this happen to me also where the copy paste functionality quit working but under slightly different circumstances. I am running Windows XP Professional SQL Server 2005 Standard Edition SP2. I started working in SSMS yesterday and copy paste functionality was working fine. I did not shut down the program or my machine over night and when I logged onto my machine this morning to continue working in SSMS the copy paste functionality was not longer working. I have never had a problem with this functionality until today. I see that someone else reported it as a bug. I suggest that you also log onto the but report and validate that this is an issue. The link is: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126743
Maybe if everyone who has this issue reports it then someone will do more research to determine the cause of the problem.
GN
Friday, February 24, 2012
copy to mdb file
how can i create a mdb file which represents a current database in sql server managment studio? i thought this would be obvious but it's not..Search the help files in Access for linked tables
Subscribe to:
Posts (Atom)