• Contest Bounty: Ask/Answer questions this weekend, earn 100 points!

    Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of...

    MelanieYarbrough6,345 pointsBadges:
  • Attaching MDF and LDF files to SQL Server 2005

    I have MDF and LDF files with different modified dates. How could I attach these to SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • ssrs interview questions and answers

    ssrs interview questions and answers

    LouTermini5 pointsBadges:
  • Completed IT Knowledge Exchange Profile? Earn points!

    What's a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward...

    MelanieYarbrough6,345 pointsBadges:
  • Empty Reports in Forefront TMG SP1

    Hello! 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...

    11235813215 pointsBadges:
  • SQL9010 is: RUNSQLSTM command failed.

    SQL9010 is: RUNSQLSTM command failed.

    Lllooloool5 pointsBadges:
  • SQL Oracle for rolling the period return

    Hi ,  i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query .  return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should...

    Piyushr15 pointsBadges:
  • How to make the connection in SQL 2000 with Visual Basic 6

    i want to make the sql connection with vb6,how to open the connection in sql

    Vishalngp15 pointsBadges:
  • SQL processor license

    on a physical server we select 2 processors. we then select SQL 2008 STD 1 socket license. since the server has 2 processors, can we assign SQL to only processor and run? if we can, can the second processor on the server be used by the OS on the server?

    Enterprises5 pointsBadges:
  • Embedded SQL in RPGLE hdr, dtl fetch for subfile build

    I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr      E DS                  EXTNAME(wtchdr) D dswtcdet      E DS                  EXTNAME(wtcdet) C     $CreateCsr   ...

    NickHutcheson11,380 pointsBadges:
  • Embedded SQL in rpg for subfile build SQLCOD

    My fetch next in sql is getting sqlcod = -000000181 and sqlstt = '22007'.  I looked this up.  It says invalid date or time. Pointing to date data types in the file I am trying to read. The records contain two date fields and two time fields. How can I get around this?   Thanks in advance. Nick

    NickHutcheson11,380 pointsBadges:
  • MaximumErrorCount

    HOW DO I CHANGE THE MaximumErrorCount IN SSIS

    Vercom5 pointsBadges:
  • Excel Spreadsheets

    We developed some kind of database with excel spreadsheets to draw monthly stats for diffrent departments. It works as follows: Individual spreadsheets(formulated)feeds into a master Link spreadsheets(data) we then use Pivots for our reports. The problem that I now expierence is that: 1. The...

    Joshua55 pointsBadges:
  • SQL Server Data Files

    I have a production server with 10 databases, is it good practice to put all the log files for all 10 databases on one RAID 5?

    Rick Martinez585 pointsBadges:
  • Will you be at Interop Las Vegas next week?

    Grab lunch or a coffee with editor Michael Morisy to discuss what you think of the keynotes, sessions, and vendor announcements at Interop next week. Get some sweet IT Knowledge Exchange swag and let us know what you're thinking of the show and the direction of networking in general! Let him know...

    ITKE56,510 pointsBadges:
  • Open IT Forum: Share networking resources, earn knowledge points!

    It's Networking month at IT Knowledge Exchange, and we're looking for your best resources on the subject. Share networking guides, blogs, tips, books, and great Twitter pros to follow! For each category you contribute to, we'll give you 25 knowledge points, good toward our latest contest.

    MelanieYarbrough6,345 pointsBadges:
  • Dynamic SQL query

    Hi! I'm making an application in vb.net using MS Access as DB.. Nw in this, i want to do some complex stuff, that is dynamically making sql queries or in other words, changing the where clause according to user preference. The scenario let's say is...in a form the user can search for records thru...

    Ayisha5 pointsBadges:
  • Frequency of witness pings to partners

    Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

    BitBangerDBA5 pointsBadges:
  • Spring Cleaning: Free IT Book(s) Giveaway!

    This week's IT book giveaway is a little bit different: 1. Answer two of the five questions listed below. Link to your answer in the discussion area of this question. 2. Ask five questions between May 2 and May 8. Link to your questions in the discussion area of this question. 3. Approve three...

    MelanieYarbrough6,345 pointsBadges:
  • Receiving a Binary file

    I have a vendor who is placing a files on a FTP Server in Binary.  I need to retrieve those files and place them into an iSeries database file. Is there away to retrieve the file straight from the FTP Server into the database file using GET that will translate from binary to mixed text and packed...

    AS400PCFileTransfer16115 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