• Database files in Oracle 9i

    i had installed in my PC oracle 9i. i dont have time in practice in niit instutute. i had decided i will prctice in my home but problem is i dont used database file in oracle can u tell me setting about db files

    Varsha500950 pointsBadges:
  • Do you have an IT blog or website and want to earn 100 knowledge points?

    We hope you find this community helpful in answering all your questions. But we want everyone to get every answer they need and wthat means more experts are always welcome. That's why we're asking you to tell your friends about IT Knowledge Exchange (ITKE). If you have a blog or website that is...

    ITKE345,305 pointsBadges:
  • Importing a “flat” field into a Lookup Table format in SQL database

        * I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated...).     * I have created a table...

    Roguetexan5 pointsBadges:
  • “map drive” IFS

    Hello, We have a ?LAN without any server Windows OS in it? , so everybody is a client (with fixed IP). The only ?server? we have, is our iSeries i5 (V5R3) with iSeries Access(CA) installed (also on the clients). We cannot ?map drive? the IFS f.e. root with \QS6555A8Aroot (or anything else on the...

    Hahajokes5 pointsBadges:
  • Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?

    What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

    NewnanIT1,110 pointsBadges:
  • Migrating from Windows server 2003 32-bit to Windows Server 2008 64-bit

    We are migrating from Windows server 2003 32bit to 2008 64 bit. What should we be aware of before progressing? What pitfalls or incompatibilities should we be prepared for? The server is an Active Directory box running SQL 2005.

    NewnanIT1,110 pointsBadges:
  • How do I INSERT records into AS400 DB2 file from SQL server?

    I can pull data from AS400 to SQL but cannot get my command on the SQL server to push the data back.  This is a very small process, I only need an item number and date. Also, the date on the SQL db is "datetime".  I'll need to convert that to a more recognizable date field to put in the AS400...

    Normap2275 pointsBadges:
  • Connecting VC6 to SQL server

    how can i connect VC++6 MFC application to SQL server? plz help m out!! :(

    Munazza5 pointsBadges:
  • SQL Server error 7125: Updated driver to get around?

    I have used Microsoft ODBC SQL Server Driver to create a link to an SQL table using Microsoft Access. The table stores Word documents. However Access will not save records once large pictures are added to the Word document (thus increasing the size of the document). The following error occurs:...

    Health2u5 pointsBadges:
  • Using Excel 2010 to pull data from SQL Server?

    How can I use excel 2010 to pull data from my sql server? I have an odbc connection set up and need data from a specific table in a specific database. I want excel to do some projections and calculations.

    NewnanIT1,110 pointsBadges:
  • Cannot forward events from SQL Server 2005

    I'm trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server.  What must I do to see other servers in the Event Forwarding Server drop-down box?

    Bmajor5 pointsBadges:
  • Documenting stored procedure jobs in SQL 2005 enterprise

    Our consultant created several stored procedure jobs within SQL 2005 enterprise. How can we view them to document them? SQL runs on a Windows 2008 box with 32gb of memory.

    TeachMeIT975 pointsBadges:
  • Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard

    I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it's shows not...

    SQL815 pointsBadges:
  • IT Book Giveaway: Oracle Solaris Cluster Essentials

    We've got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There's even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one...

    MelanieYarbrough6,345 pointsBadges:
  • Improve performance on Insert rows into DB2 400 table from SQL server

    Using INSERT OPENQUERY and a linked server on SQL Svr 2005, to insert rows to DB2 table on AS400. To a local AS400 runs very quickly. Performance on a remote 400 is very slow, and seems to be out of proportion to the change in line speed. Is there anyway to improve the performance for Inserts to...

    Code2live55 pointsBadges:
  • SQL SERVER 2005 Database Options

    We have a database in production that is 500GB, what are the pros and cons for setting the "Page Verify" option to "NONE" on the database for best performance? How will "TORN_PAGE_DETECTION" and "CHECKSUM" affect performance?

    Rick Martinez585 pointsBadges:
  • Extracting in SQL Server 2005

    IS THERE ANY WAY TO EXTRACT FROM A FIED EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120                                                       SCHAUMBURG...

    Hydrostani20 pointsBadges:
  • ESXi v4.1 White Box

    I'm looking to put together a server to run ESXi v4.1.  I've selected the following hardware components and would appreciate any advice/input good/bad:  Case: Athena Power CA-SWH02BH7  Mobo: TYAN S8230GM4NR-DL  PSU: Athena Power AP-P4ATXK110FEP  CPU: AMD Opteron 6134 Magny-Cours 2.3GHz  64gig...

    DaveMPA55 pointsBadges:
  • Write Record to table as XML from RecordSet destination

    Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?

    Kayj5 pointsBadges:
  • How can I take a backup of a SQL Server stored procedure only?

    How can I take a backup of a SQL Server stored procedure only?

    SQL Server Ask the Experts2,585 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