• 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:
  • can strqmqry be run as remote command

    I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...

    Bdatadigger0 pointsBadges:

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 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 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:
  • Document scanning and organizing

    Does anyone know of an open source/cheap document management system? (Windows-based system) I would like the ability to have a searchable database of scanned documents/photos/receipts/etc. I do not need OCR. For example, a folder name "Job1" that I can click on and see subfolders of...

    Skepticals0 pointsBadges:
  • career advise

    I am a fresh graduate in petroleum engineering and wish to purse a course in sap; I have no experience in IT order than basic computer knowledge. I want a sap course that is related to my field (petroleum Eng) and also make me a consultant. I was looking at MM in sap until recently I met a friend...

    Haller80 pointsBadges:
  • Data migration strategies-2

    Hi All I am embarking on a Data Migration project which involves migrating data from one I-Series database application to a different I-series database application. I guess as with all migrations the data does not excatly match in both appplications. I have identified that i need to populate Excel...

    Hazermark0 pointsBadges:
  • SECURE FTP SITE ON Windows 2003

    We have a Windows 2003 IIS server setup behind our firewarll which is a PIX firewall. What is the best method to establish a secure FTP site on this IIS server? I have reviewed this topic on the internet and actually talked with somebody from IPSWITCH and the best method available is to purchase a...

    Mconfer0 pointsBadges:
  • Data Warehouse – ‘thin layer’ or snapshots?

    We are re-designing a data warehouse and need to decide whether we create a solution that is snapshot based (i.e. a full copy of every customer and their attributes each month) or one that is more transaction based (i.e. a full copy of all customers, then every time their attributes change, we put...

    Szppt80 pointsBadges:
  • terminal server and gpo

    i have a server 2003 that configure as a terminal server, and i want implement a strict acess to this server from client (xp pro) to that server, i create ou that called "for terminal users" and create for that ou a gpo, now,, i want to know how should i change the gpo to achive the next goals: 1....

    Drorbeny0 pointsBadges:
  • Cannot copy from CD…

    Does anyone have insight into why when I upgraded the hard drive and restored a system, all the restore CDs work except for the MS Works application. I thought maybe the CD was damaged but I was able to copy the data to a different system. So, I bought a copy of MS Office 2003 and that CD doesn't...

    DboiSOBE0 pointsBadges:

    I recognize 3 areas of interest to my customer: * Dealership Customers (aka Clients). People who bring their cars to dealerships. * Dealership Employees. Service Advisors who make service recommendations. * CompanyX Employees. Account Mgrs who sell the Product to the Dealerships. 1 approach is to...

    Mxande80 pointsBadges:
  • Running a script at specified runtime

    I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime? Thanks

    Columbus0 pointsBadges:

    Hi All, Am facing a problem on Totalling on Business Objects OLAPI. Automatic totals? is the ability to add a total to the rows or to the columns of your report. Additionally when drilling down, OLAPI keeps the parent in the column of information. This results in double counting because automatic...

    Pvkk010 pointsBadges:
  • SQL Server Integration Services – Pivot Transformation

    I'm trying to transform; fld1 fld2 fld3 fld4 value A B C 2 100 A B C 3 250 A B C 4 400 to; fld1 fld2 fld3 feb mar apr A B C 100 250 400 but I'm getting; fld1 fld2 fld3 feb mar apr A B C 100 NULL NULL A B C NULL 250 NULL A B C NULL NULL 400 What am I doing wrong?

    Tuckerg0 pointsBadges:
  • Problem calculating something in Excel

    The production goal for a quarter is 1.474 now if they meet that goal they get 100% of the bonus but if their number is 1.54844 then they get 180% of the bonus and if their number is 1.43036 they only get 50% of the bonus. so if their number is 1.52 they should get approx. 170 % of the bonus....

    Imazing0 pointsBadges:
  • Can’t login as Administrator

    Hello Everybody, I can't login to adminstrator profile in my standalone win 2000 adv server. I use this system for my study purposes. What happened actually is when I was shuting my system, it got powered off because of some UPS problem and the next time when I logged in using Administrator, it...

    BinooDas123410 pointsBadges:
  • problem with sound card please help me

    Hi, I have a problem with my soud card, it doest work after I formated the hard drive and made a clean installation, when I check in my device manager it appears with a little sign and I try to re-install the drivers but it says... An error has occurred during the installation of the device The...

    4157560 pointsBadges:
  • Unable to detect a parity error with Windows SDK on a PCI serial card

    We are using a 9-bit protocol which sometimes sends a mark state and sometimes sends a space stage. When a space state is sent we want to be able to get a parity error in SDK. We can see the parity error in the hardware register but we want to be able to see the error with Windows SDK software....

    Kfink040 pointsBadges:
  • Database BackUp

    Hi e'rybody! I have recently started my new task as a Database Administrator in SQL 2000 after attending a week course DB administration. Well, we have our back ups running through the DB Maintanance and have noticed that some back ups increase too quick in size and as a result an average database...

    DibyDineo0 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.