Search results for query: *

Hello I would like to update the column in one table based on the results of a query from another table. I have two tables IM_ITEM and IM_INV tables. In the IM_INV table I would like to sum up the location quantities for each item. If the quantity is zero, I would like to set the...

Hello I have a problem with a MS SQL Server 2005 SQL database. If I run the command DBCC CHECKDB(BHT, REPAIR_REBUILD) I get the following result: Msg 1505, Level 16, State 1, Line 1 The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name...

Hello We have a Windows Server 2008 R2 that is NOT able to open a share on a NAS using its NETBIOS name. However it CAN open it using the IP address. The NAS and the Windows Server 2008 are both joined to a Windows 2008 domain. There are other computers on the network that are part of the...

Hello I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect. I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...

Hello I use to be able to connect via Windows VPN to my Windows 2003 Server but something has happened and I can no longer connect. I am trying to make a VPN connection from a Windows XP Pro client on the local LAN (to take our firewall out of the picture) but I keep getting the error...

Hi, Is there a way to modify the manufacturer friendly name for an external USB Seagate Freeagent Go drive? The reason we need to do this is that we are using VMware workstation which requires you to disconnect the external usb drives from the menu when removing them from the guest OS...

Hi, I am trying to increase the performance of a Crystal Report that uses ODBC to connect to a Pervasive.SQL database. Is it possible to use SQL Expression Fields in this scenario? I am trying to find some documentation on if this is possible and how it is done but can not find anything...

Hello I am using ARCserve Backup r12.5 SP1 (Build 5860). When I backup the system state on a domain controller, I will get an incomplete result. The errors I get are as follows: W3301 2010-10-02 17:42:16 Unable to find directory. (DIR=C:\Documents and Settings\<username>, EC=The system...

Hello I am having problems with a Windows 2000 server in a Windows 2003 Domain. Initially, it started where the Windows 2000 server could not access any network shares on the Windows 2003 Domain controller. It would keep prompting for a username an password when the share was accessed...

Hi I would like to update the column of one table with the last calculated value of two columns from another table. The tables are defined as follows: Table #1: IM_ITEM ----------------- ITEM_NO VARCHAR(20) LSTFACTOR DECIMAL(15,4) Table #2: PO_RECVR_HIST_LIN ---------------------------...

Hi I would like to update the column of one table with an aggregate value (avg) from another table but I keep getting an error. I run the following statements: CREATE TABLE [dbo].[IM_ITEM] ( [ITEM_NO] VARCHAR(20), [AVGFACTOR] DECIMAL(15,4) ) CREATE TABLE...

Hello Is it possible have a crystal report print a note on a new page after the last page of the regular report? For example, let us say we have a disclaimer with company logo in a pdf or word document, we would like to have that disclaimer attached to the end of the last page of the report...

Hello We have a MS SQL Server database in which we need to change the value of a field. Unfortunately the columns in which that field exist are used to create a relationship between the two tables. Table -> IM_SER_ACTIV ITEM_NO SER_NO ACTIV_TYP DAT ------- ------------...

Hello We have a problem where we can not account for what is using up all the disk space on a disk volume. The disk has a physical capacity of 136.48 GB and is split into the following 3 volumes: 31 MB (Hidden) 11.13 GB (C: drive, System) 125.32 GB (D: Drive) The D: volume is...

Hello We are running IE version 8.0.6001.18702 on Windows XP Pro SP3. Whenever we print we always need to set the page orientation from landscape to portrait. We even try to set the default orientation to portrait under File / Page Setup. However, if we exit IE8 and then re-enter or select...

Hello, We have Pervasive.SQL 8.6 installed on a Windows Server which is part of a Windows domain. The domain administrator is able to use the Pervasive.SQL Monitor Utility from any client pc on the network to view active Pervasive.SQl users. The domain administrator simply needs connect to...

Hello We have a Nortel CICS system. When a particular incoming line is dialed one particular extenion rings. All the other extensions are silent but get a a flashing light. Can anyone tell us where we can find that configuration setting? How can we configure a particular incoming line to...

Hello Over the weekend we migrated from an old server running SCO OpenServer 5.0.7 to a new server running the same SCO OpenServer 5.0.7. Since then we have been having problems with remote printing. The print jobs do not print and they remain in the queue. We have several printers set up...

Hello We recently installed SCO OpenServer 5.0.7. However, we have no access to remote network printers (printers connected to print servers). When we run "mkev lp", go to the "System" tab and then select "Print Services", we see two choices: "Local Print Service Enabled" "(Remote UNIX Print...

Hello We are programing in Delphi 2006 using a MSSQL database. We are having a problem updating two tables which have a relationship between them. The database and tables are defined as follows: Database: FDD Table: OPN_ITM_CHANGES Field Type ---------- ------------- ------------...