Daily Question and Answer Update for Jan 15, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- DataManagement
- Development
- Linux
- Microsoft Windows
- Mobile
- Networking
- Oracle
- SAP
- Security
- SQL Server
- Storage
- Virtualization
- VoIP
Continue the conversation. Answer or discuss a question and earn Knowledge
Points.

-----------------------------------------------------------------------
CRM 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/5584031/4946246/1

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

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

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

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

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/6

-----------------------------------------------------------------------
DATABASE UPDATES
-----------------------------------------------------------------------

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

View all Database related Questions and Answers
http://go.techtarget.com/r/5584070/4946246/7
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

UPDATED ANSWER on:
Access Error importing data from Lotus Notes

ANSWER from Tjones:
Long shot answer ... I am not sure if this will work.
Access database is terribly inefficient in data space management. You may try
to compress the database before attempting the export. In Access 2007--
?Compact and Repair database? is under the Office button - then Manage. I
think it in 20...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584071/4946246/8

-----------------------------------------------------------------------
NEW QUESTION on:
Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

QUESTION from Warykat:
I am successfully using (external) stored procedures with many RPGLE programs.
(Some of these are SQLRPGLE programs because they return a result set.)
All of this works fine.

But if I try to replace some of the RPG I/O in a RPGLE program with embedded
SQL,
creating a SQLRPGLE program, and run ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584019/4946246/9

-----------------------------------------------------------------------
NEW DISCUSSION on:
Adding a password to a SQL Server 2005 database

DISCUSSION from KevinBeaver:
Sure...it just depends on how your users need to access the system. You can
setup standard SQL Server accounts or use Windows authentication. Are you
working with a developer or DBA to set this up?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584033/4946246/10

-----------------------------------------------------------------------
NEW ANSWER on:
Duplicating records in a table with a SQL query

ANSWER from Carlosdl:
You could do it this way:

[CODE]INSERT INTO YourTable
SELECT *
FROM YourTable
GO[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584035/4946246/11

-----------------------------------------------------------------------
NEW ANSWER on:
Adding an index on fields in a SQL Server table

ANSWER from Carlosdl:
Yes, you can.

You should consider creating indexes on columns that are frequently used in the
WHERE ( and ORDER BY, and GROUP BY ) clause of queries.

Fields with low selectivity (such as gender) are not good candidates for
indexing.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584036/4946246/12

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

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

-----------------------------------------------------------------------
NEW QUESTION on:
Hiding the system views table from Microsoft Access

QUESTION from SQL Server Ask the Experts:
How can you hide the system views table from applications like Microsoft
Access? For example, whenever I link to tables in our SQL Server database,
INFORMATION_SCHEMA and sys system views are included in the list of tables.
This prevents us from finding our tables immediately. How can this be done?

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

-----------------------------------------------------------------------
NEW ANSWER on:
Problem with Microsoft Access 2003 write permissions

ANSWER from Randym:
What error messages display? Does it say that no permission to update or does
it say recordset not updateable? If the later, check that the form is not read
only. Check allow update, allow delete, allow insert properties of the form.
If permission is the issue, do they have permissions to update...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584072/4946246/15

-----------------------------------------------------------------------
NEW DISCUSSION on:
Edit data in an Access Form

DISCUSSION from Lydytunes:
That worked. Took a look at my query along with some of the others I had
gotten to work and noticed with the one that wasn't working, I was doing a
group by. I created an intial make table query to do the group by and then
made my original query reference the new table. By doing that, I was able...

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

-----------------------------------------------------------------------
DATACENTER 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/5584031/4946246/17

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

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

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

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

UPDATED ANSWER on:
Puzzle - Find the number?

ANSWER from Hendi:
Good old fashion paper and pencil (actually a pen ) got the answer of
[B]2519[/B].
The simplest way is to find the LCM (Least Common Multiple) of the numbers 2,
3, 4, 5, 6, 7, 8 and 9, then subtract 1 from it. The LCM of 2, 3, 4, 5, 6, 7,
8 and 9 is 2520, Therefore, the answer is 2519.
Good Luc...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584040/4946246/22

-----------------------------------------------------------------------
NEW DISCUSSION on:
upgrade 10.3.9?

DISCUSSION from Phillychad:
Thanks for the help! I went to the site you recommended. I have just one more
question. I want to get the 1gb memory, Is that just one chip? Do i remove the
old memory chip and replace that with this new one? When you spoke of capacity,
did you mean I should use both slots therfore requireing two 1g...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584041/4946246/23

-----------------------------------------------------------------------
NEW DISCUSSION on:
Citrix Metaframe XP management console unavailable

DISCUSSION from Pressler2904:
Thanks to you both! These answers are indeed timely (even though the question
is a bit old) as we are looking at replacing the servers and upgrading to
Presentation Server... Thanks again.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584042/4946246/24

-----------------------------------------------------------------------
NEW QUESTION on:
Licensing issues in virtualized environments

QUESTION from SearchServerVirtualization ATE:
[I]This answer submitted by virtualization expert Eric Siebert:[/I]

I'm guessing you're running VMware ESX because you mention that 16 processors
are being displayed, but I'm not sure what you are using to get this
information. It sounds like your host server has a total of 16 cores, but a VM
wil...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584043/4946246/25

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

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

-----------------------------------------------------------------------
DATAMANAGEMENT UPDATES
-----------------------------------------------------------------------

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

View all Data Management related Questions and Answers
http://go.techtarget.com/r/5584075/4946246/27
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
migration of Crystal Reports 8 to Crystal Reports 2008

QUESTION from Kln:
How to migrate Crystal Reports 8.0 to Crystal Reports 2008?
The crystal reports which had stored procedures of 8.0 are not executing in
2008, can anyone help? Thanks

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584053/4946246/28

-----------------------------------------------------------------------
NEW ANSWER on:
Duplicating records in a table with a SQL query

ANSWER from Carlosdl:
You could do it this way:

[CODE]INSERT INTO YourTable
SELECT *
FROM YourTable
GO[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584035/4946246/29

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/30

-----------------------------------------------------------------------
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/5584031/4946246/31

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

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

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

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

NEW DISCUSSION on:
Java User Profile Usage

DISCUSSION from Hendi:
if i don't misunderstand your question, you are asking about how the java
program access the user profile in as/400 native. You can use JT/400. it
provides a lot of class that can be used for accessing as/400 object including
user profile, etc
-Hendi

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584015/4946246/36

-----------------------------------------------------------------------
NEW DISCUSSION on:
INSTR ()

DISCUSSION from Inprise:
Hi Both,

As said earlier my test case s working fine using both instr() and like
operator howver not thrwoing error while exceuting thru my procedure

yes it s in the range of error messages only,all error messages all different
procedures are catched n err_pkg() only

Is this cud be a orac...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584029/4946246/37

-----------------------------------------------------------------------
NEW QUESTION on:
how to print selected data in data report using vb 6

QUESTION from It3ckat:
we were about to create a system that generate eport such as daily weekly
monthly and annual...
and we dont know how to do it.. plz.. help us..

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584078/4946246/38

-----------------------------------------------------------------------
UPDATED ANSWER on:
Puzzle - Find the number?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584040/4946246/39

-----------------------------------------------------------------------
UPDATED ANSWER on:
Need SQL query

ANSWER from Msi77:
You want a query like this then.

[CODE]SELECT Detail.ProjectDetail
FROM Detail
JOIN User on Detail.ProjectId = User.ProjectId
AND User.UserId = TT15[/CODE]

As I understood, Minuvinu needs a comma-separated list.
Here the sketch of solution (MS SQL 2005):

[CODE]select userid, (select...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584032/4946246/40

-----------------------------------------------------------------------
NEW QUESTION on:
A Smart Developer

QUESTION from AmjadM:
I have been out of touch from VB Programming for a long long time.

In front of me is a task and I am ambitious about doing it in a quick & smart
way.

I work for a small businessman (a shop keeper) who buys Steel wireropes from
wholesalers & sells it as a retailer.

Currently he has a manual ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584037/4946246/41

-----------------------------------------------------------------------
NEW DISCUSSION on:
ASP getting increasing

DISCUSSION from Mcl:
You can clean up a file with the RGZPFM command - but not when the file is in
use.

Spooled files will take up space - or at least allocate space. Delete what you
don't need and run the RCLSPLSTG command.

You should also run the RCLSTG command - but you'll need the system in a
restricted stat...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584021/4946246/42

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/43

-----------------------------------------------------------------------
NEW DISCUSSION on:
COPY data between to files with SQL in iSeries

DISCUSSION from Philpl1jb:
Martin's answer is excellent.
CPYF will do lots of good stuff and doesn't need SQL.
It can do stuff like select records (where)
But if you need SQL.

Here is the trick --
Assuming that you haven't defined column FieldC to allow null.
Typically you won't want AS/400 columns to allow null...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584024/4946246/44

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

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

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

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/46

-----------------------------------------------------------------------
MICROSOFT WINDOWS UPDATES
-----------------------------------------------------------------------

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

View all Microsoft Windows related Questions and Answers
http://go.techtarget.com/r/5584052/4946246/47
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Copy Outlook Express emails to Microsoft Word

DISCUSSION from Alec:
Hello Nathan,

re. Copy Outlook Express emails to Microsoft Word

Many thanks Nathan for such a quick and helpful answer - dated Jan 13 2009.

I have done as you suggest for copying the emails and it works fine but
unfortunately the second part of your answer on copying the photographs seems
...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584044/4946246/48

-----------------------------------------------------------------------
UPDATED ANSWER on:
Puzzle - Find the number?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584040/4946246/49

-----------------------------------------------------------------------
NEW QUESTION on:
migration of Crystal Reports 8 to Crystal Reports 2008

QUESTION from Kln:
How to migrate Crystal Reports 8.0 to Crystal Reports 2008?
The crystal reports which had stored procedures of 8.0 are not executing in
2008, can anyone help? Thanks

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584053/4946246/50

-----------------------------------------------------------------------
NEW ANSWER on:
Do I Need Active Directory?

ANSWER from Labnuke99:
No - AD is not necessary. You can create local user accounts. Although, if the
users have accounts in AD why would you want to manage separate credentials for
this term server?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584054/4946246/51

-----------------------------------------------------------------------
UPDATED ANSWER on:
How do I install Vista on a Windows XP machine, or can it be done.

ANSWER from NetSupport:
Depends on the program. Most applications were created for Windows XP and made
compatible to Windows Vista, if the application is only Vista compatible and
you are not able to install it on XP, then it won't work for you.

Sounds lkie you want to dual boot XP and Vista. If so look at: http://vis...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584055/4946246/52

-----------------------------------------------------------------------
NEW DISCUSSION on:
Problems after installing fresh copy of Windows XP

DISCUSSION from Pressler2904:
If what you are saying is that you've used the same source disk to install
WinXP on two different systems (and I won't even get in to the possible legal
issues here!!!!), and that it works OK on one system but not OK on a different
system, ask the classical troubleshooting question, "What Changed...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584056/4946246/53

-----------------------------------------------------------------------
NEW ANSWER on:
GPO to stop users from changing system clock on their workstations.

ANSWER from Rickjr13:
Go to the GPO you created or will create for it and change the following
setting:

Computer ConfigurationWindows SettingsSecurity SettingsLocal PoliciesUser
Rights Assignment

"Change the system time" Setting

Enable it and set it so only admins and change the time.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584057/4946246/54

-----------------------------------------------------------------------
NEW DISCUSSION on:
Citrix Metaframe XP management console unavailable

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584042/4946246/55

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 virtual machine in VMware ESXi server?

QUESTION from ITKE:
Can I install a virtual machine in Windows Server 2008 Ent x64 Edition which is
a VM in VM
Ware ESXi server?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584058/4946246/56

-----------------------------------------------------------------------
NEW ANSWER on:
Can I create one Domain Controller for 1000 Users

ANSWER from Mshen:
It is recommended to have at least two domain controllers for fault tolerance
with every active directory deployment. Just having one domain controller is
not a good idea. DC's don't need to be very beefy, so you can get by with
basic server configurations. For 1000 users, I would recommend 2 to ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584059/4946246/57

-----------------------------------------------------------------------
NEW QUESTION on:
Licensing issues in virtualized environments

QUESTION from SearchServerVirtualization ATE:
[I]This answer submitted by virtualization expert Eric Siebert:[/I]

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584043/4946246/58

-----------------------------------------------------------------------
NEW QUESTION on:
PowerPoint checkboxes

QUESTION from Flame:
This [A href="http://pptheaven.mvps.org/animations.html"]site[/A] has some good
tutorials on making animations in PowerPoint. This [A
href="http://video.about.com/presentationsoft/PowerPoint-Animations.htm"]video[/
A] shows a variety of methods for using animations.
Good Luck!
-Flame

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584060/4946246/59

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/60

-----------------------------------------------------------------------
MOBILE 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/5584031/4946246/61

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

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

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

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

NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/66

-----------------------------------------------------------------------
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/5584031/4946246/67

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

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

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

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

NEW DISCUSSION on:
Is it necessary to be connected to sniff traffic over a wired network?

DISCUSSION from Rahul Shrivastava:
Actually the objective is that there should be no sniffing on a particular link
which connects the firewall to the switch. Any suggestions?

cheers. rahul.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584061/4946246/72

-----------------------------------------------------------------------
NEW QUESTION on:
Reconfiguring network switches as 802.1q VLAN trunks for VMware ESX
implementation

QUESTION from NetworkingATE:
My data center network switches are configured as access ports, but we are soon
implementing VMware ESX. Is there an easy way to reconfigure the switches to
operate as 802.1q VLAN trunks to take advantage of VMware's VLAN management
support?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584062/4946246/73

-----------------------------------------------------------------------
NEW DISCUSSION on:
WAN design and implementation

DISCUSSION from KevinBeaver:
I had a client that recently put a similar network in place. Regarding the WAN,
you can do something as fancy as Frame/MPLS/T1/etc. between sites and then run
the remote facilities' Internet access through the main office. Or you could
get something as inexpensive as independent business DSL Intern...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584063/4946246/74

-----------------------------------------------------------------------
NEW DISCUSSION on:
Problems after installing fresh copy of Windows XP

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584056/4946246/75

-----------------------------------------------------------------------
NEW ANSWER on:
Can I create one Domain Controller for 1000 Users

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584059/4946246/76

-----------------------------------------------------------------------
NEW QUESTION on:
iSCSI SAN how many IP Addresses are needed?

QUESTION from ITKE:
We are planning to implement an iSCSI SAN. There are 4 controllers, each
with 2 iSCSI ports. How many IP addresses are needed for the ISCSI SAN

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584064/4946246/77

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/78

-----------------------------------------------------------------------
NEW ANSWER on:
Configuring Netgear WGT624 Router with Acer Aspire Netbook

ANSWER from Flame:
Tha manual for your Netgear router is located [A
href="http://www.ebookspdf.com/computers/4300/netgear-wgt624-user-manual/"]here[
/A]. The support page from Netgear is [A
href="http://kbserver.netgear.com/products/WGT624.asp"]here[/A]. I would
disable all security on your router and computer, then ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584065/4946246/79

-----------------------------------------------------------------------
ORACLE UPDATES
-----------------------------------------------------------------------

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

View all Oracle related Questions and Answers
http://go.techtarget.com/r/5584026/4946246/80
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW QUESTION on:
PL/SQL Insert

QUESTION from Inprise:
Hi Experts,

I am trying to do 2 INSERT stms on 2 tables consecutively n same transaction
and my first insert is successful
while doing the insert on second table which is completely carry same set of
attibutes and values of 1st table + 1 additional static value attribute,it
gives ORA :01400 e...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584027/4946246/81

-----------------------------------------------------------------------
NEW QUESTION on:
oracle form

QUESTION from Nomanjahangirbutt:
what is object library ?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584028/4946246/82

-----------------------------------------------------------------------
NEW DISCUSSION on:
INSTR ()

DISCUSSION from Inprise:
Hi Both,

As said earlier my test case s working fine using both instr() and like
operator howver not thrwoing error while exceuting thru my procedure

yes it s in the range of error messages only,all error messages all different
procedures are catched n err_pkg() only

Is this cud be a orac...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584029/4946246/83

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/84

-----------------------------------------------------------------------
UPDATED ANSWER on:
Oracle connectivity with Oracle Forms 6i

ANSWER from Carlosdl:
This would be the host name set up in your tnsnames.ora file in the
Oracle_Homenetworkadmin folder. it would look something like below. In this
example, you would use MYDB to reference the serve
r named OracleServer and SID named ORCL

MYDB =
(DESCRIPTION =
(ADDRESS =
(PRO...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584030/4946246/85

-----------------------------------------------------------------------
SAP 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/5584031/4946246/86

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

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

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

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

NEW QUESTION on:
Cancelling Measurement Document in SAP ERP

QUESTION from Sachan:
Can I cancel the several Measurement Documents by setting Reversal indicator,
in bulk? If yes, how?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584088/4946246/91

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/92

-----------------------------------------------------------------------
SECURITY 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/5584031/4946246/93

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

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

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

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

NEW DISCUSSION on:
Is it necessary to be connected to sniff traffic over a wired network?

DISCUSSION from Rahul Shrivastava:
Actually the objective is that there should be no sniffing on a particular link
which connects the firewall to the switch. Any suggestions?

cheers. rahul.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584061/4946246/98

-----------------------------------------------------------------------
NEW ANSWER on:
Do I Need Active Directory?

ANSWER from Labnuke99:
No - AD is not necessary. You can create local user accounts. Although, if the
users have accounts in AD why would you want to manage separate credentials for
this term server?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584054/4946246/99

-----------------------------------------------------------------------
UPDATED ANSWER on:
any solution for this virus/spyware

ANSWER from Hendi:
I agree with Jenny.

I would download and install [A
href="http://www.safer-networking.org/en/download/"]Spybot Search &
Destroy[/A], and some other anti-malware software, such as [A
href="http://www.malwarebytes.org/mbam.php"]Malwarebytes[/A].

Update both of them, reboot in safe mode (without ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584066/4946246/100

-----------------------------------------------------------------------
NEW ANSWER on:
HALLMARK VIRUS ATTACK

ANSWER from Labnuke99:
This is an old attack but maybe with a new malicious payload. I would recommend
blocking all EXE's on your Exchange system. Tell users not to open this type of
message even in their personal email accounts. Check out this [A
href="http://search.mcafee.com/search?q=hallmark&site=us_site.Virus&num=10&...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584045/4946246/101

-----------------------------------------------------------------------
NEW DISCUSSION on:
Adding a password to a SQL Server 2005 database

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584033/4946246/102

-----------------------------------------------------------------------
NEW QUESTION on:
Exchange Server 2007 CCR moving users

QUESTION from ITKE:
2 Exchange 2007 servers
Just purchased 4 new servers and setup the CCR cluster. 2 servers are running
roles in a NLB cluster setting and 2 are in the mailbox role. Using ISA Server.
What is the best way to move the mailboxes to the new servers?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584048/4946246/103

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/104

-----------------------------------------------------------------------
NEW ANSWER on:
Configuring Netgear WGT624 Router with Acer Aspire Netbook

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584065/4946246/105

-----------------------------------------------------------------------
SQL SERVER 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/5584031/4946246/106

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

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

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

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

UPDATED ANSWER on:
Need SQL query

ANSWER from Msi77:
You want a query like this then.

[CODE]SELECT Detail.ProjectDetail
FROM Detail
JOIN User on Detail.ProjectId = User.ProjectId
AND User.UserId = TT15[/CODE]

As I understood, Minuvinu needs a comma-separated list.
Here the sketch of solution (MS SQL 2005):

[CODE]select userid, (select...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584032/4946246/111

-----------------------------------------------------------------------
NEW QUESTION on:
Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

QUESTION from Warykat:
I am successfully using (external) stored procedures with many RPGLE programs.
(Some of these are SQLRPGLE programs because they return a result set.)
All of this works fine.

But if I try to replace some of the RPG I/O in a RPGLE program with embedded
SQL,
creating a SQLRPGLE program, and run ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584019/4946246/112

-----------------------------------------------------------------------
NEW DISCUSSION on:
Adding a password to a SQL Server 2005 database

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584033/4946246/113

-----------------------------------------------------------------------
NEW DISCUSSION on:
Creating tables on a SQL Server

DISCUSSION from Kccrosser:
A couple of things come to mind.

You say there are 4816 business "categories". (That seems pretty large,
but...) My strong suspicion is that any given business could belong in more
than one "category" - especially if it is broken down that far. I would be
looking at a database structure wi...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584034/4946246/114

-----------------------------------------------------------------------
NEW ANSWER on:
Duplicating records in a table with a SQL query

ANSWER from Carlosdl:
You could do it this way:

[CODE]INSERT INTO YourTable
SELECT *
FROM YourTable
GO[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584035/4946246/115

-----------------------------------------------------------------------
NEW ANSWER on:
Adding an index on fields in a SQL Server table

ANSWER from Carlosdl:
Yes, you can.

You should consider creating indexes on columns that are frequently used in the
WHERE ( and ORDER BY, and GROUP BY ) clause of queries.

Fields with low selectivity (such as gender) are not good candidates for
indexing.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5584036/4946246/116

-----------------------------------------------------------------------
NEW QUESTION on:
A Smart Developer

QUESTION from AmjadM:
I have been out of touch from VB Programming for a long long time.

In front of me is a task and I am ambitious about doing it in a quick & smart
way.

I work for a small businessman (a shop keeper) who buys Steel wireropes from
wholesalers & sells it as a retailer.

Currently he has a manual ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584037/4946246/117

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/118

-----------------------------------------------------------------------
NEW QUESTION on:
Hiding the system views table from Microsoft Access

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584038/4946246/119

-----------------------------------------------------------------------
NEW QUESTION on:
Decreasing the unused space of a SQL Server table

QUESTION from SQL Server Ask the Experts:
How can I decrease the unused space of a SQL Server table which is indexed?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584039/4946246/120

-----------------------------------------------------------------------
NEW DISCUSSION on:
COPY data between to files with SQL in iSeries

DISCUSSION from Philpl1jb:
Martin's answer is excellent.
CPYF will do lots of good stuff and doesn't need SQL.
It can do stuff like select records (where)
But if you need SQL.

Here is the trick --
Assuming that you haven't defined column FieldC to allow null.
Typically you won't want AS/400 columns to allow null...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584024/4946246/121

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

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

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

NEW DISCUSSION on:
Raid 0 Set up internal to external drive

DISCUSSION from Williamsson:
Sorry for the lack of info, I have a built in Intel ICH9R SATA RAID controller.
However I did some checking online and found a blog from another xps 420 owner
and they tryed to do the samething "using the eSATA port" and looks like they
ran in to a issue. They had to reinstall there operating syst...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584068/4946246/123

-----------------------------------------------------------------------
NEW QUESTION on:
iSCSI SAN how many IP Addresses are needed?

QUESTION from ITKE:
We are planning to implement an iSCSI SAN. There are 4 controllers, each
with 2 iSCSI ports. How many IP addresses are needed for the ISCSI SAN

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584064/4946246/124

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/125

-----------------------------------------------------------------------
VIRTUALIZATION 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/5584031/4946246/126

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

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

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

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

NEW QUESTION on:
Reconfiguring network switches as 802.1q VLAN trunks for VMware ESX
implementation

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584062/4946246/131

-----------------------------------------------------------------------
NEW DISCUSSION on:
Citrix Metaframe XP management console unavailable

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584042/4946246/132

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 virtual machine in VMware ESXi server?

QUESTION from ITKE:
Can I install a virtual machine in Windows Server 2008 Ent x64 Edition which is
a VM in VM
Ware ESXi server?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584058/4946246/133

-----------------------------------------------------------------------
NEW QUESTION on:
Licensing issues in virtualized environments

QUESTION from SearchServerVirtualization ATE:
[I]This answer submitted by virtualization expert Eric Siebert:[/I]

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584043/4946246/134

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/135

-----------------------------------------------------------------------
VOIP 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/5584031/4946246/136

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

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

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

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

NEW QUESTION on:
unified root - domain issue - an expert question.

QUESTION from Ozgurs:
We want to buy a unified root domain,
but they say we can not use the domain only one word.
like
ozgurs

so that it opens
http://ozgurs

but we have to use a connected word to this TLD, like
example.ozgurs

here, my quetion comes! :)

i bet with my friend that we can not use the domai...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5584069/4946246/141

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the most overused tech buzzwords for 2008?

DISCUSSION from Leah Rosin:
SaaS, virtualization, and cloud computing top my list.

Web 2.0 is also noteable, but maybe I just didn't "hear" it as much this year
as those above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5584023/4946246/142

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

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

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

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.