I've got a problem pasting data from the result grid of SQL Server 2005 to an excel 2007 spreadsheet.
I have a query in SQL Server that returns 2 columns (a number column and a text column)
On one computer here i can happily copy (right-click copy) and then just right-click and paste into an excel spreadsheet. no problem.
On another computer here when i try and paste into excel it splits the text column up and pastes the text into multiple columns based on spaces between words.
For example if one of the rows has...
Paste me please
...in it then when pasting into excel it splits the text and pastes each work into a seperate column within excel.
We've tried comparing options in both SQL Server & excel with the computer it works fine on but can see no differences.
Any ideas welcome
Thanks
I want to measure the overhead in creating a TCP connection.
I know of many tools like hping and netperf, but they seem oriented at measuring latency.
I want to know how long the 3-way handshake takes, and allocating any buffers, etc., and then closing it. So I want to open a real, legitimate TCP connection, and then close it.
Are there any tools that will do that and help me measure performance?
I am newbie struggling to move a file on a Linux VPS using PuTTY.
I can log in with a user in PuTTY at this point I can navigate to see the file I wish to move (~/servers/apache-solr-3.6.2/example/webapps/solr.war).
By using cd .. a couple of times from the directory I begin at when I first log in to PuTTY I can then navigate to the location I wish to move the file to:
usr/local/jakarta/apache-tomcat-5.5.36/webapps/
I know that I need to use cp to copy the file and have tried variations on:
cp ~/servers/apache-solr-3.6.2/example/webapps/solr.war usr/local/jakarta/apache-tomcat-5.5.36/webapps
However each time I get 'No such file or directory'
I have tried excluding the ~/ and the start and I have tried specifying solr.war at the end of the command.
Please excuse the newbie question, but I would really appreciate some advice on what I am doing wrong here.
I have a growing number of PCs and laptops in my home that need a backup solution. My question is 2 fold:
Most commercial backup vendors
appear to license by the machine,
are there any products that give a
license that can be used on all your
machines, without a per machine
cost?
An alternative is to have a
centrally controlled back up
strategy controlled from a single PC
with an attached hard drive that can
back up other machines on the
network. What backup software is
suitable for this approach? Will
this software be windows/Linux
interoperable?
I've searched for duplicate questions but don't see anything that addresses the multi machine/cost issue.
OSs in network will be Windows (XP, Vista, 7) and Linux variants.
Not pattern to when machines will be switched on.
I was messing around with solaris and decided to give Solaris 11 a try so I downloaded it from the Oracle website. After installing the OS, I went into the package manager and did an update. It told me that there were to available updates! I find this hard to believe considering that it's running a vulnerable version of firefox and java, its own in-house software product! Many of the other software products that came with the default install are also out of date and vulnerable. Is this normal for an Oracle install, or did I do something wrong with the upgrade process? I typed "pkg update" at the prompt, and I noticed that it did call out to pkg.oracle.com looking for updates. I find it bizarre that there are no updates available for an OS that was released a couple months ago with vulnerable software...
Why can a mp3 file-name be 165 characters long in its original folder, but when searching that folder, the search results window only allows editing of the first 130 characters of that same mp3 filename? This did not happen in XP! The problem occurs with both local and external drives. The act of searching doesn't somehow add to the file-name's path does it? I need to edit filenames in the search window (as I did with XP successfully) but now the search window results suddenly cannot be edited.
At work (UK university) we use a set of Windows servers running WS2008R2 and RRAS which offer VPN service to students in our accommodation. We do this to associate the network connections with individuals. Before they've connected to the VPN all they can talk to is the stuff thats needed to setup the VPN and a local web site with documentation on how to connect. Medium term we'll probably replace this but it's what we're using at the moment.
VPN on the 2008 servers allocates client a private (10.x) address. Access to external sites is through NAT on the campus routers (same as any other directly connected client on a private address). Non-VPN connections aren't seeing this problem.
Older servers run WS 2003 and ISA2004. That setup works but has become unreliable under load. Big difference there was that we were allocating non-RFC1918 addresses to the clients (so no NAT required).
Behaviour we're seeing is that once connected to the VPN, clients can reach local web sites (that is sites on the campus network) but only some external sites. It seems (but this may be chance) that the sites we can reach are Google ones (including YouTube). We certainly have trouble reaching Microsoft's Office 365 service (which is a pain because that's where mail for most of our students is).
One odd bit of behaviour is that clients can fetch (using wget on a Windows 7 client) http://www.oracle.com/ (which gets a 301 redirect) but hangs when asked to fetch http://www.oracle.com/index.html (which is what the first URL redirects to). Access works reliably if we configure clients to use our local web proxies (Squid).
My gut tells me that this is likely to be something in the chain dropping replies either based on HTTP inspection or the IP address in the reply. However I'm puzzled about why we're seeing this with the VPN clients.
Plan for tomorrow (when I'm back in the office) is to setup a web server on external connection so that we can monitor behaviour at both ends of the conversation (hoping that the problem manifests itself with our test server).
Any suggestions for things we should be looking at?
My parents have a reasonably ancient Visioneer 4400 USB scanner. The power supply has died. (I figured this out because I have a hard drive enclosure with a very similar power supply, and it worked.)
Where can I find a replacement one?
For a programming project I would like to access the temperature readings from my CPU and GPUs. I will be using C#.
From various forums I get the impression that there is specific information and developer resources you need in order to access that information for various boards.
I have a MSI NF750-G55 board. MSI's website does not have any of the information I am looking for. I tried their tech support and the rep I spoke with stated they do not have any such information.
There must be a way to obtain that info.
Any thoughts?
I want to download the following subdomain with the recursive option using wget:
www.example.com/A/B
So if that URL has links to www.example.com/A/B/C and www.example.com/A/B/D, these two should also be downloaded.
But I don't want anything outside the www.example.com/A/B subdomain to be downloaded. For example, if www.example.com/A/B/C has a link back to www.example.com, the page www.example.com should not be downloaded.
What wget command should I use?
I'd like every tweet about certain topics saved, so tweets with a certain hashtab, word, user, etc.
To reiterate, if I see a tweet, I want to save it forever and ever.
I'm running ubuntu linux, but a web app is fine.
We have a Dell 2950 with PERC and 14 external SAS 15K 73GB drives. An Oracle database job takes 3 hours to run with the drives set as hardware RAID 10 (striped across 7 mirrored pairs). The same job with the drives in RAID 1 takes only 1 hour. OS is Win 2008 R2 I think.
Before we change the RAID level (with considerable downtime) on the production box, does anyone know why we're seeing this odd result, and if there's a better way to fix it?
Recently, an in-house Microsoft Small Business Server 2011 was installed where I work. Unfortunately, our buildings have a bad electrical power supply and we suffer frequent outages. We have a large percentage of staff working off-site. Now when the power goes off here, everyone everywhere loses email functionality.
I have been assigned to research the possibility of routing our email to Google Apps while maintaining LAN functions on the SBS. I haven't worked with Microsoft products for several years now, so do not know how SBS is structured.
Can anyone here tell me if this is possible, or point me to good resources that explain our options?
I was trying to remove a virus and foolishly did not backup registry keys I deleted because I (thought) I only deleted entries from the folders of programs I did not care about. However, I think I have done something wrong here:
Now when I open a context menu (right click) in any location and hover over the "New..." option I don't get any options. It has a greyed out box saying "(Empty)".
So far I have found out the the entries themselves are still there (using the locations provided here: Windows 7 - Add an item to 'new' context menu). I have also used a program recommended in that thread which also finds the entries intact and enabled.
So it seems maybe I have deleted the entry which tells Vista where to look to find the files that can be created.
How can I restore this so entries are shown again? I know system restore is an option but as I have said I did this when removing a (very stubborn) virus so that is the last resort.
On my Exchange server I can drop appropriately formatted text files in the "pickup" directory and Exchange will process them.
I'd like to split this bulk mailing functionality onto another box to protect our business mail IP from the bumpy ride that our monthly newsletter gives us.
I should note at this point that the mailing is opt-in with an opt out link included and only goes to people who pay to be a member of our organisation
The ideal solution for me would be to add a linux box to use just for this purpose so we're not paying for Exchange licenses.
So is there a linux equivalent of the Exchange pickup directory?
On my Exchange server I can drop appropriately formatted text files in the "pickup" directory and Exchange will process them.
I'd like to split this bulk mailing functionality onto another box to protect our business mail IP from the bumpy ride that our monthly newsletter gives us.
I should note at this point that the mailing is opt-in with an opt out link included and only goes to people who pay to be a member of our organisation
The ideal solution for me would be to add a linux box to use just for this purpose so we're not paying for Exchange licenses.
So is there a linux equivalent of the Exchange pickup directory?
I have a specific use case where I would really like to be able to change a user's password with a single command with no interactivity. This is being done in a safe fashion (over SSH, and on a system with only one user able to be logged in), so it's fine to expose the new password (and even the old one, if necessary) on the command line. FWIW, it's a Ubuntu system.
I just want to avoid having to add something Expect-like to this system for just this one task.
FC11 beta upgraded to FC12. When I do yum list I see listing on the far right column as follows: 'fedora' 'installed' and '@fedora'. Previously I never had '@fedora' and only seemed to appear when I upgraded from FC11-FC12.
Also when i look at the kernels installed I have
kernel-PAE 2.6.30-0.97.rc.fc12 installed
kernel-PAE 2.6.31.5-127.fc12 @fedora
Why do I have two entries?
i'm adding some hard disk on my computer.when i on my computer the extra hard disk was detected by my computer but when i open My Computer the extra hard disk was not on there. What happen?
I know i can use Domain Tools and the like for checking if a domain name is available but is there some way to be alerted when a certain domain name becomes available that is currently taken?
I've checked MSDN, and the W3C format, but nothing seems to explain what causes IIS to output "..." in the "cs(Cookie)" column.
My assumption is that the cookie is "too big", but I'd like to know for sure and also what is the limit before IIS outputs "..."?
when i try converting a film it goes through the full process it even says operation complete afther burning but disks still turn out to be blank i have used convert x and imtoo avi convert to dvd how can i solve this