• Nominate a member for our latest Panasonic flatscreen giveaway

    In our latest (and biggest!) IT Knowledge Exchange giveaway, we're giving thanks to the star members of the community who provide quality contributions in their questions, answers and discussions. Did a member answer your question in a particularly great way?Did someone recently contribute to a...

    ITKE342,185 pointsBadges:
  • sql help

    is there a way to update multiple records in a table the meet criteria from another table. here is what i'm trying update table/detail set condition = 'r' where condition = ' ' and number_d = (select number_h from table/header where date between 050101 and 051231) thanks in advance

    Cowboypgmr0 pointsBadges:
  • Rename Sheet when report exported to excel

    hi, When i export SSRS report to excel, each new page comes with new sheet. The sheet names are default names (sheet1, sheet2.. sheetn). Is there a way to rename these sheet names while exporting. Thanks in Advance, Rachitha.

    Rachi5 pointsBadges:
  • Dell Optiplex GX520 hibernation/sleep mode issues

    Hello, We have several Dell Optiplex GX520's on the network running Windows XP pro. They randomly fall into sleep mode. Moving the mouse will not wake them - you have to push the power button to get them out of sleep mode. Also we are not able to remotely wake them to do patch updates or remotely...

    Jmello0 pointsBadges:
  • SA Password change for SQL

     What is the easiest procedure for changing the SA password, and what is the procedure for testing the password change?

    Syscheck5 pointsBadges:
  • What is correct syntax for SQL for Maxrecords in OS400/DB2?

    What is correct syntax for SQL for Maxrecords in OS400/DB2? We have a process automatically generating SQL code. However, our iSeries doesn't recognise the code it generates for maxrecords. Here are the examples of what I mean. The DB2 database seems happy with SELECT I1PHON,I1ACC,I1ACC1, FROM...

    Peterax0 pointsBadges:
  • Msg 102, level 15, State 1, Line 14

    Hi, I'm ttrying to create my db tables in a stored procedure and I keep getting the error that the syntax is incorrect around the 'ON' on the line "SET ANSI_NULLS ON". Could you please help me? I can't see what's wrong. Here's my code:  CREATE PROCEDURE InsertDBTables  AS  BEGIN  SET NOCOUNT...

    MasterK15 pointsBadges:
  • The IT Blog Top 10: Nov. 19, 2009

    10. The intermediate IBM i 6.1.1 version Mark Fontecchio takes a look at IBM i 6.1.1, and answers the question of how well it fills the gap for those waiting for i5/OS. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover explains some important adminsitration techniques for...

    Michael Morisy8,323 pointsBadges:
  • Access SQL Server 2003 database from ISeries

    Hello everyone, I have searched the web for SQL Server/ISeries connectivity and have come across some interesting options: java, JDBC etc. But they have not been very clear. I understand that it is not a simple task, but has anyone successfully accessed an SQL Server database from ISeries using SQL...

    Orozcojoe0 pointsBadges:
  • MS SQL Server to Oracle Applications

    We have MS SQL Server Data and need to get into Oracle Applications. Data Source – MS SQL database – Data is to be summarized by transaction type; needs to provide parameter for transactions dates to be extracted.[o:p][/o:p] Data to be loaded initially to STG table and then to GL journal...

    Vkputtagunta5 pointsBadges:
  • How to encrypt a big list of sp’s at once

    I want to encrypt a large amount of store procedures (around 4000)at once,so they wouldn't be able for the final user. As this operation needs to be done several times in the future and taking in consideration that doing this manually will take a long time, I'll like to know if there is a way to do...

    Grizo5 pointsBadges:
  • Composite foreign Key in SQL Server

    I have a composite foreign key that has to be part of the primary key of the new table... but an error appears in SQL server... CREATE TABLE Se_paga_con (IDpel INT NOT NULL, IDvta INT NOT NULL, IDnota INT NOT NULL, CantidadPeliculas INT, PRIMARY KEY (IDpel,IDvta,IDnota), FOREIGN KEY (IDpel, IDvta)...

    GabyCostilla5 pointsBadges:
  • FULL BACKUP taken by SQLExecDirect function works, but backup is not taken why?

    I try to backup SQL server database using ODBC native client apis. One weird error occurs. When I run, SQLExecDirect(stmt, "BACKUP DATABASE dbname TO DISK='C:TESTBK.BAK' WITH FORMAT ", sql_nts ) There are no errors during runtime, and message shows backup taken . But it is not seen innthe specified...

    ITKE342,185 pointsBadges:
  • Join our ITKnowledgeExchange.com LinkedIn group

    We have created an ITKnowledgeExchange.com LinkedIn Group If you are a member of LinkedIn come and join the group. You will be able to continue the discussion or post questions that we will post onto the site. Thanks Sean Community Manager

    ITKE342,185 pointsBadges:
  • The IT Blog Top 10: Nov. 12, 2009

    10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...

    Michael Morisy8,323 pointsBadges:
  • Can we get sql server authenticated logins and passwords?

    Plz forward me the solution of the above query.   Thanks & Regards, Gangadharan M  

    Ganga25845 pointsBadges:
  • How do I fetch synonym names with the SQLTables function in ODBC API?

    Can somebody please explain how to fetch synonym names with the SQLTables function in ODBC API. I currently use the DSN created with SQL Native Client 10 and SQL Server 2005. My code is as follows:</p><p>ret = SQLTables(stmt, NULL, 0, NULL, 0, NULL, 0,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQl Server Replication Internals

    Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.

    Shahi5 pointsBadges:
  • Why is my logical disk usage enormous?

    I have a cluster server (2003 OS) in my environment with SQL Server 2005. It has four internal disks with RAID 10 configurations. My logical disk usage is pretty high and I am not sure how to find out what exactly is “hammering” our server or what database is making this disk activity enormous....

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL select for month date range

    Hello, I am attempting to obtain a count of visits each patient comes in in one month, so for example of they were a new patient in January on the 4th, I would want from the 4th of January to the 4th of February.  The code I am attempting to use is below, but every time I use it, no records are...

    CraigN20 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