• Outer Join

    I have two queries below. One table has one row for each the other table has many rows for each one in the first table. Can someone show me how I can join these tables and get the results I'm looking for? SELECT A.NAME AS TABLE_NAME , ',', B.NAME AS TBL_SPACE, ',', B.DBNAME AS DB_NAME, ',', B.BPOOL...

    DASully0 pointsBadges:
  • Default Group Policy Objects in Active Directory – Windows 2000 Server

    I've had to restore my Default Domain Policy and Default Domain Controller policy because somehow they disappeared. I'm using Sophos Enterprise Manager to automatically update all computers on the network. Everything is working as normal but I can't update the 2 Domain Controllers on the system. It...

    ITBird15 pointsBadges:
  • migration from 2000 to 2003 using ADMT v 2.0

    We have multiple forests in our organisation.We are now planning to consolidate them into a single forest and a single domain.We have more than 200 different sites spread all across the world. We have now upgraded all our domain controllers to 2000 and 2003 servers.We have a proper test lab being...

    Ambarmoorthy0 pointsBadges:
  • To go with RDBMS or OODBMS for a database to store textual excerpts

    Hello, I am currently designing a database to store textual excerpts: quotations from certain genres of literature will be stored. Relations will exist between different types of quotes and quotes and their topic sentences etc. I am deliberating on whether to use an RDBMS or an OODBMS for this...

    HellloAST0 pointsBadges:
  • Difference between SQL and T-SQL(Microsoft SQL Server 2000)

    What is the difference between SQL and T-SQL(used by Microsoft SQL Server 2000)?

    Kpatel0 pointsBadges:
  • I have some problem sending and receiving email in my ISA Server 2000 for certain users.

    Hai all I have some problem sending and receiving email in my ISA Server 2000 for certain users. The following are the details about my network. Windows 2000 server domain controller with active directory 150 clients they are using windows 2000 professional with static IP address. Now installed ISA...

    Management0 pointsBadges:
  • Database comparison

    I know this is 'cheating' but i was wondering if anybody had a quick way to compare two SQL2000 databases at an object level. I need to check the design of tables, code in Sp's etc. I think this can be done using systables, however i was wondering if anybody had done this and how easy it was. All...

    UselessOne0 pointsBadges:
  • Convert date format from UTC to PST in SQL

    HI Friends Is there any way to convert date format from UTC to PST? Thanks and Regards Ashu

    Ashug8bangalore0 pointsBadges:
  • Installation of Oracle9i client

    How to install Oracle9i client to c:program filesoracle and not to c:oracle on Windows Server 2003?

    Barusame0 pointsBadges:
  • Domino Database Last Used

    Does anyone have any tools they developed to search all the databases on a server(s) and report on them based on the last modified or created date? Or even point me in the correct direction. I am a rookie. Thanks.

    Coachkaz0 pointsBadges:
  • Secure Email Delivery Applications

    I am currently searching for the best application or service to provide end to end security for delivering encrypted emails from one company to another accross the Internet. I need the solutions to provide Smime, PGP, TLS, SSL, etc. My goal is to some how have the app or user decide if the email...

    Jclarkfl0 pointsBadges:
  • CLOB – Fetch out of sequence

    I am inserting into a table which has a CLOB field. I insert a blank_clob and then try and retrieve the clob field again directly after insert. When I execute the select to retrieve the CLOB field I am getting ORA-01002: fetch out of sequence. The query looks like: select XML_DATA from XML_TABLE...

    GinaOL0 pointsBadges:
  • Front-End Reporting Tools for Secure Web Service Application with MS-SQL server

    Hi... We are a Cdn Govt agency involved in Satellite Operations with a commercial partner based across the country. We will need to build/buy a small web service application for reporting purposes that will require minimal IT experise to build or maintain. The back end RDBMS engine is built with MS...

    Mmosystem0 pointsBadges:
  • Improve MS Access performance on a Win 2k LAN

    We have recently replaced our old DataEase database with a package that was built using MS Access, and the system has slowed away down to an unbearable speed. However we are stuck with it now, and I would like to know if there is anything that we can do to improve the performance of the database....

    Harg77690 pointsBadges:
  • Access 2003 Options Group

    Most of my work is with VB and I always use option buttons within a frame. I'm trying to do the same thing in Access 2003 and I get an error message: You entered an expression that has no value. For simplicity this is what I'm doing: If Me.Option3.Value = 1 Then Msg = "A" ElseIf Me.Option5.Value =...

    TonyTempio0 pointsBadges:
  • F22 key on AS/400

    Hello everyone, we have a couple of acountants onsite at a clients, and they are using an AS/400, they need to know how to access the F22 key, is this depending on the emulator they are using? or is there a way to access it?

    Natethegreat0 pointsBadges:
  • Oracle 8i/9i Database Access

    In the past, many privileges were granted to the PUBLIC pseudo-role in a couple of our databases with a large number of users. We created a role named XPUBLIC and moved all of the privileges to it and are now attempting to limit users to privileges they actually need. Does anyone know of a way to...

    Stevewaltz0 pointsBadges:
  • Authorization in MIGO

    I would like to grant a user authorization to object S_TCODE MIGO (Goods Receipt specifically for Purchase Order (movement type 101) where they could then enter any related data but restrict their activity to HOLD. A subsequent user would have the authorization to POST the document. I have checked...

    CoCamo0 pointsBadges:
  • Oracle DataBase Connectivity

    Hi, Gurus, I am a Oracle Db Administrator managing about 5 Gb DB on windows NT. There are approx 100 user connecting concurently from clients on Win 9x,XP And Win NT Ws. Last Day What happened one Xp Client Hung causing all to hung. The client machine was hard booted. After that any one trying to...

    Kanhaiyababu20020 pointsBadges:
  • IBM DB2 load restart

    I am faced with a situation where my SYSREC file for a LOAD could potentially have duplicates. If there are dupes then I have a step that follows that analyses the SYSDISC file,so my DISCARDS is set to 0. If for whatever reason the utility blows up (ran out of space, whatever) and I choose to...

    Sumithar0 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