• Add an Active node to SQL Server Active Passive Cluster

    how will i add an active node to an existing Active/passive SQL Server 2005 Cluster. so that when any active node fails the passive will be used.will there be a down time for the current cluster Jasina

    Jasina30 pointsBadges:
  • Advantages and disadvantages of MySQL 5.0

    Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

    Espada0075 pointsBadges:
  • What is a good book for SQL?

    which is the Good book for SQL?

    Prcvjr220 pointsBadges:
  • DB2 Stored Procedure V4R4 without ILE C/400

    We have an older iSeries running V4R4. We user Rumba/400 for AS400 access, and we've run into a problem using the Rumba ODBC driver for linked server access from our SQL server to our AS400 (The ODBC driver periodically fails when the linked server is used heavily). Because of this, we've been...

    MODMOD0 pointsBadges:
  • SQL 2008 job problem

    I have a schedule SQL2008 job to export the contents of a table to a text file each day. The job runs fine when I manually execute it, but if the schedule executes it, only 4 or 5 lines of text out of about 13000 are produced to the text file. Any ideas anyone? The job script follows: EXEC...

    DavidHa!!110 pointsBadges:
  • Example of Cobol call to an SQL stored procedure

    I am new to the iSeries and need to know how to use a Cobol program to call an SQL stored procedure. Someone has already created the stored procedure for me, but I am not sure how to call stored procedures in Cobol on the iSeries. The passed data looks like: FIND_CLIENT ( IN LastName CHAR(35), IN...

    Dfe07225 pointsBadges:
  • EBCDIC Database File Problem

    My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special...

    SKF75 pointsBadges:
  • Trying to get select all in a dropdown from the AS400 to SSRS(Urgent)

    I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don't know if there is a way...

    AMcAuley3105 pointsBadges:
  • Error trying to get a store produce to work from AS 400 to SSRS

    I have made a store procedure that runs fine but when I try to Call it into SSRS I am getting an error. The Error says SP_Convert_Date_MMDDYYY_to_CYYMMDD in *N type *N not found. Is there anyway of getting it to find my file in the AS 400 and what would I have to do?

    AMcAuley3105 pointsBadges:
  • Can’t bring master database back online

    hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did't get that one into online(production side)wht is root cause for that?

    241219840 pointsBadges:
  • Running SQL PLUS on a server

    Can I use mapped drives and environment variables to run SQLPLUS from a local machine(without any Oracle products) to a server. The mapped server has the Oracle products? Example: W - map to my Oracle server C drive EV = w:oracleora92binsqlplusw cmd : start %EV% I'm trying to host out of Oracle...

    Lynrobbins5 pointsBadges:
  • How to transfer database from SQL Server 2008 to SQL Server 2005

    how to attach database of  sql 2008 into sql 2005

    Itready5 pointsBadges:
  • We’ll trade you an Xbox 360 for your knowledge!

    The holidays are approaching and so is your next chance to win an Xbox 360 by simply doing what you do around IT Knowledge Exchange. Between today and December 15th, the three members who accumulate the most knowledge points will win some great prizes:   1st Prize: Xbox 360 with 250GB hard drive &...

    MelanieYarbrough6,345 pointsBadges:
  • Refresh Excel file on a different server with SSIS package

    I am trying to refresh an excel file that is on different server. is there any script that can be creatted with SSIS pacage that can do this. any help will be appriciated. Thank you in advance.

    Tocken10 pointsBadges:
  • 3rd party connectivity to SQL server through firewall

    We need to allow a third party to connect to one of the SQL servers in our DMZ via an externally initiated SQL connection. What is the best approach and what are the risks?

    Patch0115 pointsBadges:
  • Do I need SQL?

    DO I need it? I am just a home user anf oerform simole tasks, but have 8 examples of SQL programs in my program list. I have win 7 64 bit O/S

    0 pointsBadges:
  • T-SQL with Recursion – Display top ID on all levels below (To: Kent Milligan)

    Hell Kent, I read through "V5R4 SQL Packs a Punch" http://www-03.ibm.com/systems/resources/systems_i_software_db2_pdf_rcte_olap.pdf    I would need the query in figure 20 and the result in figure 21 which do not show up in the article.  I have a query similar to the example (parts of an iSeries...

    Cavallino30 pointsBadges:
  • IN and Exists in SQL?

    What is the difference between IN and EXISTS IN SQL? I googled but I dint get good information. PLease provide me the exact deifference between them.

    Prcvjr220 pointsBadges:
  • trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.

    We are trying using MAC address authentication for AP from NPS RADIUS Windows Server 2008. Two things we are facing need help: What's the "condition" selected and how's the format? Secondly, How do we excute the query of SQL( 2008)table column? I do make conection successful but I do not have any...

    CHENS265 pointsBadges:
  • Microsoft SQL Server BCP Utility password

    I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments. I am looking for a method...

    Redwine20 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