Questions & Answers

  • Change date format

    I have a date field stored in the i5 as yymmdd that I would like to change to mmddyy when exported to Excel. If I just re-format the cell, Excel treats the number as a Julian date and mis-corrects the date. The other issue is that Excel drops the leading 0 so everything in this decade is...

    DanBubis75 pointsBadges:
  • Can you share with us what is consider best practices for PST files location

    Most users are placing their PST files on a shared drive because it gets backup by TSM; however, we recently had a disk corruption and during the problem determination someone mentioned that Microsoft does not recommend to place PST files on file-servers. Can you share with us what is consider best...

    ITKE346,305 pointsBadges:
  • Group Policies

    How can I turn on group policies after its been turned off by previous administrator, without having to re-install OS? ( it will not let me access any programs, system properties) Will not save any changes made in safe mode.

    S99abx20 pointsBadges:
  • Oracle: Putting more than 1,000 values using the IN clause

    Would there be a way to put more than 1,000 values in Oracle 10g using a static IN clause? I currently have a comma delimited list of IDs that I would like to use in the IN clause. When I hit 1,000 items, Oracle is giving me an error. Here's the query I'm using: select * from table1 where ID in...

    ITKE346,305 pointsBadges:
  • How to get the list of all tables in Oracle database

    I apologize for the short question but is there a way that I can get my Oracle database to display the names of all the tables in it? A query perhaps? Thank you.

    ITKE346,305 pointsBadges:
  • How to create an Excel spreadsheet from an Oracle database

    I currently have a table in a Oracle database and I need to create a complex Microsoft Excel spreadsheet structure from that specific table. Should I use SSIS to do this? Is there another way to create it? Appreciate the help.

    ITKE346,305 pointsBadges:
  • Easy access to local applications from a remote location

    I may have a very simple, or a complicated question. I would like to access some applications that are stored on a remote computer. Sofar I have been scared off by reading about “setting up a webserver, apply for DNS, RAS servers and whatever else”. All I really want is to allow to have secure...

    Simplr155 pointsBadges:
  • how do collision domain control domains, zones, pools

    How do I do collision domain control domains, zones, pools?

    Rarubookoojaje5 pointsBadges:
  • Can not save bitmap to disk – Lotus Notes error

    Hi all, Can any body help me out why the Notes Error: Can not save bitmap to disk occurs in Lotus Notes? Thanks

    Santooudnur70 pointsBadges:
  • How do I get into the switch portion of a Cisco 2811 if I forgot the password?

    How do I get into the switch portion of a Cisco 2811 if I forgot the password

    Oneofknowledge5 pointsBadges:
  • IPMI Driver hangs in VMware ESXI 4.0

    When attempting to load the IPMI driver in VMware ESXi 4.0 it keeps hanging. Is there a workaround?

    123456300 pointsBadges:
  • Error:1327 during installing orcale 10g

    I downloaded 10g express edition and tried to install to windows xp. An error 1327:Invalid Driver:E\ prompted. There is no E drive at all. Not sure what is going on? Anyone could help?

    Canaantt5 pointsBadges:
  • Damaged object in OS/400 QSYS

    I have a damaged object in QSYS library that is preventing our full backup completing. The object is QPZA006434 and is a *SRVPGM. I have tried to restore this object from backup but this has failed. Any suggestions to what this file is or does and to how I can fix it or remove it? The system is...

    GrahamM35 pointsBadges:
  • In VB 6.0 Data report for the numeric field , it should display in words

    In VB 6.0 Data report I have a number field eg 15685. It should display it as fifteen thousand six hundred and eighty five. I don't know how to code for this? Please help

    Try it90 pointsBadges:
  • Blackberry address Book

    So I have a customer who we put onto our BES server, so we hooked him up and it started to go and made it to 97% but then stopped there. It was stuck on address book. My client has 3900 contacts in his outlook and wanted to know exactly how many could be transferred onto the blackberry. So that is...

    Crookerse5 pointsBadges:
  • How do I implement a packet sniffer?

    I would like to know how to implement a packet sniffer. What are the steps involved in this process? Any help would be greatly appreciated. Thanks.

    NetworkingATE1,545 pointsBadges:
  • Exchange Cleansing

    What methodologies or tools are available to clean sensitive data from an Exchange store?

    Onenet10 pointsBadges:
  • IP phone configuration

    What kind of firmware do I need, to set up an IP Phone system in an office and where can I find an example in form of a diagram?

    Shiqu25 pointsBadges:
  • How can System Center accommodate a multi-point, distributed IT management organization?

    We run a 7 x 24 IT organization with “follow the sun” setup. How can System Center accommodate a multi-point, distributed IT management organization? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE346,305 pointsBadges:
  • Exchange Store does not seem to go to 75 GB

    We run Exchange 2003 standard and have changed the registry entries to increase our Stores to 75 GB. We got a warning at 22GB that the store had less than 1GB left. We dumped a bout 8GB of user mail to PST files and ran a offline defrag and checked event viewer 1221 after online defrag and still it...

    Easybrian50 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following