Questions & Answers

  • AS/400 Firmware Upgrade

    Can you provide me the steps for rollback plan when performing the firmware upgrade? We are planning on a firmware upgrade from SF240_320 to SF240_417 on our V6R1 system. And we need to submit the plan to management for approval. I need the steps for rollback in case of any problem.

    Srini050515 pointsBadges:
  • Security for SQL Server 2012 SSAS

    So I just installed an instance with SSAS only. Now, I'm curious how security (login) will be maintained. I've created one instance with engine and SSAS (Dimensional) and another instance with just SSAS (Tabular).

    ITKE351,905 pointsBadges:
  • Date, Time and numbers change format instructions for Linux environment.

    Date, Time and numbers change format instructions for Linux environment. It has to be written in English. Action button to automate Date, Time and numbers setting on Linux environment. This action button must work as an embedded button on a mail, in order to be able to send it to the user, and user...

    harshapahadiya5 pointsBadges:
  • Upgrade from system i 5.4 to 7.1 skipping 6.1

    Has anyone upgraded directly to 7.1 from 5.4 skipping 6.1? Any gotchas not obvious. What's your experience. Thanks.

    OldSysAdmin945 pointsBadges:
  • Lotus Notes template

    Lotus Notes 6.5 mail template illegal circular use core-emailer; I have a customized mail template and am using Domino 6.5. Each time my users open mail or create a new memo we or they get "illegal circullar use coreemailer." I have to click it between 6 to 10 ten times before it goes off and after...

    charleskanzim30 pointsBadges:
  • Sending Job into MSGW

    When a batch job is submitted, no system errors but there are no records in the file to process, I want to send the job into MSGW and show the message that a certain file does not have records? How to send a job forcefully into MSGW using SNDPGMMSG or SNDUSRMSG?

    TNKR130 pointsBadges:
  • How to view transaction logs in SQL Server 2014?

    Hi, I have SQL Server 2014 CTP 1 installed and I can’t figure out how to view all transaction logs.Does anyone know where I can find them? I’ve looked at datasheets and documentation on MS website but I couldn’t find anything.

    ITKE351,905 pointsBadges:
  • AS/400 session without user intervention

    How can I refresh an AS/400 session without user intervention?

    07091988ramya55 pointsBadges:
  • List All OUTQs

    How do I list all of the OUTQs from all the libraries on the iSeries? We are at V7R1 and I tried the WRKOUTQ *ALL/*ALL only to receive an error that I can not ask for *all libraries & *all OUTQs at the same time.

    IPGGary5 pointsBadges:
  • Only first line of batch file executes in Windows 7

    I have a batch file that is executing three maven commands, one after each other. The great thing about each command is all three can be successfully executed in the script by itself. However, when all three commands are in the same file, only the first one executes. mvn install:install-file...

    ITKE351,905 pointsBadges:
  • Detecting SQL Server 2008 R2 on Windows

    Now this may seem like a simple question, but I'm looking to detect SQL Server 2008 R2 on different versions of Windows. Here are the ways I've come up with: Via registry Via file system Via installer exit code Which way would be the easiest?

    ITKE351,905 pointsBadges:
  • Offsetting rows in SQL Server

    How can I use SQL Server to provide results starting at a given offset? For example, in another SQL server, it's possible to do:SELECT * FROM MyTable OFFSET 50 LIMIT 25to get results 50-74. This construct does not appear to exist in SQL Server. Is there a way to do this where only the rows I am...

    ITKE351,905 pointsBadges:
  • T-SQL: Split function

    I'm trying to split "1, 2, 3, 4, 5, 6, 7, 8, 9, 10" into a table or table variable. Is there a function that returns each number in a row?

    ITKE351,905 pointsBadges:
  • XP Updates

    Anyone know of site where ALL XP updates from SP1 can be downloaded. When Doing clean install requires Loads of Updates taking time and data, Yes I still have many companies wanting to stay with XP. MS don't have one, But a CD/DVD of All XP updates would be extremely useful, AND I see Many forum...

    cossee5 pointsBadges:
  • I keep receiving an error in SQL Management Studio

    When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message: A connection was successfully established with the server, but then an error occurred during...

    ITKE351,905 pointsBadges:
  • Using JOIN in SQL Server 2012

    I’m trying to create a list of all our employees by last name with their dependents by first name, and birth dates. My output columns are emp_last_name from the employee table and dep_name and dep_date_of_birth. Here is what I’ve specifically been tasked with doing: Use alias table names. Name...

    ITKE351,905 pointsBadges:
  • After Directory Change – STRPCPCM stopped working

    This old command worked fine for many years. STRPCCMD PCCMD('+ RTOPCB + GR-FILE02+ sys+ DEPT+ ACCT+ BPCSJEUPLOAD+ AMHB.DTF') Now do to SarBox, we had to eliminate crossover users from accounting data. After changing the command to point to the new network location, it no longer works. STRPCCMD...

    GRRPG5 pointsBadges:
  • Does SQL Server 2008 R2 Express have Intellisense?

    Is Intellisense available in SQL Server 2008 R2 Express Management Studio? It seems like it should be there. Is it inactive or am I doing something foolish?

    ITKE351,905 pointsBadges:
  • Logging and finding queries in SQL Server 2008

    In SQL Server 2008's activity monitor, I can see the most expensive queries. But my question is if I can actually log this info via Query Analyser? Thanks!

    ITKE351,905 pointsBadges:
  • Comments in Excel using VBA with archived info included

    To whom it may concern,I am currently trying to get very specific cells in a spreadsheet to pull up the previous weeks worth of information (date from the past 5 days at least) and to show up in a comment on very specific cells so that the people in my department do not have to look up the...

    jgarces5 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