• 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:
  • Users/Roles/Schemas

    I'm trying to find some documentation or procedures that will allow me to xfer existing users' roles, etc from sql2000 to sql2005. When our sql 2005 database was restored on a new server (from sql2000), all of the database users were orphaned. I need to create identical server logins and then make...

    Wsyeager0 pointsBadges:
  • Executing a Function or Procedure from ouside Oracle

    I have verified the code below as a valid Function and it executes from TOAD. It does not work if called from: SELECT F_T_TOTALE_TO_T_SCRAP_SC(V_TIRE_ID_EXTRACT) FROM T_TOTALE The Error is 14551. I have researched this error and it states that a function cannot be executed from a SELECT statement...

    Moonmullins0 pointsBadges:
  • Oracle Parse – Instr

    I'm receiving a string pipe delimited I need to extract the data between pipes until the end of string. How do I do this? I currently have FUNCTION fParseValue (pValueMeters varchar2) return varchar2 is v_meter1 varchar2; begin v_meter1 := instr (pValueMeters, '|', 1, 1); v_meter2 := instr...

    Dava190 pointsBadges:
  • Sending Table Data From Oracle 9i To Sql Server 2005 using oracle 9i Trigger

    My aim is to send the data from oracle to sql server 2005 whenever there is data insertion, deletion or updation in the oracle table the same change needs to happen in the sql server having the same table structure as oracle.But I am not finding any way to accomplish this task.please help me. Have...

    Dhirendra100 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • Subquery returned more than 1 value.

    I've got a SP that has the following line of code: SET @totalLateRecords = (SELECT COUNT(*) FROM tableName WHERE tableName.fieldName <= 61)) I get the error "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery...

    Bbonsall0 pointsBadges:
  • Urgent Help: web-Forms 6i don’t work after Upgrading the db from 8i to 10g

    Hi, We have web-Forms 6i that are deployed on a server A and run against a database installed on a server B. The database was recently upgrated from version 8.1.7.4.0 to 10g AND moved from the server C to the server B. However we're using now for the server B the alias we've used for the server C....

    1081080 pointsBadges:
  • ODBC connections

    We have a database that is specifically designed for our industry. We want to be able to export the information into a mailing list. This is the email that I received from IT. "You cannot export to an access database, but you can connect to the KIDS database with Access or with Excel query to...

    Jade057110 pointsBadges:
  • VB.Net of Visual Studio.Net 2003 VS Visual Basic 2005 Express Edition

    Good Day! Would be appreciate if there is solution for the following problem: - In VB.Net of Visual Studio.Net 2003, developer can click and drag a table listed in the Server Explorer from a connected database to the form. This will add OleDbConnection control and OleDbDataAdapter control to the...

    Hunkgym5 pointsBadges:
  • Problems with underscore column names quering

    Hi I am having problems working with the PL/SQL, the thing is that I installed the oracle db 10g software wich i downloaded from the Oracle Site, now i am testing some queries, I have a table called GRP_GROUPS wich has some fields like ID, and GRP_Name, when i try to do a select like this: SELECT...

    Opereira0 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