• Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE54,695 pointsBadges:
  • Oracle forms runtime fmx is not able to connect to database

    Hi, I installed forms and reports 6i on my system. I could able to connect to data using forms builder and developed form.When trying to open fmx file, its asking for logn credentials and when i give credentials its giving me ora-12222 error.Pls help me out in this.

    skchiv715 pointsBadges:
  • SQL Server 2012 CONCAT producing strange characters.

    Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...

    ITKE54,695 pointsBadges:
  • Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE54,695 pointsBadges:
  • Remote Call issues in SQL Server 2008 R2

    I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...

    ITKE54,695 pointsBadges:
  • Call pilot

    How many remote notifications can a user have?

    HubeHube20 pointsBadges:
  • Synchronization

    How can I unlock my inbox. I currently have three emails in my inbox (sent them from an old Android phone, but I have a new Samsung) and cannot access?

    mitchtheluddite5 pointsBadges:
  • Scanning Active Directory for weak passwords

    Is it possible to scan our active directory and see if people have weak passwords? We have upped the password policy but what about for users that already have passwords and are not scheduled to changed them yet?

    Troubleshooter24755 pointsBadges:
  • Controlling VPN access

    Here's my scenario. I fall under guidelines of HIPAA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...

    Gforsythe75 pointsBadges:
  • 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?

    ITKE54,695 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...

    ITKE54,695 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

    mvrkrishna525 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,300 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.

    ITKE54,695 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:

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