Search results for query: *

I found them, the paths to the old datafiles were obviously still there, so the emails just downloaded in to my old pst... I just copied them over and removed the old datafiles again and then made sure I restarted outlook this time ;)

Yes, I ended looking at all files created in that day, regardless of size but couldn't find anything that looked right? Perhaps it's in some kind of hidden temp directory?

Yeah I've tried that one... no joy Thanks anyway!

Help! I've been using my online webmail for a while and I decided to download them all with Outlook 2003. So I created a new pst datafile for them, set it to default and removed the other datafiles to keep things simple. I then enterd my password (my account details were already in to collect...

LOL Thanks Neil ;)

Hi Neil, Thanks again, appreciate the advice I get the logon box straight after booting it up, it's over the course of the next few days after a restart. I lock the computer after I'm finishined doing what I'm doing which leaves windows security window on screen. I am using a KVM switch, maybe...

Hi Neil, Thanks for the reply. I have control over the mouse cursor, the caps lock etc keys work. I get the blue windows "screen" just minus the logon. I don't have any GP's configured to disbale local logon at all. An Identical machine doing almost identical tasks, although a lot less...

One of my file servers running 2003 keeps losing the log on prompt? I can access the drives across the network and it operates fine but I can't log on or shutdown. It gets to the point where I have to shutdown the machine by simply turning it off and I really don't like doing that? Does anyone...

Thanks

Whats the best way to remove spaces from a varchar field? i.e 01256 562125 Thanks guys

Once again thanks guys!

I have a very large database of name, address and telephone numbers. There are multiple contacts with the same address and phone number. How can I create a table containing A single contact and telephone at unique addresses?? Thanks

Hi, I have a Windows 2003 Server PDC, I partioned the drive when I installed the OS. However, I would now like to mirror the drive. Is there anyway of doing this without losing the install and set-up data. I know I need to remove the partion, is there a safe way of doing this??? Thanks all.

Thank you earthandfire your solution was exactly what i was looking for, the problem i was having that i was checking if the file existed but this was not enough because it could exist but still be writing.

Thank you for your response, could you put a couple of lines of code as a example im not quite sure what you mean.. thank you

Hi there, Ive got a program that exports a file then it using the winzip command line to zip it up, once zipped the program attaches the file to a email. The problem im having because the zipping is taking place externally from the program the email is trying to be sent when sometimes the zip...

Thanks for your response, I think I know what you are getting at. I was thinking more along the lines of some kind of IF statement that looks for telephone numbers it has already inserted and inputs the most populated record with that number. The database I have contains many millions of rows...

Good Morning all, I have a large volume of data which has names, addresses and telephone numbers. I need to condense the list down to one contact per site. In MS Access I could simply put the telephone number as the primary key and "squash" the data in, but SQL doesn't like that. I would also...

Spot on, Perfect, thanks very much!!!

Thanks for your response! I basically want to extract data from the table via the TOPN query with an order by but the numbers are sequential and I want a random selection. I have tried your suggestion but it seems to copy the random number on every row.