• media recovery

    Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as "need media recovery". Please Guide me....

    Sukaina10 pointsBadges:
  • Call a stored procedure with output parameters

    Good Morning, I have created an oracle stored procedure which has 2 input parameters of type date and 1 output parameter of type PL/SQL table. I recieve errors when I try to execute the stored procedure in SQL*Plus. The stored procedure exists in a package and the Oracle database version is 10g. I...

    IYAN230 pointsBadges:
  • ASP .NET SQL Statement

    Thanks to SheldonLinker my earlier question has been answered. I continue to have 1 issuse and it is with my conditional SQL statement. I'm thinking someone will be able to correct this very easily. Here's the statement: If ("SELECT DataID FROM table1") = UserID Then Update Else Insert End If I...

    Wolfman240 pointsBadges:
  • Updating one record with a field of another record where two other fields match

    I have the following Table: XREF Group Projid id1 id2 ----- -------- ----- ----------- AEEC SOCAL 71 442760 CAG AWPE 71 442780 CAG MONDPL 71 447585 CAG PLANDI 71 442780 CAG SMCECA 71 442780 CAG AWPE 84 442781 CAG MONDPL 84 447588 AEEC MONDP 84 447589 CAG PLANDI 98 288923 CAG SMCECA 98 288923 CAG...

    Donnewbee0 pointsBadges:
  • SQL – IF Exists Update Else Insert

    I have searched far and wide but have not been able to solve this problem. I am still in the early learning stage and this is the most complex issue I've come across so far. I have a form that when submitted needs to either update fields in a table or insert new records. I originally created a form...

    Wolfman240 pointsBadges:
  • Lotus Domino Database Structure

    Hi I am trying to map a Lotus Domino Database into tables. Is is true that Views are like tables and documents are like rows in the view? Is this the right way to do it? If not, please could you explain how to do the mapping? Thank you in advance Mirkia Sadler

    Mirkia0 pointsBadges:
  • Correlated Subquery – NOT EXIST

    Hi - I'm trying to add a not exist subquery in my where statement and have several other joins ahead of it. I'm having difficulty determining where to put the NOT EXIST as the subquery is named as a column - ie blue.color in (select * from .....). Where would I put the NOT EXIST In this case?...

    Holl1230 pointsBadges:
  • Help on SQL Expression

    Hi, I'm new to the SQL environment and writing expressions and need some assistance or recommendations. Any help or assistance would be greatly appreciated! We have SQL 2000 HRIS system. We are implementing employees PTO plans. Rules: Hired in the month of 7,8 or 9, PTO earned is 120 hours Hired in...

    Number40 pointsBadges:
  • how to interconnect sql server with remote oracle server

    I have sql server on my system and Oracle system on the remote system and I need to fetch the data from the remote oracle on my sql server. please send me the steps of the whole process.

    Saahil0 pointsBadges:
  • SQL 2005 Restore

    Hello, Yesterday at 1400 I started a restore of a very small database. It is now 0745 on the next day and it is still in the RESTORING state. It can't take this long. Does anyone know what I can do??? I need to get this database back up, even if it is the version before the restore. Any help ASAP...

    Sawtooths0 pointsBadges:
  • Windows Server 2003 Web Edition Configuration

    I have been out of the web development arena for a few years and decided to brush up on new technology. I installed Windows Server 2003 Web Edition on my home domain and placed the machine in the DMZ. I published a basic page and all works well. I published a standard template forum from Frontpage...

    FlyNavy0 pointsBadges:
  • Proccess keep running. Cant find a solution

    Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it happened again. What may be wrong? How...

    Ileanab0 pointsBadges:
  • DB2/400 Stored Procedure Security

    I am new to the DB2/400 world and am tasked to speed up some of the reports and a GUI application. To accomplish this I am heading in the direction of using stored procedures and UDFs. My problems is that the shop that I am working in is basically a AS400 shop that has never used SP or UDFs so...

    LegalDev0 pointsBadges:
  • SQL Server 2000 Performance issue

    Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the...

    RizwanMurtaza0 pointsBadges:
  • restore deleted table-2

    1. How can I restore a single table that was accidentally deleted by not performing a full database restore? 2.How can I track the machine who deleted that table? Thanks

    Razorgrip0 pointsBadges:
  • Query

    I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command --- SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem FROM...

    ATitus85 pointsBadges:
  • Delivery system

    hi there, i was wonderinf if you guys have any codes in VB.6 about Delivery system. i'm using using it as a reference for my thesis. any help would be great! thanks! :)

    Playah070 pointsBadges:
  • Looking for SQL Statement

    Hello to all, I have following problem. I have a Table containing 2 Fields: Number and Date. The content could be following: Number Date 1 26.11.2006 3 29.11.2006 3 23.11.2006 4 25.11.2006 Now I want to select all numbers, but when there is a double (or more) Value (like 3), I would like to have...

    Chilkman0 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • Database Tuning Advisor “not permitted” error on SQL Server 2005 DE

    Hi! I've bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I've installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: "Tuning this edition of...

    Volrat0 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