Questions & Answers

  • Cisco VPN Issue

    Cisco VPN worked great for several months and now will not establish connection. Info below. What's going on?Cisco Systems VPN Client Version 5.0.07.0440Copyright (C) 1998-2010 Cisco Systems, Inc. All Rights Reserved.Client Type(s): Windows, WinNTRunning on: 6.1.7601 Service Pack 1336 16:47:20.996...

    BroncoKrawler5 pointsBadges:
  • Store and date times in SQL Server 2008

    Which is the proper way to store and date times in SQL Server 2008?datetimedatetime2I know the majority of differences between the two but should we just use datetime2 only?

    ITKE351,905 pointsBadges:
  • Citrix Client Function Key Issues.

    Hi, I am acessing AS400 through Cirtix client. I am facing function key issues. For me some of the function keys are working well, but few are not working. Ex: F13, F15, and F24. If I hit F15, it asks me to disconnect the session. For F13, its showing me the windows Start menu. I have checked the...

    Razuk30 pointsBadges:
  • How to remotely search emails on Bold 5

    I have email active on my phone but cant remotely search for old emails from my phone, because there is no option for it. I have compared the results with some other BB phones, but they all have option to either search the handheld/remotely. please help out.

    Tonny5 pointsBadges:
  • How to create a table variable in SQL Server 2008 R2?

    How can I create a table variable (virtual in-memory table) with columns that match the stored procedure resultset? I tried to execute the procedure using column names I specified. Does the data type of the columns need to be the same as the stored procedure? Here is what I tried:DECLARE @Table...

    ITKE351,905 pointsBadges:
  • Copy a file of 20 million records to another file.

    Hi Group,I need a copy data from a file having 20 million records to another file. What could be best way to achieve this? One way is creating a duplicate object. Is there any other method?Regards,M

    mvrkrishna555 pointsBadges:
  • Single Page Subfile

    Hi.. I need to create a window subfile in RPGLE, and the subfile field values should be taken from the array which is defined in program itself. Can anybody give me the sample code for this? Surey

    Sureyz2,475 pointsBadges:
  • How to clone a table in SQL Server Express 2012?

    I’ve built a SQL Server table with several columns with an index starting from 1 as the primary key. I need to clone this table but without the data and with a different index starting from 100. I don’t know how to do this. I am using SQL Server 2012 Express that came with Visual Studio 2012.

    ITKE351,905 pointsBadges:
  • Database all about RAID introduction including annotated diagrams

    Can someone help me with this question: RAID Levels, Hardware issues,choice of RAID level and improvement in performance via parallelism

    cos5 pointsBadges:
  • Undefined report

    Why would an undefine report attached itself to the bottom of a report that is defined?

    CAADMIN5 pointsBadges:
  • Mount Windows Partition in Ubuntu

    I installed Ubuntu onto a WinXPP machine so that they are duo boot. The system should have automatically mounted my windows directory and created an icon on the desktop. It did not. I followed the directions and opened a bash shell and typed sudo vol_id -u /dev/sda1 Ubuntu returns the error command...

    Hsmithdp125 pointsBadges:
  • San Mount Volume Changed HELP!!!

    I run a system comprised of 36 IBM Blade servers, a Hitachi 64TB SAN, a Data Domain backup suite and connection devices. I run Windows 2003 R2 (32bit) and Red Hat 4 (64bit). I have just come across a problem in that all the windows blades in one (of three) chassis are displaying my drive E: (which...

    GMB8635 pointsBadges:
  • Creating a trigger in SQL Server 2008 R2

    I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...

    ITKE351,905 pointsBadges:
  • Best way to manage tables in SQL Server 2012?

    I have a table that captures about 100,000 records per day. As you can imagine, the size and performance of such a table would degrade as it quickly went well over 50 million records. I want to try something different, and that is the creation of a new table every day, so that the number of records...

    ITKE351,905 pointsBadges:
  • Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE351,905 pointsBadges:
  • Using bulk delete on SQL Server 2008

    Looking for a way to "Bulk delete" in SQL Server 2008. Since I want to use WHERE for limiting the rows in action, I know I can't use TRUNCATE. Should I use something like "batch deletes" or "bulk copy"?

    ITKE351,905 pointsBadges:
  • Rolling back updates in SQL Server 2014

    Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions? I’m referring to committed commands – I know you can rollback if query is inside transaction. We have full, differential and transaction log backups in place but we’d...

    ITKE351,905 pointsBadges:
  • Windows 7 is very slow to start from hibernation

    For the past few weeks, my Windows 7 64-bit ultimate machine has been extremely slow to restore from hibernation. It spends several minutes on a blank screen with a blinking cursor. After it starts, it takes forever to get any of my programs to load. I've tried to the following things to speed it...

    ITKE351,905 pointsBadges:
  • Merging columns in SQL Server database

    Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...

    ITKE351,905 pointsBadges:
  • Migrating from an AS/400

    What should I bring up to someone when I am trying to get them to migrate from an AS/400? What are the pros and cons of migrating from the AS/400?

    Cgoodin20 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