• Migrating DTS packages that use mainframes source to SSIS

    I am trying to migrate DTS 2005 packages to SSIS. The packages that has SQL data source is migrating around 60% but the packages having mainframes (AS400/DB2) data source is migrating only 10% what is the reason? and How to get this problem resolved?

    Jwalini5 pointsBadges:
  • Multithreading T_SQL

    I have to pool data from 1000+ sites on different physical servers through a web service running on each server. What is the best way to do so using T-SQL so that the multiple threads/processes run in parallel

    Rajeevraina5 pointsBadges:
  • Permission to Export SQL Server 2005

    On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?

    VelameLaCosa110 pointsBadges:
  • SQL 2005 transaction logs

    At what point should we truncate the transaction log

    Hydrostani20 pointsBadges:
  • Oracle 10g versus Microsoft SQL Server 2008

    Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

    Akansha150 pointsBadges:
  • Retrieving data tables without backup SQL

    If I truncate a table without the backup of it, how do I retrieve the table data?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server user name issue

    We have a server in which Windows 2003 is installed and we have created users in the domain (e.g. - aaa). The server is installed with SQL Server 2000 and data is stored in the database. The user name for the server is “administrator.” When we login from the user computer with the same name and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Creating a stored procedure in SQL

    I need to create a stored procedure in SQL where the clause WHERE is a parameter. Is this possible? If yes, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • View a concise list of all Job Schedules SQL Server 2000

    I have an Optimisation job on my SQL platform (2000), which continually fails. I suspect the cause in that this job overlaps another, but without going through each job and checking the schedules I can't be sure. The number jobs I have makes this an onerous task. Is there a way to query the...

    Cyphersimian30 pointsBadges:
  • Conducting a performancee baseline comparison

    I was reading this 2-part article on performance baselines. I would like to know how someone actually performs the comparison between the performance on the system with the baseline? How do you use SQL Server Profiler and PerfMon to do the comparison?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Reporting services

    I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.

    Hydrostani20 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • Alternatives to cursors in SQL Server

    What are the alternatives to cursors? I can’t find any other method to move through record sets one at a time.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Issues with multiple DBs on one SQL Server instance?

    We have multiple SQL Server instances running on different servers in our organization, each requiring maintenance and backup. We have a vendor backing up these instances that charges on a per instance basis. I am doing a review to see if I can bring all those SQL Server DBs onto just one instance...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DR/HA questions with SQL Server design

    Greetings! I need your advice for two questions. This is related to design. I have a production site. It requires HA. At the same time we have a DR site. The DR site needs to have the same copy of the database for my application to run. Question 1: Is it advisable to have mirroring on the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • DB mirroring with SQL Server 2005: Standard vs. Enterprise

    On the subject of database mirroring in SQL Server 2005… Besides snapshot access and high safety mode having to be on, as well as the redo thread count, are there any other limitations placed on mirroring, utilizing Standard edition vs. Enterprise edition? I was under the assumption that to allow...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Substring Query SQL

    Hi All, I'm trying to build a query to join names in one table to abbreviated names in another table. So for example I have - Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the amount of Har names with the total...

    Smillsie20 pointsBadges:
  • Problems installing BCM for Outlook 2007

    I have purchased 9 seats though volume liscensing for Outlook 2007 with BCM.  The first 7 installs with out a problem.  The last 2 have thrown this error: Setup failed to install the required component Microsoft SQL Server 2005 Express (MSSMLBIZ). Business Contact Manager for Outlook 2007 cannot...

    Flame14,925 pointsBadges:
  • Sudden SQL errors keep Business Contact Manager from loadingHELP – Sudden SQL errors keep Business Contact Manager from loading

    Dessteele5 pointsBadges:
  • HOW TO CONNECT VS2005 TO SQL2005

    Dear sir, how to connect vs2005 to sql2005 and which setting do in vs2005 and sql2005    

    Sql2055 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