• 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:
  • Windows OS Paging

    Generally if an operation in memory takes 1 second it will take approximately 1 month if it requires a page fault. I have a server with 8 GB physical RAM and 18 GB total with page file. My high water mark since the system booted is 2.948 GB. Windows 2003 Server Enterprise edition. Currently the...

    HelpingSpirit0 pointsBadges:
  • Two Domains in one Windows Server

    Hi, Can I configure two domains in one windows server

    1441440 pointsBadges:
  • Windows 2000 Server

    I get the following error on my Domain Server. Its used as a Frontend for our ERP and Common folder for users (around 130) in our Domain. Its a PIII 1 Ghz with Dual Processor with RAID 5. Searched the Net for the solution there is a solution of increasing MaxWorkItems in the Registry to 8192 (but...

    Mail2divyesh0 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:
  • Opinions about firewalls and VPN

    I currently have watchguard firewalls and IPSec tunnels between them and the other watchguard firewalls. We also have remote users VPN into the firewall for access to our network. Our firewalls are fine but we haven't been that happy with the support over the last 5 or so years. We are joining...

    Kevins740 pointsBadges:
  • Recommendations for OU and group policy design

    Hi, We are currently running a Win2003 AD and have been for some time. As is the usual with this sort of thing, the OU and Group Policy structure has evolved over time and it's currently in a bit of a mess. I'd like to get some input on how best to re-design the OU and GPO structure. Any ideas are...

    GregNottage0 pointsBadges:
  • AD Integration and NetBIOS/WINS

    Hello. My question has two parts. First, the company I work for just merged with another company and we have now set up a trust between the two domains, ABC and XYZ, I will call them for illustration. The domains are connected via a T1 with Cisco routers on each end. The trust was set up as...

    Brosley0 pointsBadges:
  • Ways to handle Very Large Table

    Hi, I was trying to create a cumulative total table for our company (advertising). This table contains cumulative totals for impressions, clicks, etc. From 7/1/05 to 2/31/06, this cumulative total table already has over 22 million records (the growth rate is very high, it can be over 200K records...

    Yfellow0 pointsBadges:
  • Select single row

    Hi, I have a sql server table which has fields like this productNO, Description, loc_quantity. one product can have multiple locations . Location has multiple columns for different location codes. Like Location_qty_11, Location_qty_40 like that. The table gets populated from other tables which puts...

    Gullu15 pointsBadges:
  • Using Secure Shell (ssh)

    I have to submit a remote command from the AS/400 to run on a UNIX system. I am told by security admin. that I can only use Secure Shell(ssh). Both the AS/400 and the UNIX server are within the firewall. I do not know where to start. Does OS/400 V5R3 have this capability? Do I need additional...

    Ashnirody100 pointsBadges:
  • SQL Server and IIS Hardware Specification

    I have a two-tier client server application that consists of ASP for the front end and SQL Server 2000 backend database. This application does not contain any middle tier components and needs to support 40 users and scale up to a maximum of 80 users. What hardware specification would be appropriate...

    Airtight0 pointsBadges:
  • Folder / File Compare Utility

    Hello All: I am currently looking for a compare utility that will perform the following tasks (at a minimum): 1. Compare folder (sub-folder) strings from a specified stating point. For example one string starts at C:User Data and the second string begins a D:BackupUser Data. The utility should...

    Rjournitz5740 pointsBadges:
  • Move SQL Server to a new machine

    I am moving our SQL Server databases to a new machine. The old OS is Windows 2000 and the new is Windows Server 2003. The version of SQL Server is staying the same and the data folder structure will be the same. My question is: Would it work to install SQL Server on the new machine, stop the...

    Randym1,740 pointsBadges:
  • Conference rooms in Exchange & Outlook

    I am looking for the best way to handle conference rooms within Exchange and Outlook to make them easy to schedule, update, and access. I have Exchange 2003 on a Windows 2003 Server and I have 9 conference/meeting rooms. Right now I have a calendar setup for each one and the person has to go in and...

    Kevins740 pointsBadges:
  • Printserver Solution

    Hi There, I have 2 sites seperated over WAN and Firewalls which require to communicate vice-versa for printing. There are several printers located in each site so was wondering for a solution wherein 2 printservers at either location talk to each other through the firewall and do the needful for...

    Raghuram0 pointsBadges:
  • Migrating from Exchange 5.5 to Exchange 2003

    Good Morning All! I need some help on "How to Migrate" an Exchange 5.5 server running on NT4 to a new computer running 2003 server and Exchange 2003. This only a one Domain network and it is running AD on a Windows 2000 network. If someone and can tell me all the steps neccessary to have a...

    Sdr071515 pointsBadges:
  • SQL Server 2005

    I just installed SQL Server 2005 (Standard Edition) on a Windows Server 2003. I still have SQL Srever 2000 and I used the export utility to copy a database from one of my SQL 2000 server to my new SQL 2005 server. Everything copied over and tables were created. The database is there for me to see...

    Trevione0 pointsBadges:
  • SBS2000 and Exchange

    I have an SBS2000 server which I am trying to replace with a new SBS2003 Server. Due to certain issues I tried to upgrade the 2000 box to SBS2003 but this would not complete due to not being able to locate all Domain Controllers. Whilst I believe this to be an error, it has resulted in a problem...

    Cairnsitc0 pointsBadges:
  • Windows 2003 Server Disconnected Network Drive

    I am moving a working application to Win 2003 Server, from XP Pro. The Task is started from a remote server to the Win 2003 Server. It starts a job which tries to access a network drive. This network drive is connected prior to the job starting, and yet as soon as job starts it goes to...

    ManxAnts0 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