• Using SQL Server databases on data with numerous checks

    I am interesting in cleaning census data, and I have a number of edit checks, consistency checks, validation checks and range checks to perform. What is the best practice you would recommend, using SQL Server as the database?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Migrating DTS packages to SSIS

    What is the tool that migrates DTS packages to SSIS, and how effective is it?

    SQL Server Ask the Experts2,585 pointsBadges:
  • sqlcode -727

    ANY ONE KNOW WHAT -727 SQL RETURN CODEIS?

    Bebiii15 pointsBadges:
  • Viewing distinct records in a SQL query result

    I have a set of records in a SQL query result. I only want to see one record, per the data field "ID". I am getting 2 records for some ID's, as there is one field that is different in the 2 records. This happens even if I start the query out with SELECT, DISTINCT, and then all of the fields I need....

    SQL Server Ask the Experts2,585 pointsBadges:
  • Delete names from an email list in SQL Server Integration Services

    How can I delete names from an email list in SQL Server Integration Services?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Refresh a SQL View in ILE

    I have created a view and am using in an ILE module. I have updated one of the files that the view is built with. How do I refresh the View to see this record the next time I run the SQL view? Is there a CREATE OR REPLACE VIEW in RPGILE? Thank you.

    BisonHawk25 pointsBadges:
  • Tool for migrating DTS to SSIS

    What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

    Lingala5 pointsBadges:
  • Running queries causing system to hang

    A few weeks ago we had a major crash that was caused by a bad install. I wiped the machine and reinstalled the OS (Windows Server 2003). At first everything appeared to be fine. We are using: 2 x 4 core 2.33 GHz Xeon E5345 Intel s5000XVN motherboard 12GB Ram ATI Radeon x300 Video The machine is...

    WindowsServerATE335 pointsBadges:
  • How do I write a SQL statement to get all data from a table called subscrib?

    How do I write a SQL statement to get all data from a table called subscrib?

    Thechriseco5 pointsBadges:
  • Error running an ASP.NET application in SQL Server 2005

    I have SQL Server 2005, version 9.0, installed on my system with VB.NET 2005 and IIS server running. When i tried to run an application created in ASP.NET, it showed me the following error: The XML page cannot be displayed. Cannot view XML input using XSL style sheet. Please correct the error and...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Store Procedure Codes Please help

    I have a problem in SQL, and please expert helps me out and give me an advice of how to solve this issue. I have a main table where to store the data, I have mutliple columns and those are SSN, DECLEAREDDATE, SOMATICMCCLEAREDDATE, PSYCMCCLEAREDDATE, DESECONDCLEAREDDATE, SOMATICMCCLEAREDDATE,...

    Josephptran15 pointsBadges:
  • The XML page cannot be displayed

    I am using sql server 2005 with vb.net 2005 and IIS server installed. I tried to run the application created in Asp.net,but it showed me the following error. The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or...

    Sajad5 pointsBadges:
  • Matching External lists to your Database?

    Hello everyone, I work in a telco and manage the data in the company's CRM. I'm often given lists of company names by our alliance team, and asked to match the list against our database to see which companies already exist in the CRM and which don't. At the moment I can only accomplish this by...

    Nik145 pointsBadges:
  • Cannot connect to SQL Server via LAN

    I try to add a new server registration using Enterprise Manager in a client machine to the SQL database in the server machine. I somehow keep getting 'Access denied' or registration failed. Then I can finally add the server registration after I open the shared folder at the server. Can anybody...

    MissBelle5 pointsBadges:
  • SQL Writer library failed initialization

    SQL Writer library failed initialization. Your installattion iseither corrupt or has been tampered with. Please uninstall then re-run setupto correct this problem. How should I handle this?

    Valeverger10 pointsBadges:
  • Installing SQL Server 2000 on Windows XP Pro

    How do you install SQL Server 2000 on Windows XP Professional?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Configuring IPv4 host to IPv6 compatible in Fedora 9 Sulphur

    How do I configure the IPv4 host to IPv6 so that it is compatible in Fedora 9 Sulphur?

    NetworkingATE1,545 pointsBadges:
  • What is the difference between SQL and T-SQL?

    What is the difference between SQL and T-SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Simple SQL server question?

    I want to do something that WAS easy in my former world (a dBase environment) but I can't figure out how to do it in MS Access/SQL Server 2000. I would GREATLY appreciate anyone's help. This is what I want to do, in order: 1) Select the top # records of a table, "#" is a field in another table....

    Jtischler5 pointsBadges:
  • Create text file to OS400 folder by using Microsoft SQL Server 2005

    Hi All, Do u have any idea to create text file to the OS400 folder by using MS SQL Server 2005? currently i had map drive with OS400 folder in server. i only can create text file at local server by using Ms SQL Server 2005. No idea to create text file at OS400 folder. But allow use dos command to...

    Sql200920 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