Daily Question and Answer Update for Jan 27, 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/5683878/4946246/1

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

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

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

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

NEW ANSWER on:
SIP for contact centers

ANSWER from ITKE:
I would suggest reading some [A
href="http://www.bitpipe.com/rlist/term/SIP.html"]whitepapers on SIP [/A] It is
a good starting point and depending on your specific situation will help.

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

-----------------------------------------------------------------------
DATABASE 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/5683878/4946246/7

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

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

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

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

NEW DISCUSSION on:
Access/Word Mail Merge Currency lost digits

DISCUSSION from Msi77:
Try the formula field in Word.
It may look like
{ =12345.23 # "$# ##0.00;($# ##0.00)" }

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683913/4946246/12

-----------------------------------------------------------------------
UPDATED ANSWER on:
Need help with Oracle query

ANSWER from Carlosdl:
Select Top 1 * From (Select Top 3 * From EmployeeTable Order By Salary)
Order By Salary Desc

Another way to do this would be to use the rank functionality (which will bring
back all employees that have the 3rd highest salary, where employees might have
the same salary):

select employee, sal...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683869/4946246/13

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

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

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

NEW DISCUSSION on:
VMware ESX 3.5 not able to create a new datastore

DISCUSSION from Mshen:
When you go to the server configuration tab, what do you see? Is the drive
listed OR can you add it?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683881/4946246/15

-----------------------------------------------------------------------
NEW ANSWER on:
Moving Virtual Machines off and on server - VMware ESX 3.5

ANSWER from Mshen:
If you have a second host, you need to use Virtual Center Server which is
$5,000 for the license. It does, however, have a 60 day trial. Otherwise you
can use Virtual Center Backup to backup snapshots of the machines and restore
them on a second server, then restore them back to the original serve...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683882/4946246/16

-----------------------------------------------------------------------
UPDATED ANSWER on:
Data erasing solutions?

ANSWER from Kutu:
EBAN is a enterprise version of dban and widely used open source data removal
and destruction software. I would recommend DBAN if cost is an issue. DBAN will
wipe the harddrive clear of any data on them by writing over the disk multiple
times with 1s and 0s. I wrote a review on [A href="http://anal...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683883/4946246/17

-----------------------------------------------------------------------
NEW QUESTION on:
Disk failed in RAID 5 Dell Poweredge 4400 can i create new container

QUESTION from ITKE:
I have a server Dell Poweredge 4400. Windows 2000 server running a
RAID 5 with 4 disks. One of the disks has failed due to a container being
deleted. If I create a new container and put the remaining 3 drives in it will
I lose the data on them? Any suggestions for a proper recovery/rebuild?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683884/4946246/18

-----------------------------------------------------------------------
DATAMANAGEMENT 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/5683878/4946246/19

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

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

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

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

NEW QUESTION on:
CRYSTAL REPORTS 8.5 AND VISTA COMPATIBLIITY

QUESTION from HATCHT:
I am currently running Crystal Reports on XP pro. All the computers in the Gov
is switching to VISTA, Is this version of Crystal Reports going to run on
Vista?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683935/4946246/24

-----------------------------------------------------------------------
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/5683878/4946246/25

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

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

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

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

NEW DISCUSSION on:
SQL/400

DISCUSSION from Gilly400:
Hi,

If you can, you should change those users to non-*SECOFR profiles. *SECOFR is
only meant to be used by people for security management purposes.

If you're stuck with this situation, you may be able to restrict the people
using STRSQL by creating your own STRSQL command higher in the (syst...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Outlook 2003: trim leading spaces from email subject with VBA macro

DISCUSSION from Slay:
This may be relevant, we are using Outlook in Cached Exchange mode.

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

-----------------------------------------------------------------------
NEW QUESTION on:
SQL query

QUESTION from Lakshya412:
Hi

I have the following tables

sales_header table with fields
sh_pk number(9,0) this it the primary key
date_of_sale date
customer_name varchar2(30)
sale_number number(9,0) this is the primary key

sales_detail table w...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683936/4946246/32

-----------------------------------------------------------------------
NEW ANSWER on:
Pulling multiple values in the same line in SQL

ANSWER from Mrdenny:
Doing this requires the use of a function. Something like this.

[CODE]CREATE FUNCTION YourFunction (@UserId varchar(10))
RETURNS VARCHAR(4000)
BEGIN
DECLARE @Return VARCHAR(4000)

SET @Return = ''

DECLARE @error_code VARCHAR(10)

DECLARE cur CURSOR FOR SELECT Error_code FROM You...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683871/4946246/33

-----------------------------------------------------------------------
UPDATED ANSWER on:
Java language issue

ANSWER from YuvalShavit:
First, we should clarify that a language doesn't use a compiler or an
interpreter: a compiler or interpreter uses a language to translate source code
into actions (if it's interpreted) or instructions (if it's compiled). In
theory, you could write a compiler for JavaScript or an interpreter for C.
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683903/4946246/34

-----------------------------------------------------------------------
UPDATED ANSWER on:
Data erasing solutions?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683883/4946246/35

-----------------------------------------------------------------------
NEW ANSWER on:
Toggle button

ANSWER from YuvalShavit:
Instead of making two buttons, why not make one button that toggles its state?
You can use the current caption to see what state it was in when it was
clicked, and take the appropriate actions -- including switching the caption.
Eg:

[CODE]Option Explicit

Const BTN_CAP_NEW As String = "New"
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683937/4946246/36

-----------------------------------------------------------------------
NEW ANSWER on:
How to extract the IP address of a data packet and store it in the database?

ANSWER from Kutu:
is the server window, linux sun?

If it's a SUN server just use snoop. Type snoop at the command prompt and it
will show you the packets as they pass through the server. Use grep to narrow
things down a bit.

If it's a linux box use tcpdump at the command prompt

If it's a windows server use w...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683926/4946246/37

-----------------------------------------------------------------------
NEW DISCUSSION on:
Help a beginner! What is wrong with this VBScript code?

DISCUSSION from Carlosdl:
What problems are you having ?
Are you getting errors ? what is the error message ?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683938/4946246/38

-----------------------------------------------------------------------
LINUX 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/5683878/4946246/39

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

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

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

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

UPDATED ANSWER on:
Java language issue

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683903/4946246/44

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to use Linux printer in Windows?

ANSWER from Fctoma:
A better way to get the Linux print files over to Windows is to install RPM. We
have many clients that still use UNIX/Linux for their printing but we install
RPM on the Windows side allowing the Linux print files to easily be printed on
the Windows side, using a less expensive Windows desktop printe...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683904/4946246/45

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

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

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

UPDATED ANSWER on:
AS400

ANSWER from Gilly400:
I'm having trouble finding an easy way to do what you want.
1. Get a list of devices DSPOBJD OBJ(*ALL) OBJTYPE(*DEVD) can be output to a
datafile
2. A CL program loops through all the devices
2.1. if the device is a printer or a terminal
2.1.1 for printer devices the RTVDEVPR...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683851/4946246/47

-----------------------------------------------------------------------
NEW QUESTION on:
what are the similarities in cisco and hp procurve switching protocols ?

QUESTION from Henno:
like layer 2 protocol in cisco called VTP , while in hp procurve is called GARP
, I need to know the other similarities in both for layer 2,3

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683906/4946246/48

-----------------------------------------------------------------------
NEW QUESTION on:
Using VPN with VISTA

QUESTION from HATCHT:
I work from home using a VPN, and remote desktop, I was wondering if anyone
has any knowlegde of any problems running a VPN, to remote desktop, with VISTA?
I am currently using XP pro.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683907/4946246/49

-----------------------------------------------------------------------
NEW QUESTION on:
Migration of contents to Other Sites

QUESTION from Naga00:
Is it possible to migrate the Discussion Board contents directly to other
site/sub-sites?

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

-----------------------------------------------------------------------
NEW ANSWER on:
Message stuck in Exchange SMTP Categorizer

ANSWER from David Sengupta:
See: http://support.microsoft.com/kb/952841

David

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

-----------------------------------------------------------------------
NEW ANSWER on:
How to share outlook folder with another user in Exchange 2007 ?

ANSWER from David Sengupta:
See: http://office.microsoft.com/en-us/outlook/HA011134811033.aspx

David

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

-----------------------------------------------------------------------
NEW ANSWER on:
Can calendar info (free/busy) time be shared between Exchange servers in 2
different domains?

ANSWER from David Sengupta:
See http://msexchangeteam.com/archive/2008/12/04/450228.aspx

David

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683888/4946246/53

-----------------------------------------------------------------------
UPDATED ANSWER on:
can't open ifs doc

ANSWER from Findsarfaraz:
As you describe your issue, I can make out following causes which can make this
issue happen.
The network drive which is mapped is disconnected. Have you tried the following
steps

Click on Start->Run->type \System Name$DrivenameFolder NameFilename
Click on Ok

Also, try remapping t...

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

-----------------------------------------------------------------------
NEW ANSWER on:
post installation word problems

ANSWER from Findsarfaraz:
This issue happens when Word is not completely installed or during installation
you have choosen certain components to install on first run. If you are
consistently facing this issue, I would request you to reinstall word and
during installation choose complete install. I am sure this will resolve y...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683909/4946246/55

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server 2005 Memory

ANSWER from Mrdenny:
How big is the database?
What edition or SQL are you running ( Developer since you are running XP and
Express only uses 1 Gig of RAM)?
How much RAM do you have?

Odds are the database server needs more RAM than you have available.

The Developer edition of SQL Server can only use 2 Gigs of R...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683872/4946246/56

-----------------------------------------------------------------------
NEW ANSWER on:
Shortening the generation time for a SQL Server 2000 report

ANSWER from Mrdenny:
Are your functions accessing tables when running? It so stop using the
functions, or pass in all the needed data to the function so that the function
does not need to go to the tables.

When you use a SQL function in a SELECT statement, and that function runs
queries of its own the SELECT stateme...

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

-----------------------------------------------------------------------
NEW QUESTION on:
configure DHCP over VLAN's windows server 2003

QUESTION from ITKE:
My question is how to configure DHCP over VLAN's.
At present in my company DHCP is running without any VLAN's setup but know as
our network extend and also for the security reasons i want to implement VLAN's
in the switch. Then what about my DHCP how it works, what is the configuration
requirement...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Registry editing

DISCUSSION from Carlosdl:
As Technochic said, you should not take care of that.

On the other hand, there is no need to copy registry settings in order to be
able to log on to the network with the new computer. Basically, two things are
needed:

- Join the computer to the domain
- a valid domain user account, which you...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683911/4946246/59

-----------------------------------------------------------------------
NEW ANSWER on:
32 bit to 64 bit oracle 10g

ANSWER from Apickel:
no.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683868/4946246/60

-----------------------------------------------------------------------
UPDATED ANSWER on:
Desktop computer stays on about 2 seconds then shuts off

ANSWER from Carlosdl:
Who is the manufacturer of your computer? I would call their support line if it
is under warranty. You will probably need to open the case and remove all pci
cards and all but one memory module to start with. Try booting, and if
successful add one card or memory module in at a time and again see if ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683912/4946246/61

-----------------------------------------------------------------------
NEW DISCUSSION on:
Access/Word Mail Merge Currency lost digits

DISCUSSION from Msi77:
Try the formula field in Word.
It may look like
{ =12345.23 # "$# ##0.00;($# ##0.00)" }

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683913/4946246/62

-----------------------------------------------------------------------
NEW QUESTION on:
Similar Microsoft/SAS/Wireless Issue that has my IT department stumped - HELP!

QUESTION from Labnuke99:
Update your hardware drivers. Check with the hardware manufacturer to see if
they have anything shown on their technical support forums or knowledgebase. We
had some users that had difficulties with VPN connection stability over
wireless and once they upgraded their drivers, the problem went away.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683914/4946246/63

-----------------------------------------------------------------------
NEW DISCUSSION on:
"Accept" not showing up in "Tracking

DISCUSSION from Technochic:
Does this involve an exchange server? If so what version and patch level?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683895/4946246/64

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to use Linux printer in Windows?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683904/4946246/65

-----------------------------------------------------------------------
NEW QUESTION on:
InstallUtil for Registering Windows Service

QUESTION from CR1:
I have a peculiar requirement to install the same application as a Windows
Service but with
4 separate instantiations of it (as a Windows Service on the same machine) as
different service names. The reasons are too complicated to go into.

Anyway, the basic installation is c:Program FilesApp Nam...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683915/4946246/66

-----------------------------------------------------------------------
NEW QUESTION on:
Disk failed in RAID 5 Dell Poweredge 4400 can i create new container

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683884/4946246/67

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Office License on Citrix

ANSWER from KarlG:
last time I checked, Office applications are licensed by desktop. What this
means is that if you've got an Office Excel 2003 license (for example) for a
local installation of Excel 2003 on your PC, then any other Office Excel 2003
that starts up on your desktop (whether via Citrix, Terminal Server, ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683916/4946246/68

-----------------------------------------------------------------------
UPDATED ANSWER on:
Windows XP - Workgroups - awaken computer remotely from standby

ANSWER from KarlG:
[A href="http://www.depicus.com/wake-on-lan/wake-on-lan-cmd.aspx"]Wake on Lan
Command Line [/A]

The command line tool wolcmd is run from a dos prompt. The syntax is as
follows:

wolcmd [mac address] [ip address] [subnet mask] [port number]

you can also do a local broadcast if you are running...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683917/4946246/69

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to export data from AS/400 into Microsoft Excel

DISCUSSION from Pcatlin:
Phil is right... Users that need to refresh the data will need to setup the
data source..

Another option:
You can save the sheet with the data. Future users can use the iSeries data,
but without setting up the data source they would not be able to refresh it.

Not setting up the data source...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683865/4946246/70

-----------------------------------------------------------------------
NEW QUESTION on:
ISA Server 2006 cant authenticate Windows Server 2008 Doman controller

QUESTION from ITKE:
My domain level is windows server 2003 full edition, I have 2 DC, one with
fsmo is a windows server 2003 the other is a windows server 2008. The windows
server 2008 has been upgraded from windows server 2003 a few month ago and has
been working fine..

Recently isa server 2006 was restarted and d...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683918/4946246/71

-----------------------------------------------------------------------
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/5683878/4946246/72

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

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

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

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

UPDATED ANSWER on:
Copies of emails

ANSWER from David Sengupta:
Check the message tracking ID of each of the duplicate messages. Are the IDs
unique, or different?

David

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683889/4946246/77

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remote Printing Problem

DISCUSSION from LBurkett99:
You say your users connect to the AS/400 using emulation. Do you have printer
emulation, or display emulation only. What you describe is LPR/LPD printing
and I assume the IP address you are using is the printer's and not a
workstation.

If you have printer emulation, you may find its use to be ...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Manage Mobile Device (options) via OWA

ANSWER from Technochic:
The "Mobile Devices" option is for Windows Mobile Devices. Blackberries are not
windows mobile devices. That is why it will not show under "mobile devices".
You are correct. To get the tools for the blackberry you would need to install
a Blackberry Enterprise Server (BES), pay the license fee for th...

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

-----------------------------------------------------------------------
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/5683878/4946246/80

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

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

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

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

NEW QUESTION on:
what are the similarities in cisco and hp procurve switching protocols ?

QUESTION from Henno:
like layer 2 protocol in cisco called VTP , while in hp procurve is called GARP
, I need to know the other similarities in both for layer 2,3

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683906/4946246/85

-----------------------------------------------------------------------
NEW QUESTION on:
Using VPN with VISTA

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683907/4946246/86

-----------------------------------------------------------------------
NEW ANSWER on:
How many switches can you have in a network?

ANSWER from Sudhanshu:
I don't think there is any limitation in the number of switches you can put in
a network; however, you need to consider complexity, added delays,
connectivity, and port density when you calculate the number of switches you
want in your network. The more switches you have, the more chances there are
...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683919/4946246/87

-----------------------------------------------------------------------
NEW ANSWER on:
What is a non-routable VLAN? Why would you use one?

ANSWER from Sudhanshu:
As the name explains "non-routable VLAN" is a virtual LAN that you cannot
route. VLANs are by default Layer 2, restricting the broadcast domain. If you
create a VLAN it will be Layer 2 until the time you assign an IP address to it,
which makes it routable.

You are right in saying that it's a VLAN...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683920/4946246/88

-----------------------------------------------------------------------
NEW ANSWER on:
Why use Layer 3 switches and how do they differ from Layer 2 switches?

ANSWER from Sudhanshu:
Layer 3, or L3, switches forward packets based on Layer 3 address, which is IP
address. Layer 2, or L2, switches forward packets based on data-link layer,
which is MAC address. An L3 switch is basically used to efficiently route
inter-VLAN traffic or to do internal routing between multiple broadcast...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683921/4946246/89

-----------------------------------------------------------------------
NEW QUESTION on:
configure DHCP over VLAN's windows server 2003

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683910/4946246/90

-----------------------------------------------------------------------
NEW DISCUSSION on:
new career

DISCUSSION from Robert Stewart:
Try your local Community College, most have an AS degree in IT. Spend your
first two years there, most will offer Cisco, some Linux,/Unix, along with
other IT classes and at a fraction of the cost mentioned above.

Then if you want you can turn the AS degree into a BS degree at a larger
universit...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683922/4946246/91

-----------------------------------------------------------------------
NEW QUESTION on:
Similar Microsoft/SAS/Wireless Issue that has my IT department stumped - HELP!

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683914/4946246/92

-----------------------------------------------------------------------
UPDATED ANSWER on:
Outlook web access needs to be accesible via the internet with Exchange 2007
and Outlook 2007

ANSWER from Technochic:
Here is a [A
href="http://www.microsoft.com/downloads/details.aspx?FamilyID=EE292C13-C933-4F5
9-91D9-16E4B38F5E34&displaylang=en"]useful guide[/A] to download.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683896/4946246/93

-----------------------------------------------------------------------
NEW ANSWER on:
Connecting to a Real VNC server accross the internet

ANSWER from Labnuke99:
Sounds like some kind of network address translation (NAT) or port address
translation (PAT) is happening at your network edge. Do you manage the firewall
on the network where the host machine is located? If so, you will need to
either map a port/IP address pair to the host machine or setup a mapped...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683923/4946246/94

-----------------------------------------------------------------------
UPDATED ANSWER on:
Network monitoring tools

ANSWER from Kutu:
Check out [A href="http://www.splunk.com/"]SPLUNK[/A].

Also see [A href="http://www.logwatch.org/"]logwatch[/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683924/4946246/95

-----------------------------------------------------------------------
UPDATED ANSWER on:
Data link layer monitoring

ANSWER from Kutu:
The Data Link Layer refers to "Layer 2" in the [A
href="http://en.wikipedia.org/wiki/OSI_model"]OSI model [/A]. I assume when you
say monitoring you mean a "Sniffer" to watch traffic at layer two. There are a
number of them out there that are great and sometimes very useful, called [A
href="http://w...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683925/4946246/96

-----------------------------------------------------------------------
NEW ANSWER on:
How to extract the IP address of a data packet and store it in the database?

ANSWER from Kutu:
is the server window, linux sun?

If it's a SUN server just use snoop. Type snoop at the command prompt and it
will show you the packets as they pass through the server. Use grep to narrow
things down a bit.

If it's a linux box use tcpdump at the command prompt

If it's a windows server use w...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683926/4946246/97

-----------------------------------------------------------------------
UPDATED ANSWER on:
Windows XP - Workgroups - awaken computer remotely from standby

ANSWER from KarlG:
[A href="http://www.depicus.com/wake-on-lan/wake-on-lan-cmd.aspx"]Wake on Lan
Command Line [/A]

The command line tool wolcmd is run from a dos prompt. The syntax is as
follows:

wolcmd [mac address] [ip address] [subnet mask] [port number]

you can also do a local broadcast if you are running...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683917/4946246/98

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

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

View all Networking related Questions and Answers
http://go.techtarget.com/r/5683867/4946246/99
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
32 bit to 64 bit oracle 10g

ANSWER from Apickel:
no.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Need help with Oracle query

ANSWER from Carlosdl:
Select Top 1 * From (Select Top 3 * From EmployeeTable Order By Salary)
Order By Salary Desc

Another way to do this would be to use the rank functionality (which will bring
back all employees that have the 3rd highest salary, where employees might have
the same salary):

select employee, sal...

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

-----------------------------------------------------------------------
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/5683878/4946246/102

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

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

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

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

NEW QUESTION on:
installation of SAP IDES

QUESTION from Komkom:
hi i waint know how to installe SAP IDES4.7 in extern HD.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683946/4946246/107

-----------------------------------------------------------------------
NEW ANSWER on:
which SAP certification will help my MBA in HRM?

ANSWER from ITKE:
I would browse the other [A
href="http://itknowledgeexchange.techtarget.com/itanswers/tag/sap-certifications
/"]SAP Certification questions.[/A] There are some good answers that may
address your question.

Also the certification section on [A
href="http://searchsap.techtarget.com/topics/0,295493,si...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683947/4946246/108

-----------------------------------------------------------------------
NEW QUESTION on:
Is getting custom SAP development from other clients feasible?

QUESTION from Chrisb2bsx:
When so many companies are aggressively trying to reduce their costs, getting
more for less, is there an opportunity to leverage the custom SAP solutions
already developed? Like an "eBay" for custom development?
Thank you,
Chris Young
B2BSX

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683948/4946246/109

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

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

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

UPDATED ANSWER on:
How do I encrypt an email?

ANSWER from Modes:
The way typical email encryption works is that you have a public key and a
private key (this sort of encryption is also known as Public Key Infrastructure
or PKI). You, and only you, will have and use your private key. Your public key
is handed out to anyone you choose or even made publicly availabl...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Registry editing

DISCUSSION from Carlosdl:
As Technochic said, you should not take care of that.

On the other hand, there is no need to copy registry settings in order to be
able to log on to the network with the new computer. Basically, two things are
needed:

- Join the computer to the domain
- a valid domain user account, which you...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683911/4946246/112

-----------------------------------------------------------------------
UPDATED ANSWER on:
Outlook web access needs to be accesible via the internet with Exchange 2007
and Outlook 2007

ANSWER from Technochic:
Here is a [A
href="http://www.microsoft.com/downloads/details.aspx?FamilyID=EE292C13-C933-4F5
9-91D9-16E4B38F5E34&displaylang=en"]useful guide[/A] to download.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683896/4946246/113

-----------------------------------------------------------------------
UPDATED ANSWER on:
Data erasing solutions?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683883/4946246/114

-----------------------------------------------------------------------
NEW ANSWER on:
How to extract the IP address of a data packet and store it in the database?

ANSWER from Kutu:
is the server window, linux sun?

If it's a SUN server just use snoop. Type snoop at the command prompt and it
will show you the packets as they pass through the server. Use grep to narrow
things down a bit.

If it's a linux box use tcpdump at the command prompt

If it's a windows server use w...

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

-----------------------------------------------------------------------
NEW QUESTION on:
ISA Server 2006 cant authenticate Windows Server 2008 Doman controller

Recently isa server 2006 was restarted and d...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683918/4946246/116

-----------------------------------------------------------------------
SQL SERVER UPDATES
-----------------------------------------------------------------------

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

View all SQL Server related Questions and Answers
http://go.techtarget.com/r/5683870/4946246/117
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Pulling multiple values in the same line in SQL

ANSWER from Mrdenny:
Doing this requires the use of a function. Something like this.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683871/4946246/118

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server 2005 Memory

ANSWER from Mrdenny:
How big is the database?
What edition or SQL are you running ( Developer since you are running XP and
Express only uses 1 Gig of RAM)?
How much RAM do you have?

Odds are the database server needs more RAM than you have available.

The Developer edition of SQL Server can only use 2 Gigs of R...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683872/4946246/119

-----------------------------------------------------------------------
NEW ANSWER on:
Shortening the generation time for a SQL Server 2000 report

When you use a SQL function in a SELECT statement, and that function runs
queries of its own the SELECT stateme...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683873/4946246/120

-----------------------------------------------------------------------
NEW DISCUSSION on:
Pulling rows from SQL Server and loading the data into column textboxes

DISCUSSION from Mrdenny:
I agree, not enough information has been provided in order to provide a useful
answer.

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

-----------------------------------------------------------------------
NEW ANSWER on:
Migrating data from a SQL Server 2005 database to SQL Server 2000

ANSWER from Mrdenny:
Using the import/export wizard will probably be the easiest way to move the
data.

The question then becomes why are you moving to a ticketing system which is
having you use SQL 2000 (a pretty much unsupported database platform) as its
database?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683875/4946246/122

-----------------------------------------------------------------------
NEW DISCUSSION on:
Using indexes in SQL Server 2005

DISCUSSION from Kccrosser:
A simple analogy of why we use indexes:

Assume you have a phone book with names and numbers, but they aren't in any
particular order. That is what a common database table might look like -
unless certain constraints (which are quite similar to indexes!) have been put
on the table, there is no g...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Transferring a database and writing a database script in SQL Server 2008

QUESTION from SQL Server Ask the Experts:
I want to transfer a database from one server to another server using SQL
Server 2008, and then I want to write a script which i can update the database
daily automatically. How can these be done?

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

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

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

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

NEW ANSWER on:
Disk in Array is not recognized RAID 5 configuration

ANSWER from Mrdenny:
Typically if you remove the disk from the server and reinsert it into the
server the system will mark it as good.

However it will probably mark it as bad again. Contact the manufacture for a
replacement. If one block has been marked as bad, otheres will fail as well.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683929/4946246/126

-----------------------------------------------------------------------
NEW DISCUSSION on:
VMware ESX 3.5 not able to create a new datastore

DISCUSSION from Mshen:
When you go to the server configuration tab, what do you see? Is the drive
listed OR can you add it?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683881/4946246/127

-----------------------------------------------------------------------
NEW ANSWER on:
Looking for NAS solution

ANSWER from Labnuke99:
Check out the [A href="http://www.freenas.org/"]FreeNAS server[/A]. Let us know
how it goes if you use this.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683930/4946246/128

-----------------------------------------------------------------------
UPDATED ANSWER on:
Data erasing solutions?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683883/4946246/129

-----------------------------------------------------------------------
NEW QUESTION on:
Disk failed in RAID 5 Dell Poweredge 4400 can i create new container

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5683884/4946246/130

-----------------------------------------------------------------------
VIRTUALIZATION UPDATES
-----------------------------------------------------------------------

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

View all Virtualization related Questions and Answers
http://go.techtarget.com/r/5683931/4946246/131
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Oracle's acquistion strategy

DISCUSSION from Mrdenny:
Seeing how VMware is the market leader at the moment, I don't see EMC wanting
to give up there control of VMware.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
VMware ESX 3.5 not able to create a new datastore

DISCUSSION from Mshen:
When you go to the server configuration tab, what do you see? Is the drive
listed OR can you add it?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5683881/4946246/133

-----------------------------------------------------------------------
NEW ANSWER on:
Moving Virtual Machines off and on server - VMware ESX 3.5

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683882/4946246/134

-----------------------------------------------------------------------
NEW ANSWER on:
Connecting to a Real VNC server accross the internet

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683923/4946246/135

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Office License on Citrix

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683916/4946246/136

-----------------------------------------------------------------------
VOIP UPDATES
-----------------------------------------------------------------------

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

View all VoIP related Questions and Answers
http://go.techtarget.com/r/5683933/4946246/137
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
SIP for contact centers

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5683879/4946246/138

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

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.