• Database Admin.

    I'm currently in my 6th qutr. at ITT tech studying cns i'm interested in database admin. what skills or cert. will I need to get an entry level job? Where can I obtain such skills?

    Morpheus960 pointsBadges:
  • Importing Data in SQL Server 2000. “Integrity violation error” in RowID column

    Hi All, I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure. I am trying to import data from a text file through the Import Data Wizard in the...

    Kpatel0 pointsBadges:
  • Exchange 2000 issues

    I seem to have 2 issues. Both are on the same setup. Windows 2000 Server running Exchange 2000. Both have all the latest patches and SP's. 1) Mail will flow inbound just fine. Some mail will flow outbound just fine. Certian addy's just have in the SMTP queue ( AOL,Yahoo, Bellsouth ). Other mail...

    Aclark950 pointsBadges:
  • sqlserver 2000 stored procedures

    Hi , i have the unfortunate task of time to integrate microsoft sql server 2000 stored procedures to mysql so that our software will work. Can anybody tell me if this can be done, if so how easy is it and how do i go about it? Thanks for your help andy

    Andy119830 pointsBadges:
  • REPORT WAIT TIMES

    We have a commercial accounting software package programmed in Access. Recently began having to wait for some reports to process to the screen for over 3 minutes. We have only had this software for under a year and have eliminated the problem being the network by moving the data files from the...

    Jmoeller0 pointsBadges:
  • Help with VBA Code for retrieving data from a table in an MS Access Database

    Hi, I'm new around here. I'm a student in the programming field. I have a question for those of you with experience with VBA, VB, or SQL coding languages. Basicly what I'm looking to do with my database is have it fill in the remaining related fields in a form when the Primary key field is selected...

    Suprababe0 pointsBadges:
  • Security Forensics with Niksun or CA or Sandstorm

    Does any have experience recording and tracking traffic with playback using any of these venders. I am looking for the best solution to provide Forensics on my network. Niksun or CA or Sandstorm Also on a side not I am lookign for a product to do secure email delivery. Please let me know if anyone...

    Jclarkfl0 pointsBadges:
  • Oracle ./runInstaller problem

    Dear Oracle Experts, I came across the following problem when trying to update my Oracle 9.2 to Oracle 9.2.0.4 When I typed > ./runInstaller for the Oracle 9.2.0.4 patch. I get the following error. "You do not have permission to write to the inventory /oracle/product/db/920/$ORACLE_HOME....

    Asiankiwi0 pointsBadges:
  • Exporting Data to Text/CSV file in SQL Server 6.5

    Hi, I would like to know how do we Export Data to Text/CSV file in SQL Server 6.5 Do we have something similar to DTS in SQL Server 2000? Thanks, Kruti

    Kpatel0 pointsBadges:
  • Accessing Linked Server in SQL Server 2000 (Urgent)

    I have a server named say 'SRVMAIN'. Using Enterprise Manager I added a linked server 'LNKDSRVR1' (existing server). I m able to access any database in 'LNKDSRVR1' by writing a query in query analyzer of 'SRVMAIN' as SELECT * FROM LNKDSRVR1.TESTDB.DBO.TESTTABLE Now if I have server as...

    Bakash0 pointsBadges:
  • SQL Server equivalent of Oracle’s desc tablename command

    Thank you all for the response to my previous query. What is the T-SQL equivalent of Oracle's desc command? I mean, what is the command in T-SQL to see the structure of a particular table? And what do we do in T-SQL if we want to see list of all the tables in a particular database?

    Kpatel0 pointsBadges:
  • 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:

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