I’m trying to forward events from SQL Server 2005 SP3 to a different server, but the only server I can select is the local server. What must I do to see other servers in the Event Forwarding Server drop-down box?
Answer Question | November 1, 2010 4:03 PM
SQL, SQL Server 2005, SQL Server 2005 SP3, SQL Server Agent
OK. So, JAVA is said to be platform independent since it generates Bytecode on compilation. There is a JVM for each platform which avoids the need for having a JAVA compiler for each platform. Does that not indicate that the effort saved in writing Java compilers for each platform was spent in writing JVMs for each platform?
Answer Question | November 3, 2010 3:01 PM
Compilers, Java, JAVA jvm, JVM
* I have over 1000 records in a table (Context_Tasks_DB), one field of which (termed Purpose) should really be a Lookup to another table (tblPurpose), but currently simply has text (only 30 unique text values are in that field and are therefore repeated…). * I have created a table called tblPurpose with the [...]
Answer Question | November 5, 2010 10:54 PM
Access, SQL, SQL Database, SQL Query, SQL Records, SQL Server Flat File Input
Hello I have several sites connected via a MPLS network for MS Exchange and other shared resources. Currently we have an Internet connection going into one site and making HTTP/HTTPS traffic accessable to the other sites over the MPLS network. We would like to use a secondary Internet connection (Cable for example) and a firewall get the HTTP [...]
Answer Question | November 1, 2010 10:32 PM
Exchange, Firewalls, HTTP, HTTPS, Traffic management
We have a text file that is a result of an export from an application we have. We use the following bat file to rename and remove blank lines from it based on the way it exports the export options/format cannot be changed. I would like a way to add to this bat file a [...]
Answer Question | November 9, 2010 5:07 PM
Batch file, Batch job, SQL, Text manipulation, VBS, Visual Basic Script, Windows Server 2003 Standard Edition
Hi, I have two spreadsheets that I import in to MS Access to compare. To get a comparable Unique Identified, I concatenate the data in three columns to one unique reference. I then want to find the total balance for each identifier, which normally have around 8 entries each and then compare it against the [...]
Answer Question | October 29, 2010 2:05 AM
Access, compare reconciliation balance unique identifier, Concatenate, excel
I am writing a batch file that will be run from a DVD to copy some necessary files to a location specified by the user. I have used switches to get Yes or No input in the past. How do I get a drive location from the user and then verify that on the current [...]
Answer Question | November 1, 2010 5:29 PM
Batch, Batch files, DOS, Scripting languages, Windows 7, Windows Batch Files
We have SQL SERVER 2005 SP3 Enterprise 32-bit running on a windows server 2003 Enterprise 32-bit with 32GB of RAM and 8 dual core processors. Our CPU, RAM, and I/O are always through the roof and the application is always running slow. We use AWE for buffer cache the maximum memory is 28GB, the PAGEIOLATCH_SH [...]
Answer Question | January 31, 2011 3:27 AM
SQL, SQL performance, SQL Server, SQL Server 2005, SQL Server 2005 SP3, SQL Server Enterprise Edition
How do you deal with crunch time during testing?
Answer Question | March 14, 2011 12:14 AM
Quality assurance, Software testing, Software testing methodologies, Testing
Have you used TFS Test management tool or attended any seminar or training for it? Is your organization planning to move to TFS?
Answer Question | October 27, 2010 7:15 PM
Functional testing, Quality assurance, TFS, TFS 2010
I’m doing a database for our transportation company. How can I set up multiple expenses for multiple vehicles? How can I set up a form for data to be entered by choosing a vehicle, a month during the year, and multiple expenses on a single form?
Answer Question | November 19, 2010 6:24 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access 2007 functions, Access forms, Forms Creation, Windows XP
Is it possible to write out each record from a recordset destination in SSIS as an XML field into SQL Server? How can this be done in either case?
Answer Question | October 27, 2010 3:19 PM
Recordset Destination, SQL Server, SQL Server Dataset, SSIS, XML
Amazon Web Services will start its one-year trial subscription on November 1st, and we’re wondering who’s going to give it a try. If not AWS, what services have you adopted by first giving them a trial run that you might otherwise have not gotten off the fence about?
Answer Question | November 3, 2010 3:09 PM
Amazon Web services, AWS, Open IT Forum, Trial period software
We have a database in production that is 500GB, what are the pros and cons for setting the ”Page Verify” option to ”NONE” on the database for best performance? How will ”TORN_PAGE_DETECTION” and “CHECKSUM” affect performance?
Answer Question | October 28, 2010 3:08 PM
SQL, SQL Database, SQL Server, SQL Server 2005, SQL Server 2005 Database
i am student of doeacc society i want a job in it and i am complete my java development and i have done scjp exam how to improve my resume
Answer Question | March 6, 2012 2:53 PM
IT careers, Java developers, Java development, Java/J2EE
I’m looking to put together a server to run ESXi v4.1. I’ve selected the following hardware components and would appreciate any advice/input good/bad: Case: Athena Power CA-SWH02BH7 Mobo: TYAN S8230GM4NR-DL PSU: Athena Power AP-P4ATXK110FEP CPU: AMD Opteron 6134 Magny-Cours 2.3GHz 64gig RAM: Kingston 8GB KVR1333D3E9SK2/8G x 8 2 500gig drives – RAID1: This partition will [...]
Answer Question | October 27, 2010 1:18 PM
ESXi, SQL Server, Virtual Machines, VMware ESXi, Web servers, Windows Server 2008
I’ve a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i’m subtracting 7 from today’s date (1101027 – 7), i got 1101020. If i subtract 40 means i got 1100987. Can [...]
Answer Question | November 1, 2010 6:30 AM
AS/400 Function Logic, AS/400 Query, MAX
All of our ~150 remote offices use a generic mailbox in addition to the local staff mailboxes. Due to a conflict with our new single sign-on product, the site staff are unable to access the generic mailbox. So we are creating a dedicated dynamic distribution list for each office, and the generic mail will be [...]
Answer Question | October 27, 2010 9:32 PM
Automation, DDL, Dynamic Distribution Groups, Exchange 2003, Exchange 2003 SP2
I’m doing a database for our transportation company. I need help with setting up expenses for multiple vehicles. We want to be able to enter for reporting monthly gas, repairs, license, etc.. Want to be able to enter 50 gas receipts for one vehicle a few times a month. Reports will be monthly with a [...]
Answer Question | October 27, 2010 9:17 PM
Access 2007, Access 2007 form creation, Access 2007 forms, Access Database Design, Windows XP
I am looking for training material that will help me in configuring a CISCO 3560 switch to be used for machine controllers. What I have is multiple PLC’s on ethernet-IP. I need to be able to connect to each one and they are on different subnets. Any suggestions will be greatly appreciated.
Answer Question | November 17, 2010 7:57 PM
Cisco 3560, ControlLogix, Ethernet, Ethernet connection, Ethernet-IP, PLC, Rockwell Automation