• Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

    I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as v_inputfile            ...

    jkeri360 pointsBadges:
  • Calling MS Server from iSeries Stored Procedure

    Hi, I have an ODBC linked server connecting MS SQL Server to my iSeries. What products (other than Java), if any, would I need to be able to call a MS SQL Server Stored Procedure from an iSeries Stored Procedure?

    JeffreyStark5 pointsBadges:
  • Would SQL Azure be PCI DSS compliant?

    I'm trying to figure out if I were to separate Windows Server (which was PCI DSS compliant), would it still be compliant if SQL Azure was hosting the back end? I'm only storing permitted values and I'm compliant at the application layer too.

    ITKE351,905 pointsBadges:
  • SOP for cleaning Server rooms

    Hi there, I have been tasked with organizing cleaning of comms, IDF, MDF rooms at our offices. This includes: removing dust from racks, actually all surfaces - cleaning floor , light fixtures etc. Does anyone have a SOP / Method statement of how this should be carried out? Does it require...

    Sinead5 pointsBadges:
  • Add’l CPU per index?

    I'd love to use the LASTUSED column on SYSIBM.SYSINDEXSTATS introduced in DB2 9 to eliminate indexes. I can show my client a number of indexes that have not been used since DB2 9 was installed in July 2009. But I know they will ask 'what is the ROI on deleting these indexes?'. Is there any 'general...

    kjolson5 pointsBadges:
  • Instance specific error when connecting to SQL Server

    What is instance specific error? It is occuring while connecting to SQL Server  ... how can i fix this error?

    FAIZAHAFEEZ5 pointsBadges:
  • How to open .db files with Excel

    Hi, how to config Excel to allow opening of .db files?

    cfs0105 pointsBadges:
  • What data should be stored in SQL Azure and Table Storage?

    My team and I are in the planning phase for the typical social networking type of a web application. It includes profiles, messages, chats, groups, albums, etc. But now we're trying to figure out the deciding factors on what data should be stored in SQL Azure and what should be stored in Table...

    ITKE351,905 pointsBadges:
  • Restore a SQL Express 10.0 database

    How can I restore a SQL Express 10.0 database on SQL Express 10.5?

    sam4umore5 pointsBadges:
  • Disk Partitioning w/SQL Server 2000/2005/2008

    I recently read some information regarding aligning the Disk for use with SQL Server from Mr. Denny. My understanding is, SQL Server handles data in chunks of 64KB, so the disk drive SQL Server writes to containing data and log files should be configured to work in 64KB chunks. The articles I am...

    JohnMCouch5 pointsBadges:
  • Set up retention policy for deleted items folder on Exchange 2007

    How to set up retention policy for deleted item folder on exchange 2007? I would like to run the policy to empty the folder based on item age. Thank you.

    X4y10 pointsBadges:
  • SQL Server 2008 database backup terminating abnormally

    I'm running this code for backing up and to have backup log: backup database adventureworks to disk = 'g:radvent6.bak' mirror to disk='g:radvent7.bak' with format,checksum,stop_on_error use adventureworks insert into HumanResources.department (name,groupname)values('dreee','reserch') backup log...

    Tablestructure15 pointsBadges:
  • What is a File copy limit in Windows XP?

    Does any one know what is a copy limit in windows XP as when we copy a lot of small files Windows XP stations come up with low resources error ex. we copy 40GB=800000 files windows 2003 server edition is fine no problems.

    Dimchik0 pointsBadges:
  • Import data from Access into SQL Server 2005

    Hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into MS SQL Server 2005. I am receiving info into database access on a daily basis. So I have to do an auto job to import data from access into SQL Server 2005. I think that creating a...

    7715 pointsBadges:
  • Do extra spaces affect disk space size?

    I currently have over 147 columns in a SQL Server database (with the majority of them as VARCHAR). This data is imported from our agency and for extra fields, they all include spaces in the field instead of entering an empty string / NULL. I just ran a script that would covert all those columns to...

    ITKE351,905 pointsBadges:
  • How many users can access the file stored on SQL Server 2008?

    After we store any file on our SQL Server 2008, how many clients will able to access that particular file from the server at a time?

    NikhilGaikwad5 pointsBadges:
  • Ghost imagaing

    Hiya all, Specs first.. Ghost Corporate multicast server 7.5. Switches are all 3com, 10/100. Wireless network is 10mg network ports (2) shared via 2 wirelss access points, (D-Link 22Mbps) Problem is, whenever i image multiple machines, the whole network goes slow. The machines affected are old and...

    Carl0s810 pointsBadges:
  • Behaviour of Service Broker during clustered SQL Server failover

    Hi, I have 3 instances of SQL Server 2005 hosted on a 3-node cluster, using Polyserve clustering.  Each instance is nominally hosted on its own node in the cluster. I have configured Service Broker to route messages from INST-A (on NODE-1) to INST-C (on NODE-3), using TCP and a NetBIOS name....

    SimonNZ5 pointsBadges:
  • Open IT Forum: What do you want to see from IT Knowledge Exchange in 2012?

    We asked what your goals are for late 2011 and early 2012, but now we want to know what you hope to see from the IT Knowledge Exchange community. If there's a functionality you would like to see, or a topic you want to know more about, let us know in the discussion section! Don't be afraid to get...

    MelanieYarbrough6,345 pointsBadges:
  • Adding a field when using SQL to copy a file on iSeries

    My company is upgrading some applications and I need to copy the data from current files into the new files. In some cases the new files have additional fields. Is there a way with sql to copy the current data and at the same time add either a default value or a running sequentional value to the...

    CLK35 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