• Security on the Cloud

    How you are securing the confidential data? Is there a chance for someone to access or view our confidential data by whoever is maintaining the Server @cloud? How do you ensure what you said above?

    ITKE346,195 pointsBadges:
  • Ensuring the Data security by hosting the server @cloud?

    How you are ensuring the Data security by hosting the server @cloud?

    ITKE346,195 pointsBadges:
  • Win a Dell Precision T7500 Workstation

    All you have to do is correctly answer 5 multiple choice questions, each with a hint provided, and you could be the owner of a new Dell Precision T7500 Tower Workstation Desktop Computer with the Quad Core Intel Xeon Processor. Even if you don't win, you still get 200 Knowledge Points for your...

    EmNichs3,250 pointsBadges:
  • My as/400 SQL is getting a ‘ Value for column too long.’ error msg

    Value for column or variable SPDESC too long. UPDATE mbmtest01/wbmscur set spdesc = (Select itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  WHERE EXISTS (SELECT DISTINCT itdsc FROM amflib7/itemasa WHERE itnbr = spptno)  How do I make the field truncate the larger input field. The input field is...

    nitzinger385 pointsBadges:
  • AS/400 SQL for two file compare and update

    Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field. UPDATE mbmtest01/wbmscur  set spdesc = itdsc  from amflib7/itemasa  where spdesc = ' ' and itnbr = spptno Keyword FROM not expected. Valid...

    nitzinger385 pointsBadges:
  • Problem with SSIS & AS400, Source is AS400, Dest is SQL2005

    When I'm trying to retrieve data from AS400, I received the below error: The column status returned was: "Text was truncated or one or more characters had no match in the target code page.". How do I know which code page to use besides the default of 1252?

    Thuybui35 pointsBadges:
  • Partitioning in SQL Server 2005/2008

    We have partitioned 5 large tables across 10 partitions (with 10 filegroups) and with a set of 5 - 6 users the performance was adequate, with minimal conflicts (like deadlocks etc), but we want to implement this scheme that can scale to say 300 users. With regard to this I have the following...

    Inquisito20 pointsBadges:
  • SQL record with latest date

    if there is one table with a id and names as cloumns and another table with the id and dates, if want to have a id, name and the latest dates as an id can have mulitple dates what would be the query

    Techybrains5 pointsBadges:
  • Data type : GMToffset in SQL Server 2000

    how this data type GMToffset will work.?? can you please help me in that where the offset is a feild in the table & GMToffset is its data type exist in sql server 2000 or it is derived ?? why we use GMT instead of local time?? Is this data type x

    NSH5 pointsBadges:
  • rpg sql

    I am using dynamic sql in an rpgle pgm. This pgm is called from 2 different menu options. When I take the 2nd option, everything works fine. I exit out of that option and take the first option. Everything is still work fine. I exit the first option and go back to the 2nd option and the pgm hangs up...

    mcg15 pointsBadges:
  • SQL connection failure error handling

    Application group wants batch job to terminate if it is unable to establish SQL session to external database. Job log indicates MSGID QSQLMSG/SQ30080 "Communication error occurred during distributed database processing.   This appears in the joblog as a level 30 diagnostic message. When this...

    Midranger25 pointsBadges:
  • SQL0444 when I tried to access schema folder from CAE tree

    I am getting an error message indicating the following; [SQL0444] External program QPZA004366 in QIWS not found. Cause An attempt was made to CALL procedure or invoke function QZDGDBLL in QIWS. I open client access > Logged in > click on Database > Schema and I get this prompt message of...

    I5user5 pointsBadges:
  • which version of sql can be installed on windows vista 32 bit?

    which version of sql can be installed on windows vista 32 bit?

    Keerthishetti5 pointsBadges:
  • How to save data back to databse from radio button? SQL Server 2005

    I am using 4 radio button, what so ever radio button I select, so how data revert back to database, I am doing this in asp.net 3.5 using sql server 2005

    Shaktilpu15 pointsBadges:
  • SQL Server Business INtelligence

    While creating a report, is it ok to create data set using stored procedure by calling an existing one from the database, or, by creating a stored procedure within BIDS and imeplement it? Please, explain. Thanx in advance.

    RonitReno25 pointsBadges:
  • Locking and concurrency in SQL server 2008

    In microsft SQL 2008 enterprise edition, readers block writers and writers block readers. What does it mean? Is it that on same set of records only one query be processed.

    Akansha150 pointsBadges:
  • SSRS 2008 and SharePoint programmatically

    In SharePoint Integrated Mode of SSRS 2008, how to get the Report Server Instance Name, Report Server DB Name and SQL Server Instance Name hosting Report Server DB programmatically? Can it be done using SharePoint object model or through ReportService2006 web methods?

    PrashantGupta5 pointsBadges:
  • Page level lock in SQL 2008

    What is the meaning of page level lock in microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • Database for OLTP

    Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

    Akansha150 pointsBadges:
  • OLTP in SQL Server 2008

    While using OLTP in Micrsoft SQL 2008 enterprise edition, does the row level locking happens or table level locking happens?

    Akansha150 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