• Building new SQL server

    had a sql server (2000 I think) built on enterprise 2003 die. Got new hardware and am beginning the guessing game. any good reference articles, step by step of how to build new and restore backups from external hd. Old server won't even boot.

    uwantfries60 pointsBadges:
  • Backing up and restoring images to Windows Server 2003

    How can I backup images and restore images to my Windows Server 2003?

    NewnanIT1,110 pointsBadges:
  • SELECT with LIMIT in AS/400

    Hi all, On my AS400, I need to select the first 90 records from one file and insert them into another file, but all the time i got all records in my result file. Is there any way to use the parameter LIMIT with my SQL SELECT INSERT INTO LIB1/FILE1 (FILE1) SELECT...

    junioras400250 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • How to extract database with SQL Developer

    Hi there... How do I extract a database created in Oracle APEX, using Oracle SQL Developer tool??? Thanx in advance

    pforos220 pointsBadges:
  • Embedded SQL using SUM or some other method to total up qty and display 1 unique record

    I have an sqlrpgle pgm setup, I want to add another sql select statement. I have a file that contains barcode label data, where multiple records can be assigned to the same Master serial #. My sqlrpg pgm is display various sorts in a screen inquiry. I want to setup my select, to display one record...

    Dobie80 pointsBadges:
  • Related to SQL server 2005

    When we write store procedure it is encrypt by --with encrypt tag means it will locked it doesn't show sp so how it will be DECRYPT?

    ITIndustry5 pointsBadges:
  • Want to delete objects of type ‘File’ except ‘source physical file’

    I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type '*FILE' and object attribute 'PF' but the problem is I don't want to delete 'Source physical files'. I just want to delete files except 'Source physical file'. can anybody suggest how to do that ?

    pankaj2r100 pointsBadges:
  • Modifying a Stored Procedure

    The stored procedure below pulls suspected duplicate records. What I need it to do is return suspected duplicates only if it meets the criteria of having a member record type (GEN) & a non-member record type (WEB). But if the duplicates both have a non-member record type I don't want it showing up...

    DJandLO130 pointsBadges:
  • Announcing the Symantec Endpoint Protection 12 Scavenger Hunt (sponsored)

    Want the chance to win an iPad 2 or Amazon.com gift cards? The Symantec Endpoint Protection 12 Scavenger Hunt is your opportunity to learn about all of the new features of Symantec Endpoint Protection 12 while getting in the running to earn great prizes. Think you know about all of the new features...

    ITKE344,855 pointsBadges:
  • Free IT Book: The Data Warehouse Mentor

    The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He'll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and...

    MelanieYarbrough6,345 pointsBadges:
  • Empty reports in TMG2010

    I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was "The report server cannot process the report. The data source connection...

    Kashifnawaz925 pointsBadges:
  • Rolling back Windows Server 2003 in bulk to a restore point

    We need to roll back 23 Windows Server 2003 to a restore point. Can this be automated?

    TeachMeIT975 pointsBadges:
  • Free IT Book: Building Applications in the Cloud

    This week's free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer's guide to help you not just migrate to the cloud, but "use cloud architectural patterns that deliver superior performance, scalability, and availability." Whether you're building a...

    MelanieYarbrough6,345 pointsBadges:
  • SQL Report Help

    Hi I'm dave and I'm new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return based...

    Blowinup5 pointsBadges:
  • Running a query in Oracle 10g

    How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?

    Varsha500950 pointsBadges:
  • Data Extraction into SQL Server Database from Cache ODBC Database

    Hi.I am trying to extract data from an intersystems cache database into a sql server database for storage and reporting purposes, on behalf of my company. I have not succeeded so far for the last couple of months as it keeps bringing back far more than the expected number of rows, and is...

    SPIDDY0 pointsBadges:
  • Tell your friends about IT Knowledge Exchange, earn 100 points!

    Tell your friends about IT Knowledge Exchange, and get 100 knowledge points closer to winning our latest contest. Simply send out this tweet to earn your points!

    MelanieYarbrough6,345 pointsBadges:
  • Tomorrow at 4PM ET: ITKE Rolls Out New Badge System

    Badges are almost here and we could use your help. Friday at 4pm ET, we will be launching the new badge system so we need you to stay vigilant and let us know if you notice anything odd with your badges, your profile, or the site. Be aware that [strong]we are planning to experience some...

    ITKE344,855 pointsBadges:
  • sql server 2005 service will not start

    I have a new server running server running windows 2003 and sql server 2005. when I turn on allow remote connections and restart sql service the service fails to start. If I turn off allow remote connections the sql service starts with no problems. I have been unable to find any potential solution...

    Cwpmike15 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