• SQL To Excel Data Dumping with the help of SSIS flow task.

    I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode...

    Ssis5 pointsBadges:
  • Large number rounding in Oracle 10g

    Oracle 10g database table with a column having data type Number(20) stores 18 digits organization code.  When this data is retrieved in SQL*Plus or Toad it is displayed in scientific notation format. The display format can be changed from scientific notation format to number format. But, for some...

    Techguys90 pointsBadges:
  • Crystal Reports to SSRS

    There is a proposal to migrate existing CR(11) application to SSRS for speed of execution as well as more flexibilty. WE have JPEG2000 images in the database and these are neither getting rendered in Crystal Reports nor in SSRS. Any suggestions on how I can make these JPEG2000 images render in the...

    Mbdaniel5 pointsBadges:
  • iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,830 pointsBadges:
  • Best way to back up SQL Server 2008 database?

    What's the best way to back up my SQL Server 2008 database? We are currently backing up the SQL data files during off hours but soon we'll be going 24/7 and we'll need to use maintenance plans and shadow copy. Can someone provide help?

    ITKE363,905 pointsBadges:
  • Migrating Access Tables in MYSQL Server using MYSQL Server Enterprise Manager

    Can someone please help me in migrating my tables form Access to MYSQL Server Enterprise Manager

    Anco5 pointsBadges:
  • Migrating from Microsoft applications to Oracle

    How can I easily convert my SQL 2005 databases to Oracle's latest iteration? We are moving away from Microsoft applications and want to migrate to Oracle. What do I need to do to prepare?

    ITKE363,905 pointsBadges:
  • moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster.

    I have been tasked with moving an existing active/passive 2005 SQL cluster onto an existing active/active SQL 2008 cluster. The active/active 2008 SQL cluster consists of two nodes that are running Windows Server 2008 Enterprise edition. These nodes connect to an EMC SAN which has been operating...

    MikeDCCA5 pointsBadges:
  • Connecting to the SQL- SERVER from VS-2008 C#

    How can I connect to the SQL SERVER from the VS-08 C# and how can I insert, modify and view the database in SQL SERVER.

    Rajeshu135 pointsBadges:
  • How do I restore my SQL .bak file over the existing database?

    How do I restore my SQL .bak file over the existing database? Do I need to delete what is there already? On a new Windows installation I need to restore our production SQL database from a .bak file. What steps do I need to take? Can I overwrite data or do I need to restore to a fresh database?

    ITKE363,905 pointsBadges:
  • SQL Server 2008 Code to find fields containing similar text

    I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word "Smith" Field 2 has "Smith AB" in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 Thanking you in advance

    Davewaltonuk20 pointsBadges:
  • Sponsor Post: Join Us for the Identity Access Management Live Expert Chat on 7/20 at 11am ET

    To compete in the new economy, organizations need to provide efficient and secure access to their internal applications and data for external entities, such as business partners, customers, and mobile employees. Join Microsoft's Senior Technical Product Manager, Brjann Brekkan, on July 20 from...

    ITKE363,905 pointsBadges:
  • Web based application not uploaded ON SERVER sometimes

    We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update...

    SJFIL5 pointsBadges:
  • SQL server SP3

    Security Update for SQL Server 2005 Service Pack 3 (KB970892) .. i cant get this update to work on my comp..soemthing about hotfix.exe error

    Jimk5 pointsBadges:
  • How do I use DateDiff in cobol using SELECT statement?

    how to use DateDiff in cobol using SELECT satement.

    Ije35 pointsBadges:
  • Join for merging records

    I'm trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep those records that were matched...

    Eabouzeid175 pointsBadges:
  • Sponsor Post: Secure End Point Live Expert Chat – Tomorrow @ 11am ET

    Join this expert chat tomorrow, July 13th from 11am-2pm ET, to learn how Microsoft Forefront solutions protect client and server operating systems from emerging threats and information loss, while enabling more secure access from virtually anywhere. Click here for reminder email to access the...

    ITKE363,905 pointsBadges:
  • Sponsor Post: Cloud Migration Pros and Cons Live Chat Today

    Today's live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data...

    EmNichs3,250 pointsBadges:
  • Mounting Tape on Tape Drive using BRMS

    Hi, We have BRMS installed on AS400 V5R4.The Backup and Restore are done manually.Once the tapes are ordered the operator puts it in the tape library.Can anyone please let me know how I mount the tape on the tape drive remotely. As an example,I am pasting below the 'Work with media Library Media '...

    Hugheswilliams345 pointsBadges:
  • Sponsor Post: Join Us for Endpoint Security and Identity Access Management Live Chats with Microsoft

    Today’s workforce faces a constantly evolving landscape of threats to information and infrastructure—even regulatory compliance. Endpoints are exposed to attacks both inside and outside the corporate firewall, resulting in lost productivity and real financial losses worldwide.  Join us this...

    EmNichs3,250 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