• How can we startup our DB if any one redologs is corrupted totally 2 redologs

    how can we startup our DB if any one redologs is corrupted totally 2 redologs.the corrupted redo is in archivemode.1st redo is corrupt tat is in current use of archive mode

    Kkvsaathish5 pointsBadges:
  • MIgration to 64-bit Sql Server

    What issues do I face with database file compatibility if I migrate from 32-bit SQL Server 2000 to 64-bit SQL Server 2005?

    Tomfitzrugger5 pointsBadges:
  • Analyzing Existing Indexes

    Hello, I am trying to analyze existing indexes on few tables. I think I can do this by using system views like sys.db_dm_index_usagestats, physicalstats and operationalstats. I am here trying to figure out disk space used by each index, I/O stats ,fragmentation etc I am wondering if ,Apart these...

    Sqloholic25 pointsBadges:
  • Improving the performance of full-text searches in SQL Server 2005

    Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?

    SQL Server Ask the Experts2,585 pointsBadges:
  • LSXODBC and MS-SQL Stored Procedure Parameters

    Using LSXODBC and ODBCResultSet, how do you pass parameters to a stored procedure using result.Execute or result.ExecProcedure? I am looking for a working example not just syntax.

    Mzrn1x5 pointsBadges:
  • Accessing an SQL 2005 Synonym with ODBC

    Is there a way to link to a synonym in SQL 2005 using ODBC and MS Access?

    Randym1,740 pointsBadges:
  • VB 2005-SQL CONNECTIVITY

    HOW DO I UPDATE A FILED IN SQL THROUGH VB 2005?

    N74015 pointsBadges:
  • Database Quality Control measures?

    Hi, I'm a developer working in a rather simple systems/data environment: three database systems - development, testing and live. obviously as the developer I work on the development server, once my development is done (and tested), the changes are implemented on the user testing server for...

    Les za30 pointsBadges:
  • Automated data entry for some controls based on data in other controls in Access 2003

    Hi: I am creating a bilingual (english/french) database wherein I need to have the french controls automatically filled when I choose an english term from a dropdown list in the correspopnding english control. Example: I have a list of terms in a combo box control (named 'domain') containing the...

    Willis125 pointsBadges:
  • How to pass value at run time from VB 6 to Access 2000 Query for reporting

    I have developed a sall application. Data is in Access 2002, Development is in VB 6. For reporting I have designed Queries, using the queries I have designed the reports. It works fine. While run time I accepts the criteria or value from user, based on that I have to show reports. My question is...

    Mayuri155 pointsBadges:
  • How to create a temporary table in sql 2005 via SSIS

    I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

    NewBee7105 pointsBadges:
  • Field editing for DB2 WebQuery

    How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn't seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own "editing". I...

    AS400 - Ask the Expert485 pointsBadges:
  • Making OMIT command inactive after a some count

    I have to write a JCL step in which I have to copy a file in to another file after omitting ONLY 5 records in which starting 4 position are having character 1644. Can you please help? Thanks in advance, Sushant Sharma

    VisionPlus5 pointsBadges:
  • How to mirror two databases (PRD to DEV)?

    HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks

    Rockleadme385 pointsBadges:
  • Copy old database as new

    Sir, I have SQL server 2003 Ex i have A database and closed the fincial year for new year entry totally new transaction i want create same databse New name B and then blank the record for new transaction pldase help me kishor.aware@rediffmail.com

    Krrish25 pointsBadges:
  • Data mirroring

    Hi Guys, Can any one tell me how can i keep two databases in sync? My problem : I have two boxes DEV and PROD and have a data library in each box. What i want is to keep my DEV data library in sync with the PROD real time. If real time is too difficult to achieve ......how about end of day?...

    Rockleadme385 pointsBadges:
  • Decimal places rounding to whole number

    In my Access 2003 form values with decimal places are rounding to whole number. I've set the property to fixed formal with 2 decimal places and the problem continues.

    Juju335 pointsBadges:
  • Text Box Only Allows Certain Characters

    I have a VB6 app running on windows application server, accessed via Symbol scan gun. Sometimes the user can't enter data they need to into a text box. I could enter spaces but no other characters or numbers. After entering spaces I tried to backspace and a box showed up (in the txtbox field) for...

    Rbsauls5 pointsBadges:
  • Wireless Controller 4404

    I currently have WLC 4124 and I'm in a process of testing new controller 4404. My problem is that I want to test only two APs from the existing on the new controller and not sure how to make them discovered on the new after disabling them on the current. The other issue - is there any risk of...

    Fmubarek15 pointsBadges:
  • oracle 9i instalation

    hello guys I have recently started learning SQL and I am trying to install 9i (database or software where I can practice SQL quires). Long time ago I started learning SQL on that time it was personal oracle7 I installed and used to do my practice...but now I have heard that you can install 9i on...

    11g5 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