Daily Question and Answer Update for Jan 8, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- DataCenter
- Development
- Linux
- Networking
- Security
- Storage
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all CRM related Questions and Answers
http://go.techtarget.com/r/5513319/4946246/1
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Can we migrate already encrypted data from SQL Server 2000 to MS SQL Server
2008

ANSWER from Mrdenny:
You will probably want to migrate the process that was used on the SQL 2000
server to encrypt and decrypt the data as well until you can get the navive SQL
2008 encryption/decryption working correctly. You may need to decrypt your
data and reencrypt your data if the SQL 2008 native encryption doesn...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5513320/4946246/2

-----------------------------------------------------------------------
NEW QUESTION on:
Is there a query to retrieve datatypes from SQL stored procedures?

QUESTION from SQL Server Ask the Experts:
I have used the following simple query to retrieve datatypes from SQL Server
2000 tables:

[I]select TABLE_NAME,
COLUMN_NAME,
DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH
from <tablename>.information_schema.columns
where table_name = '<tablename>' and column_name = '<columnnam...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5513321/4946246/3

-----------------------------------------------------------------------
DATACENTER UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Data Center related Questions and Answers
http://go.techtarget.com/r/5513322/4946246/4
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Data Area Lock issue in RPG ILE

ANSWER from Gilly400:

Hi,

I don't think what you want to do is going to be very easy to achieve.

What you may be able to do is find out which sessions have a lock on the data
area and either end the sessions using ENDJOB or send the sessions a message
requesting the users to exit their session or return to their ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5513323/4946246/5

-----------------------------------------------------------------------
NEW ANSWER on:
How can I get my Dell Optiplex to see a USB keyboard DURING boot process? (So I
can get to the BIOS.)

ANSWER from Dales:
I would imagine to start with that your keyboard is not truly capable of being
a usb keyboard, just because you have a convertor doesnt mean it will work as
the keyboard still requires the hardware to tell the pc what it is.

So unless you are sure that the keyboard works with a convertor on anoth...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5513324/4946246/6

-----------------------------------------------------------------------
NEW DISCUSSION on:
rpg/400

DISCUSSION from Philpl1jb:
DINVAM 68 80
C EVAL INVAM = %EDITC(APCINA:?3')
INVAM is 13 long,
our edit codes assume that APCINA is
something like 12 2 if APCINA is wider it will push the decimal out of INVAM

If APCINA has 0 decimals and is short enough you might use something like

C EVAL INVAM = %trim(%EDITC(APC...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513325/4946246/7

-----------------------------------------------------------------------
DEVELOPMENT UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5513331/4946246/8

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5513331/4946246/9

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5513331/4946246/10

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5513331/4946246/11

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5513332/4946246/12
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What should our next contest be on ITKnowledgeExchange.com?

DISCUSSION from Mrdenny:
I think an interesting contest could be one where the poster who posts the
question which generates the most "useful" comments or replies gets rewarded.

Basically allowing the user base to decide which questions are the best based
on the number of comments which go with the question.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513327/4946246/13

-----------------------------------------------------------------------
NEW QUESTION on:
Change User Account Name in Active Directory

QUESTION from Technochic:
You can re-name her account in AD and it will not change any of her permissions
or any memberships of groups and will also keep her old email addresses so she
can still receive emails from people who are not yet aware of her name change.
In AD also go to the email addresses tab, create her new email...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5513342/4946246/14

-----------------------------------------------------------------------
LINUX UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Linux related Questions and Answers
http://go.techtarget.com/r/5513330/4946246/15
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What should our next contest be on ITKnowledgeExchange.com?

DISCUSSION from Mrdenny:
I think an interesting contest could be one where the poster who posts the
question which generates the most "useful" comments or replies gets rewarded.

Basically allowing the user base to decide which questions are the best based
on the number of comments which go with the question.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513327/4946246/16

-----------------------------------------------------------------------
NETWORKING UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: TechTarget

Read the most targeted, up-to-the-minute news and exclusive features on
pertinent Windows topics.
http://go.techtarget.com/r/5513331/4946246/17

Our newsletters provide the latest Windows-based tips, tutorials, e-guides and
more straight to your inbox.
http://go.techtarget.com/r/5513331/4946246/18

Attend free events to get expert advice on topics such as desktop
virtualization and email archiving.
http://go.techtarget.com/r/5513331/4946246/19

Access research libraries, RSS feeds, ask the expert pages, and other great
resources.
http://go.techtarget.com/r/5513331/4946246/20

Each site provides you with information on a different Windows discipline -
find out more now!
http://go.techtarget.com/r/5513332/4946246/21
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Crystal Reports can't connect to Access 2007

QUESTION from Rcsully65:
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see
the dB's. I think it is the new file extensions with Access 2007. Anyone know
how I can connect and see the dB's.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5513333/4946246/22

-----------------------------------------------------------------------
UPDATED ANSWER on:
I am getting ORA-01422: Exact fetch returns more than requested number of rows

ANSWER from Carlosdl:
That error occurs in a SELECT ... INTO statement, when your query returns more
than one row.

Check your where clause, and make the necessary changes in order to ensure just
1 row is returned.

There is a predefined exception for that error. It is: too_many_rows.

If you know your query could...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5513334/4946246/23

-----------------------------------------------------------------------
NEW ANSWER on:
Can RAID 0 volume be deleted and re-added with no data loss?

ANSWER from Mrdenny:
Most RAID controllers will wipe the data when you recreate the volume.

In theory you can delete the array and if it is recreated with the disks in the
same order the logical volume will remain intact. I would NOT try this without
backing up the data on the array before hand. You will probably l...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5513335/4946246/24

-----------------------------------------------------------------------
NEW DISCUSSION on:
What should our next contest be on ITKnowledgeExchange.com?

DISCUSSION from Mrdenny:
I think an interesting contest could be one where the poster who posts the
question which generates the most "useful" comments or replies gets rewarded.

Basically allowing the user base to decide which questions are the best based
on the number of comments which go with the question.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513327/4946246/25

-----------------------------------------------------------------------
NEW DISCUSSION on:
Searching using Oracle Forms 6i

DISCUSSION from Carlosdl:
enter_query and execute_query are restricted procedures. It means they cannot
be called from triggers while internal navigation is ocurring.

From the forms help:

"Restricted built-ins cannot be called from the Pre and Post triggers, which
fire when Form Builder is navigating from object to a...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513336/4946246/26

-----------------------------------------------------------------------
NEW DISCUSSION on:
Operating System not found

DISCUSSION from Pressler2904:
Along the lines of what petkoa says, make sure that all internal connections
(expansion cards, hard drive cables, internal USB cables, etc...) are properly
inserted and well seated (and yes, they do occasionally come loose all by
themselves: call it the perversity of inanimate objects...)

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513337/4946246/27

-----------------------------------------------------------------------
NEW DISCUSSION on:
Inserting CRLF in mainframe FTP program

DISCUSSION from Petkoa:
Well, if it's possible to open the file in the textpad and save it in PC format
without damaging it, why don't you do the same on the unix machine? GNU nano
can save files in unix, pc, mac formats. You can accomplish this with sed :

sed -i.bak 's/$/^M/' test.txt

This command will work "i...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513338/4946246/28

-----------------------------------------------------------------------
SECURITY UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Security related Questions and Answers
http://go.techtarget.com/r/5513339/4946246/29
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
Crystal Reports can't connect to Access 2007

QUESTION from Rcsully65:
We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see
the dB's. I think it is the new file extensions with Access 2007. Anyone know
how I can connect and see the dB's.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5513333/4946246/30

-----------------------------------------------------------------------
NEW DISCUSSION on:
What should our next contest be on ITKnowledgeExchange.com?

DISCUSSION from Mrdenny:
I think an interesting contest could be one where the poster who posts the
question which generates the most "useful" comments or replies gets rewarded.

Basically allowing the user base to decide which questions are the best based
on the number of comments which go with the question.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513327/4946246/31

-----------------------------------------------------------------------
STORAGE UPDATES
-----------------------------------------------------------------------

:::::::::::::::::::::::::: ADVERTISEMENT :::::::::::::::::::::::::::
Sponsored by: ITKE

View all Storage related Questions and Answers
http://go.techtarget.com/r/5513340/4946246/32
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
What should our next contest be on ITKnowledgeExchange.com?

DISCUSSION from Mrdenny:
I think an interesting contest could be one where the poster who posts the
question which generates the most "useful" comments or replies gets rewarded.

Basically allowing the user base to decide which questions are the best based
on the number of comments which go with the question.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513327/4946246/33

-----------------------------------------------------------------------
NEW DISCUSSION on:
Operating System not found

DISCUSSION from Pressler2904:
Along the lines of what petkoa says, make sure that all internal connections
(expansion cards, hard drive cables, internal USB cables, etc...) are properly
inserted and well seated (and yes, they do occasionally come loose all by
themselves: call it the perversity of inanimate objects...)

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5513337/4946246/34

-----------------------------------------------------------------------
NEW QUESTION on:
What is the best &amp; quickest way to get a networking job?

QUESTION from Labnuke99:
Comptia is a non-vendor specific program. It is likely the best (I did not say
easiest) basic training solution for general networking. You should learn
something about all of the other technologies you mention though to be a
valuable resource to any organization you work for.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5513341/4946246/35

-----------------------------------------------------------------------
-----------------------------------------------------------------------

UNSUBSCRIBE
You are receiving this e-mail because you subscribed to tag e-mail alerts
on ITKnowledgeExchange.com.

To unsubscribe from tag e-mail alerts click the link below to
"Edit My Account". Go to the Newsletter Preferences section and un-check
tags you no longer wish to receive e-mail alerts on and click "Save".
http://ITKnowledgeExchange.techtarget.com/settings/account/

To unsubscribe from all tag e-mail alerts, click the link below:
http://ITKnowledgeExchange.techtarget.com/unsubscribe?email=sekhargreen@gmail.com&key=41289&tag=1

Contact us:
TechTarget
Member Services
117 Kendrick Street, Suite 800
Needham, MA 02494

-----------------------------------------------------------------------

ABOUT THIS E-NEWSLETTER
This e-newsletter is published by ITKnowledgeExchange.com, a
targeted Web site from TechTarget, The IT Media ROI Experts and
events company.

Copyright 2009 TechTarget. All rights reserved.