• Role of Excel/Access in SQL Server 2008 R2

    What is the role of Excel / Access in SQL Server 2008 R2?

    ITKE352,380 pointsBadges:
  • sysfiles1 is missing sql server 2005

    is sysfiles1 table removed in SQL Server 2005 onwards?

    AshwiniSrinivasa5 pointsBadges:
  • Could you please advise the command to print hardware config. from AS/400

    Could you please advise the command to print hardware config. from AS/400

    Zyrain5 pointsBadges:
  • Merge synchronization using only Sql Server Express 2005

    I'm developing a database application using VB.net. I would like to use SQL Server Express for the database so that my customers won't have to purchase additional software along with the cost of my software. One of my requirements is that the application can use merge synchronization. Will merge...

    RiverGuy5 pointsBadges:
  • Internal vs Externa Stored Procedure Performance

    Our company develops software for Windows using C# for connecting and updating the corporate database in DB2/400. We use both internal (SQL) and external (rpg) stored procedures. Because we have noticed some bad performance in our internal stored procedures, we have the following question: Is there...

    Baron4005 pointsBadges:
  • Selecting Reporting Builder 3.0 on the Report Manager Site

    Can Report Builder 3 be added as a selectable tool on the Report Manager site created by a SQL Express with advanced features installation? Does the license allow using RB3 and is there documentation on how to get it to show up at the top of the report manager site?

    ITKE352,380 pointsBadges:
  • Final Version of Report Builder 3.0

    I got a Beta of RB 3.0 several months ago. Has the final been released?

    ITKE352,380 pointsBadges:
  • Do Businesses still need SQL Server?

    With all the upgrades to MySQL, has SQLServer needed to step up its game or do you think business still needs SQLServer?

    ITKE352,380 pointsBadges:
  • Integrate ERP with SQL Server 2008 R2

    If we run a third party ERP installed in SQL Server 2008 r2, how do we integrate it SQL Azure?

    ITKE352,380 pointsBadges:
  • 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?

    ITKE352,380 pointsBadges:
  • Ensuring the Data security by hosting the server @cloud?

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

    ITKE352,380 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:

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