Daily Question and Answer Update for Feb 24, 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: ITKE

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

NEW ANSWER on:
Already using SAP ERP - any good reasons to consider CRM software not from
SAP?

ANSWER from JohnKR:
There are definitely advantages to selecting an incumbent ERP vendor for your
CRM software in terms of integration costs. However, a common problem I hear
from SSPA members is while they love the newest version of CRM from SAP (or
whomever), their ERP platform is using an old version and would need...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Salesforce Training

QUESTION from LisaHinds:
Our company is new to Salesforce and I am taking many different training
sessions. My question is: Can I print out the training slides so i can make a
training booklet for my own reference?

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

-----------------------------------------------------------------------
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/5938219/4946246/4

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

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

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

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

UPDATED ANSWER on:
How can I compare fields on two databases

ANSWER from Sqlhnd:
You will need to specify what database and programming language you are using,
in order to get some useful responses.
-----------

Use information_schema if supported:

[CODE]select column_name from <db1>.information_schema.columns
except
select column_name from <db2>.information_...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938322/4946246/9

-----------------------------------------------------------------------
UPDATED ANSWER on:
After earning a CCNA, which certification is best for job security?

ANSWER from Labnuke99:
The CCNP is a safe choice. You can go for a CCVP if you want to work with QoS
and VOIP phone systems, but that is a more specialized field.

================
Get some training / certifications in non-vendor specific areas. For example,
with your CCNA, you should be able to sit & pass the Network...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938257/4946246/10

-----------------------------------------------------------------------
NEW ANSWER on:
Finding the number of rows of all tables of a user/schema in Oracle

ANSWER from Carlosdl:
Try this:

[CODE]SELECT table_name,num_rows
FROM all_Tables
WHERE owner = '&user_name';[/CODE]

Note that tables need to be analyzed in order to get accurate results.

Type DESCRIBE all_tables to find out what other useful information you could
get from ALL_TABLES.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Website and database connection

ANSWER from Carlosdl:
You'll need to use the information you have to create the connection string.
[A href="http://www.connectionstring.com/"]Connectionstrings.com[/A] has all
sorts of good info on getting up the connection string.

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

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

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

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

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

NEW ANSWER on:
Can Cisco ASA firewalls restrict Internet access to branch offices?

ANSWER from Puneet:
Does your gateway / Firewall allow internet traffic from any IP or only through
the PROXY Server ? If its open for all the IP's than users can bypass the proxy
server and freely browse the internet. The best way to restrict the users is by
restricting them to change any TCP / IP & Browser settings. ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938255/4946246/14

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

DISCUSSION from TheCapKing:
For optiplex GX-520s the power supply fan is usually the problem. It is a
70X15mm Usually ADDA DC brushless 12v .18A that stops spinning. Check
thecapking website I will eventually start selling these fans as it seems to be
happening to me a lot lately.

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

-----------------------------------------------------------------------
NEW ANSWER on:
etherchannel

ANSWER from Labnuke99:
See this [A href="http://en.wikipedia.org/wiki/EtherChannel"]definition of
etherchannel[/A].

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
After earning a CCNA, which certification is best for job security?

ANSWER from Labnuke99:
The CCNP is a safe choice. You can go for a CCVP if you want to work with QoS
and VOIP phone systems, but that is a more specialized field.

================
Get some training / certifications in non-vendor specific areas. For example,
with your CCNA, you should be able to sit & pass the Network...

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

-----------------------------------------------------------------------
NEW QUESTION on:
XenServer on Hitachi BladeSymphony 320

QUESTION from ITKE:
I have installed XenServer on a blade inside a Hitachi BladeSymphony 320.
The issue i have is that it doesnt recognize the FC HBA

Any suggestions

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Result of improper shutdown?

DISCUSSION from Carlosdl:
And yes. It could harm physically your hard disk, operating system, installed
software and/or data.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938259/4946246/19

-----------------------------------------------------------------------
NEW QUESTION on:
IT Automation

QUESTION from Jkumbhani:
How do you think is JMX and WMI is useful in IT Automation (RBA) ?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938260/4946246/20

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

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

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

NEW DISCUSSION on:
Is there a way of checking remote PCs to see how much of the hard drive is
taken up with MS Office documents?

DISCUSSION from Findsarfaraz:
Your reply is extremely helpful and informative. I have voted you. But this
question is about running that on the remote pc.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938281/4946246/22

-----------------------------------------------------------------------
NEW DISCUSSION on:
As400 File Transfer to Windows

DISCUSSION from LBurkett99:
There are also the Data Transfer From/To iSeries Server options. With these
you can define a data transfer, create an icon and launch the transfer on your
schedule. You need to include/add the Data Access option of Client Access for
the data transfer functions to be available.

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

-----------------------------------------------------------------------
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/5938219/4946246/24

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

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

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

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

NEW QUESTION on:
how can I get the exact Form that the document actually created?

QUESTION from Sppradip:
I have two Forms.
1. MyFirstForm|RTF
2. MyNextForm|RTF
I create two documents one from first Form and other form second one. In both
document properties there is Form field 'RTF'.
So how can I get the exact Form that the document actually created.
I want this in my programming code in C or C...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938324/4946246/29

-----------------------------------------------------------------------
NEW QUESTION on:
This view is obsolete and requires missing field list. Please edit and re-save
the view

QUESTION from Sppradip:
When calling NIFOpenCollection, for certain views I am getting the error ID
which after conversion with OSLoadString is "This view is obsolete and requires
missing field list. Please edit and re-save
the view."
So, how to solve this issue? Is there any way to refresh, re-save view in
program?

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
MSSQL Query to get the average

ANSWER from GPNel2006:
You you do the match pretty much like you wrote it above.

[CODE]SELECT (Column1+Column2)/2 as Column3
From YourTable[/CODE]

[CODE]Problem is that I run the query and it dispays my value, but asoon as I
query that column the value is NULL.[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938242/4946246/31

-----------------------------------------------------------------------
NEW QUESTION on:
macros not working in password protected workbook

QUESTION from Yoka:
Excel 2007 .... macros work perfectly in original workbook however when i save
as and create apassword to open the workbook, it opens OK but the macros don't
work.

The excel options have the macros enabled but they are deactivated somehow

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How can I compare fields on two databases

ANSWER from Sqlhnd:
You will need to specify what database and programming language you are using,
in order to get some useful responses.
-----------

Use information_schema if supported:

[CODE]select column_name from <db1>.information_schema.columns
except
select column_name from <db2>.information_...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
QMQRY not a valid Query Management variable.

DISCUSSION from NormFeile:
gave it go..
here is the code:
PGM PARM(&JOBX)
DCL VAR(&JOBX) TYPE(*CHAR) LEN(4)
DCL VAR(&JOBA) TYPE(*CHAR) LEN(6)
CHGVAR VAR(&JOBA) VALUE('''' *CAT &JOBX *CAT +
'''')
...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Button must be selected twice to display hidden controls

QUESTION from Jenise:
Hello,

I have this issue with ASP.Net where i have to click my link button twice to
get my controls to display. Can anyone take a look at my code to tell me why?
This is a somewhat urgent request.

My goal is to only show the footer row when one of the linkbuttons are clicked.
In the code be...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

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

-----------------------------------------------------------------------
NEW QUESTION on:
CMPPFM, Space offset error.

QUESTION from Xtreme1:
Hello,
I'm using the IBM CMPPFM utility for a file comparision process. I monitor for
msg SPC5010 (file is too big ), if this occurs I submit an SQL EXCEPT to
compare the files. This has been working fine until recently, now I'm getting
the following error on one file,

Space offset X'00FFF026...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938225/4946246/37

-----------------------------------------------------------------------
NEW ANSWER on:
Excel 2003 - Conditional Formtting Help

ANSWER from Labnuke99:
Here's a [A
href="http://www.google.com/search?q=conditional+format+site%3Acpearson.com&rls=
com.microsoft:en-us&ie=UTF-8&oe=UTF-8&startIndex=&startPage=1"]list of search
results[/A] from an excellent Excel resource. Hopefully one of these will guide
you on the path to resolution.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938289/4946246/38

-----------------------------------------------------------------------
NEW ANSWER on:
VBScript that logs in a user to remote server

ANSWER from Rklanke:
Run it as a scheduled task.

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

-----------------------------------------------------------------------
NEW ANSWER on:
Finding the number of rows of all tables of a user/schema in Oracle

ANSWER from Carlosdl:
Try this:

[CODE]SELECT table_name,num_rows
FROM all_Tables
WHERE owner = '&user_name';[/CODE]

Note that tables need to be analyzed in order to get accurate results.

Type DESCRIBE all_tables to find out what other useful information you could
get from ALL_TABLES.

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

-----------------------------------------------------------------------
NEW ANSWER on:
How to send a mail to multiple recipients from Microsoft Excel sheet?

ANSWER from Findsarfaraz:
[CODE]Sub sendemail()
Dim ol As New Outlook.Application
Dim OLF As Outlook.MAPIFolder

Dim ml As Outlook.MailItem

Set ml = ol.CreateItem(olMailItem)

i = 1

Do While Sheet1.Cells(i, 1) <> ""
ml.Recipients.Add Sheet1.Cells(i, 1)
ml.Body = Sheet1.Cells(i, 2) & " " & Sheet1.C...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938294/4946246/41

-----------------------------------------------------------------------
UPDATED ANSWER on:
Website and database connection

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938247/4946246/42

-----------------------------------------------------------------------
NEW ANSWER on:
What are the main differences between Apache v.1.3 and v2.0

ANSWER from Technochic:
Here is a [A
href="http://apache.slashdot.org/article.pl?sid=04/03/23/0237252&tid=185&tid=2"]
useful article[/A] which may help you.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938328/4946246/43

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to link a macro by clicking on a cell of an Excel sheet

ANSWER from Findsarfaraz:
You don't need a macro:
In the cell type "=now()" (without quotes) and this will give u the date and
time. It will also update.

If you are looking for macro:
[CODE]Sub ShowTime()
ActiveCell.FormulaR1C1 = "=NOW()"
End sub
[/CODE]

And then assign the macro to a button or menu item.

Hope...

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

-----------------------------------------------------------------------
NEW QUESTION on:
IT Automation

QUESTION from Jkumbhani:
How do you think is JMX and WMI is useful in IT Automation (RBA) ?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938260/4946246/45

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

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

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

NEW DISCUSSION on:
Opening and Closing Impress

DISCUSSION from Findsarfaraz:
Through application you want to open and close

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"]MS Excel help[/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938277/4946246/47

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

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

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

UPDATED ANSWER on:
How to see if my Nmap tcpwrapped port is open after a GFI LANguard scan

ANSWER from Puneet:
telnet to the ip address / port. The system should return a banner if the port
is truly open. You can also run netstat -an at a command prompt to see if the
host is listening on port 21. You can also use the Process Explorer tool from
Sysinternals (Microsoft) to see what IP addresses are connected t...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SSIS and Microsoft Excel

ANSWER from Darryn:
I haven't extracted data using SSIS before, but it is easy enough to use Excel
and VBA as the controlling program, and pull the data from the database, and
then save it to where ever you need. You can then schedule the excel workbook
to open and run every night.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938241/4946246/50

-----------------------------------------------------------------------
NEW ANSWER on:
Internet Explorer 6 launch options

ANSWER from Findsarfaraz:
I am not clear about your query. But you still you can try this

Click on Start-> Run
Under run type iexplore
and click on Ok

This will launch IE6

Regards,
Sarfaraz Ahmed
[A href = "http://findsarfaraz.blogspot.com"] MS Excel help [/A]

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Is there a way of checking remote PCs to see how much of the hard drive is
taken up with MS Office documents?

DISCUSSION from Findsarfaraz:
Your reply is extremely helpful and informative. I have voted you. But this
question is about running that on the remote pc.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938281/4946246/52

-----------------------------------------------------------------------
NEW DISCUSSION on:
How many uses of Microsoft Office?

DISCUSSION from Findsarfaraz:
You suggest you to go through the license or contact Microsoft support before
you proceed.

Regards,
Sarfaraz Ahmed

[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Setup of FTP server & Mail server

DISCUSSION from Memonboys:
i want to create ftp server and mail server in CentOS operating system , please
help me out , and for quick reply thanks to all , specially labnuke99

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938263/4946246/54

-----------------------------------------------------------------------
UPDATED ANSWER on:
Windows XP CHKDSK /F does not work

ANSWER from MichaelDetroit:
[A href="http://www.ehow.com/how_2052292_run-chkdsk-f-windows-xp.html"]Read
this.[/A] Thanks for the tip. I went to the link and followed the directions. I
received the following message: "The disk check could not be performed because
the disk check utility needs exclusive access to some Windows fil...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
outlook authentication

DISCUSSION from Yager:
She's a local user, should this apply, when I go to < More settings>
<connections tab> the box is unchecked that says connect to my exchange
mailbox using HTTP.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938267/4946246/56

-----------------------------------------------------------------------
UPDATED ANSWER on:
Memory Stick Virus

ANSWER from Rklanke:
The standard response should be "make sure your virus definition files are
up-to-date and scan your system". I imagine you tried that.

Yes, something on the harddisk that is not being detected as malicious. To
narrow down what it may be, try Trend Micro's System Information Collector
(SIC) utilit...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Wireless access gone after hard drive replacement

DISCUSSION from PC32Mech:
In the router settings page, there is an option to set the username and
password. Normally: admin - Admin. If you change these characters, you should
remember that.

On the settings page of your wireless card, you must enter this username and
password.

This is the same if a person tries to ent...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938285/4946246/58

-----------------------------------------------------------------------
NEW DISCUSSION on:
New Vista user can't respond to email while using Domino Web Access

DISCUSSION from Jehan:
By changing the format from Rich Text to Plain text, I was able to solve this
problem. This could be done through an icon on the tool bar

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

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

-----------------------------------------------------------------------
NEW ANSWER on:
Printer Migration

ANSWER from Mshen:
Are you migrating from a 32-bit OS to a 64-bit OS? If this is the case, you
will need to get new drivers. Most 32-bit print drivers will not work on a
64-bit OS.

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

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V on Windows 2008

QUESTION from BladeMarvel:
I want to set up Hyper-V on a Windows 2008 server and set up remote-admin
(where Hyper-V remains in a workgroup). Does anyone have instructions on how to
do this?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938288/4946246/62

-----------------------------------------------------------------------
NEW ANSWER on:
Excel 2003 - Conditional Formtting Help

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938289/4946246/63

-----------------------------------------------------------------------
NEW DISCUSSION on:
2 NIC Cards - External and Internal IP Addresses - Odd Setup

DISCUSSION from Faustcoder:
OS is Windows Server 2003. Ill report back the routing table next.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
After earning a CCNA, which certification is best for job security?

ANSWER from Labnuke99:
The CCNP is a safe choice. You can go for a CCVP if you want to work with QoS
and VOIP phone systems, but that is a more specialized field.

================
Get some training / certifications in non-vendor specific areas. For example,
with your CCNA, you should be able to sit & pass the Network...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Animation within a table in Kiosk Mode

QUESTION from Kezeork:
I am putting a presentation together that I want the user to be able to click
choices and go to certain slides. I have this part figured out. However, some
of my slides have animation that I use the right arrow button to highlight
boxes within a table. (There are almost 50 boxes to highlight on s...

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

-----------------------------------------------------------------------
NEW ANSWER on:
How to interact with other user on LAN

ANSWER from Rklanke:
I'm going to guess that you've done remote control before. You're probably
facing a name resolution issue. I'm picturing two machines getting their
network configuration information from a broadband router. They're able to
reach systems on the Internet, on the other side of the router, just fine.
Th...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938292/4946246/67

-----------------------------------------------------------------------
UPDATED ANSWER on:
transferring data from iSeries to Excel 2007

ANSWER from NullFields:
Well, seeing that Excel has a row limitation of 65536... The only way to
download more rows than that would be to insert them into Access! Or ask
Microsoft to expand the Excel row limitation.

The MS office 2007 has unlimited rows. However, can you tell how are you
connecting iSeries?
Sarfaraz ...

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

-----------------------------------------------------------------------
NEW ANSWER on:
VBScript that logs in a user to remote server

ANSWER from Rklanke:
Run it as a scheduled task.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Backup Exec 11d with Exchange 2007

DISCUSSION from Dwiebesick:
We have many small customers running various versioins of BE including Symantec
Backup Exec 11d and have never had Symantec tell us this. You do have to
purchase support on a yearly bases. However, there are versions os BE that come
free with hardware (e.g. Sony tape drive) that DOES NOT include su...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Excel 2007 charts

QUESTION from JimGlover:
I have a macro that runs when a cell is updated by a PLC. When this cell
changes its value I insert a cell into a column and copy data from another cell
and paste it into that new inserted cell. My problem is that my chart that is
associated with the data where the cell is inserted dissapears. I ...

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

-----------------------------------------------------------------------
NEW ANSWER on:
How to send a mail to multiple recipients from Microsoft Excel sheet?

ANSWER from Findsarfaraz:
[CODE]Sub sendemail()
Dim ol As New Outlook.Application
Dim OLF As Outlook.MAPIFolder

Dim ml As Outlook.MailItem

Set ml = ol.CreateItem(olMailItem)

i = 1

Do While Sheet1.Cells(i, 1) <> ""
ml.Recipients.Add Sheet1.Cells(i, 1)
ml.Body = Sheet1.Cells(i, 2) & " " & Sheet1.C...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938294/4946246/72

-----------------------------------------------------------------------
UPDATED ANSWER on:
Windows XP control panel showing wrong icons

ANSWER from Overweightgeek:
Thanks for the idea. Unfortunately I tried that earlier. On this machine -
that key doesn't have any don't load attributes. In fact there is an icon
loading in control panel for printers and faxes it's just the wrong one.
Instead of the printer icon the one appearing is a generic one (as if the...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938295/4946246/73

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to create a desktop shortcut to a 2nd email account on Windows Mail

DISCUSSION from Technochic:
Thanks for posting the solution Vonga, great job on getting it resolved :-)

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Imagistics 3512 DEVD iSeries Printer problem CPF3397

DISCUSSION from Gilly400:
Hi,

Are you by any chance the same mellorman from the Bladerunner newsgroup?

Regards,

Martin Gilbert.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Result of improper shutdown?

DISCUSSION from Carlosdl:
And yes. It could harm physically your hard disk, operating system, installed
software and/or data.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938259/4946246/76

-----------------------------------------------------------------------
NEW QUESTION on:
Blank Merge Fields

QUESTION from Hawkfandeb:
How do I get merge fields in my word document not print when they are blank, or
#N/A, or 0?

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Using Excel, I past from a table brom a web site and excel puts everything in
one cell

DISCUSSION from Findsarfaraz:
[A
href="http://findsarfaraz.blogspot.com/2008/09/import-data-from-website.html"]
Import from website[/A] is a goog website to resolve your issue

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to link a macro by clicking on a cell of an Excel sheet

ANSWER from Findsarfaraz:
You don't need a macro:
In the cell type "=now()" (without quotes) and this will give u the date and
time. It will also update.

If you are looking for macro:
[CODE]Sub ShowTime()
ActiveCell.FormulaR1C1 = "=NOW()"
End sub
[/CODE]

And then assign the macro to a button or menu item.

Hope...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Windows XP performing too Slow

ANSWER from Firoxy:
Salam/w Furqan

Furqan as far as ur system config is concerned.. first check how many softwares
u have installed.. big softwares will make ur desktop slow

secondly if ur a home user plz check ur services by typing services.msc in run
command.

disabled automatic updates
disabled windows fire...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938300/4946246/80

-----------------------------------------------------------------------
NEW QUESTION on:
IT Automation

QUESTION from Jkumbhani:
How do you think is JMX and WMI is useful in IT Automation (RBA) ?

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

-----------------------------------------------------------------------
MOBILE UPDATES
-----------------------------------------------------------------------

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

View all Mobile related Questions and Answers
http://go.techtarget.com/r/5938321/4946246/82
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW DISCUSSION on:
Is there a way of checking remote PCs to see how much of the hard drive is
taken up with MS Office documents?

DISCUSSION from Findsarfaraz:
Your reply is extremely helpful and informative. I have voted you. But this
question is about running that on the remote pc.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Wireless access gone after hard drive replacement

DISCUSSION from PC32Mech:
In the router settings page, there is an option to set the username and
password. Normally: admin - Admin. If you change these characters, you should
remember that.

On the settings page of your wireless card, you must enter this username and
password.

This is the same if a person tries to ent...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to setup wireless Internet access on 2 desktop PCs

ANSWER from Securityn00b12:
You are on the right track. You should go with 802.11n draft wireless cards
and a matching router if you have the money for it. Otherwise 802.11g will
work; the difference is how fast the wireless connections can go. 802.11n can
go up to 270Mbps and 802.11g can go up to 54Mbps which is a huge dif...

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

-----------------------------------------------------------------------
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/5938219/4946246/86

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

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

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

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

UPDATED ANSWER on:
How to see if my Nmap tcpwrapped port is open after a GFI LANguard scan

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938279/4946246/91

-----------------------------------------------------------------------
NEW ANSWER on:
Can Cisco ASA firewalls restrict Internet access to branch offices?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938255/4946246/92

-----------------------------------------------------------------------
NEW QUESTION on:
networking

QUESTION from Boy genius:
am doing a project that tells me to research for the specific obstacles an d
incompatibilities that may arise in amultivendor networking environment ..i
will appreciate all the help ..thanks

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938301/4946246/93

-----------------------------------------------------------------------
NEW DISCUSSION on:
Setup of FTP server & Mail server

DISCUSSION from Memonboys:
i want to create ftp server and mail server in CentOS operating system , please
help me out , and for quick reply thanks to all , specially labnuke99

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938263/4946246/94

-----------------------------------------------------------------------
NEW DISCUSSION on:
FTP a zipped file to a client in a batch job from AS/400

DISCUSSION from Brenger:
FYI for any others out there thinking of this:

PUT /QDLS/EMAIL/EMAIL.ZIP D:FTPUSERIDEMAIL.ZIP
PUT /QDLS/EMAIL/EMAIL.ZIP

instead of stmt 1, use stmt 2.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938223/4946246/95

-----------------------------------------------------------------------
NEW DISCUSSION on:
Wireless access gone after hard drive replacement

DISCUSSION from PC32Mech:
In the router settings page, there is an option to set the username and
password. Normally: admin - Admin. If you change these characters, you should
remember that.

On the settings page of your wireless card, you must enter this username and
password.

This is the same if a person tries to ent...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938285/4946246/96

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938245/4946246/97

-----------------------------------------------------------------------
NEW QUESTION on:
Cisco 3550 config assistance needed

QUESTION from Yernkie:
Here is the network scenario: I have two T1's coming into our main building.
One is a p2p T1 circuit to a remote office. The other is a basic T1 circuit
for Internet connectivity. The far end of the p2p is in the 192.168.3.0
255.255.255.0 network. The local router is an Adtran with an IP of 10....

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938302/4946246/98

-----------------------------------------------------------------------
NEW DISCUSSION on:
2 NIC Cards - External and Internal IP Addresses - Odd Setup

DISCUSSION from Faustcoder:
OS is Windows Server 2003. Ill report back the routing table next.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938290/4946246/99

-----------------------------------------------------------------------
NEW ANSWER on:
etherchannel

ANSWER from Labnuke99:
See this [A href="http://en.wikipedia.org/wiki/EtherChannel"]definition of
etherchannel[/A].

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

-----------------------------------------------------------------------
NEW ANSWER on:
Multiple Networks

ANSWER from Labnuke99:
In this case you would probably want to use a 24-bit subnet mask
(255.255.255.0) Your router will need to have a logical interface for each
network. So it would have an interface address on the 192.168.1.x, 192.168.2.x
and 192.168.3.x network. Once you have that created on the router, the devices
on...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Convert RJ45 connection to wireless.

DISCUSSION from AndOrTech:
If you want something a little more durable try the HP ProCurve M111 Client
Bridge. It also has a LIFETIME warranty!

[A
href="http://www.hp.com/rnd/products/wireless/HP_ProCurve_M111_Client_Bridge/ove
rview.htm"]Check the ProCurve M111 Client Bridge out here[/A].

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

-----------------------------------------------------------------------
NEW ANSWER on:
How can I disable browsing from my 2960 switch?

ANSWER from Labnuke99:
You will need to create an access control list of some type. I would however
recommend using a firewall for this purpose (www.smoothwall.org) to give you
better control than doing it by ACL's on the switch.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938305/4946246/103

-----------------------------------------------------------------------
NEW ANSWER on:
Copper T1

ANSWER from AndOrTech:
You will need a smart media converter box. These are generally a pain to
configure but once you are done they are generally rock solid.

[A href="http://www.audiocodes.com/products/mediant-1000"] Try this.[/A]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938306/4946246/104

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to setup wireless Internet access on 2 desktop PCs

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How does ATM differ from existing network technology?

ANSWER from Labnuke99:
[A href="http://en.wikipedia.org/wiki/Asynchronous_Transfer_Mode"]ATM[/A]

================
The big difference is ATM uses fixed length cells rather than the variable size
packets most other transports use. This is meant to provide some consistency in
delivery. The issue with this though is that ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938308/4946246/106

-----------------------------------------------------------------------
UPDATED ANSWER on:
After earning a CCNA, which certification is best for job security?

ANSWER from Labnuke99:
The CCNP is a safe choice. You can go for a CCVP if you want to work with QoS
and VOIP phone systems, but that is a more specialized field.

================
Get some training / certifications in non-vendor specific areas. For example,
with your CCNA, you should be able to sit & pass the Network...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938257/4946246/107

-----------------------------------------------------------------------
NEW ANSWER on:
How to interact with other user on LAN

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

-----------------------------------------------------------------------
NEW QUESTION on:
XenDesktop load balancing

QUESTION from ITKE:
I have 3 XenDesktop DDC servers and want to load balance and prefer not to use
MSFT NLB. Has anyone used anything else?

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

-----------------------------------------------------------------------
NEW QUESTION on:
XenServer on Hitachi BladeSymphony 320

QUESTION from ITKE:
I have installed XenServer on a blade inside a Hitachi BladeSymphony 320.
The issue i have is that it doesnt recognize the FC HBA

Any suggestions

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938258/4946246/110

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

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

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

NEW QUESTION on:
JD Edwards screen travel

QUESTION from Jean43:
I have a user that is trying to travel between screens using JD Edwards. When
she enters a new screen name on one screen, she gets the error: Security
Violation. Any idea how to get this to work?

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

-----------------------------------------------------------------------
NEW QUESTION on:
Free Oracle Assessment Exams

QUESTION from Stewary:
Can someone tell me where I can find free Oracle Assessment exams in
preparation for Oracle certifications?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938237/4946246/113

-----------------------------------------------------------------------
NEW ANSWER on:
Finding the number of rows of all tables of a user/schema in Oracle

ANSWER from Carlosdl:
Try this:

[CODE]SELECT table_name,num_rows
FROM all_Tables
WHERE owner = '&user_name';[/CODE]

Note that tables need to be analyzed in order to get accurate results.

Type DESCRIBE all_tables to find out what other useful information you could
get from ALL_TABLES.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Oracle 10g OCA dumps

ANSWER from BrentSheets:
[B]Moderator Note:[/B] Hi Handle2511. We don't provide brain dumps here on IT
Knowledge Exchange - but prefer to have members post specific questions. If
you're stumped by something you're studying for the OCA, please feel free to
post a question. Thanks.

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

-----------------------------------------------------------------------
NEW QUESTION on:
New member - Oracle questions?

QUESTION from BrentSheets:
Hi Handle, you can browse through all the oracle questions by clicking on the
[A
href="http://itknowledgeexchange.techtarget.com/itanswers/tag/oracle/"]Oracle[/A
] link under "Browse IT Answers by Topic" in the upper right corner of this
page. Have fun, and welcome to the community!

__________
[B...

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

-----------------------------------------------------------------------
SAP UPDATES
-----------------------------------------------------------------------

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

View all SAP related Questions and Answers
http://go.techtarget.com/r/5938333/4946246/117
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
Already using SAP ERP - any good reasons to consider CRM software not from
SAP?

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

-----------------------------------------------------------------------
NEW QUESTION on:
ABAP query request

QUESTION from Poilkj:
hi,all i want to implement a logic where i have to display sum of one column at
the end of another sorted column .i used at new block but itisn't
working.please prove any pointers.
thanks in advance.

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

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

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

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

UPDATED ANSWER on:
How to see if my Nmap tcpwrapped port is open after a GFI LANguard scan

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938279/4946246/121

-----------------------------------------------------------------------
NEW ANSWER on:
Can Cisco ASA firewalls restrict Internet access to branch offices?

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Memory Stick Virus

ANSWER from Rklanke:
The standard response should be "make sure your virus definition files are
up-to-date and scan your system". I imagine you tried that.

Yes, something on the harddisk that is not being detected as malicious. To
narrow down what it may be, try Trend Micro's System Information Collector
(SIC) utilit...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938284/4946246/123

-----------------------------------------------------------------------
NEW QUESTION on:
Whitelist a group so that only the members can emal to specified domains

QUESTION from Mabs:
We have Domino 7, Notes 6/7, SMTP server fro outgoing mail to inet.
We are trying to find a solution with this logic:

If user A in group G sends a mail To/CC/BCC domain X.com,or domain Y.com, or
domain Z.com the mail is sent. If user A is not in group G the mail gets
returned with a delivery fai...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

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

-----------------------------------------------------------------------
NEW ANSWER on:
How to block Google Talk via Fortigate 60?

ANSWER from Carlosdl:
Try blocking:

[CODE]chatenabled.mail.google.com
mail.google.com/mail/im/
mail.google.com/mail/channel/
talk.google.com
www.google.com/talk[/CODE]

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
My computer is logged in with unknown password

DISCUSSION from BrentSheets:
Hello Taar. Please don't take this personally but I'm always leery of questions
like these from first time posters. Please provide much more detail. Thank you
for understanding and welcome to IT Knowledge Exchange.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
iSeries SFTP

DISCUSSION from Gilly400:
Hi,

Sorry about that - my machine remembers the login for me - didn't realise that
it was a subscribers only page.

Regards,

Martin Gilbert.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938233/4946246/128

-----------------------------------------------------------------------
NEW DISCUSSION on:
Camera

DISCUSSION from 85858585:
types of camera?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938313/4946246/129

-----------------------------------------------------------------------
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/5938219/4946246/130

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

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

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

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

NEW ANSWER on:
SSIS and Microsoft Excel

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
MSSQL Query to get the average

ANSWER from GPNel2006:
You you do the match pretty much like you wrote it above.

[CODE]SELECT (Column1+Column2)/2 as Column3
From YourTable[/CODE]

[CODE]Problem is that I run the query and it dispays my value, but asoon as I
query that column the value is NULL.[/CODE]

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

-----------------------------------------------------------------------
NEW ANSWER on:
Data Purging

ANSWER from Mrdenny:
No you can not place online data on a tape. Tape can only be used for backing
up the database.

The recommended solution would be to get slower less expensive hard drives and
use them to host a second filegroup which you move the old data to.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938243/4946246/137

-----------------------------------------------------------------------
NEW ANSWER on:
install a second instance of sql server 2005

ANSWER from Technochic:
Here is a [A
href="http://www.exforsys.com/tutorials/sql-server-2005/installing-a-second-copy
-of-sql-server-2005.html"]good tutorial[/A] for you.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938245/4946246/139

-----------------------------------------------------------------------
NEW QUESTION on:
SQL Server 2005 SP2 backup failing

QUESTION from Mrdenny:
Within a Windows domain the time on the machines has to be within a couple of
minutes of each other. If one of the computers is drifting its time you'll
have problems talking between the machines. It is recommended that domains use
the time sync features of the computers to ensure that the times m...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938246/4946246/140

-----------------------------------------------------------------------
NEW QUESTION on:
CMPPFM, Space offset error.

Space offset X'00FFF026...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Website and database connection

You'll then need to open the [A
href="http://www.devhardware.com/forums/programming-8...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938247/4946246/142

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are basic differences between SQL Server 2000 and 2005

DISCUSSION from Findsarfaraz:
The brief overview SQL 2005 comes with SSRS, DTS is replaced with SSIS, MSAS
which is separate in SQL 2000 is now a part of SQL 2005 as SSAS.

SSIS is more than a data tranformation tool. It's more like an ETL tool.

Regards,
Sarfaraz Ahmed
[A href ="http://findsarfaraz.blogspot.com"] MS ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938248/4946246/143

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

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

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

NEW DISCUSSION on:
Is there a way of checking remote PCs to see how much of the hard drive is
taken up with MS Office documents?

DISCUSSION from Findsarfaraz:
Your reply is extremely helpful and informative. I have voted you. But this
question is about running that on the remote pc.

Regards,
Sarfaraz Ahmed
[A href="http://findsarfaraz.blogspot.com"] MS Excel help [/A]

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938281/4946246/145

-----------------------------------------------------------------------
NEW QUESTION on:
DVD Recorded

QUESTION from Griffie10:
I removed the DVD recorder drive by unplugging it from the computer tower, now
that I have put it back in, it does not recognize any discs I put in there and
now the CD ROM does not either, I believe it may have to do with some of the
wires that have PS6 and PS8 on them and maybe the PS4 wire. How ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938315/4946246/146

-----------------------------------------------------------------------
NEW QUESTION on:
XenServer on Hitachi BladeSymphony 320

QUESTION from ITKE:
I have installed XenServer on a blade inside a Hitachi BladeSymphony 320.
The issue i have is that it doesnt recognize the FC HBA

Any suggestions

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938258/4946246/147

-----------------------------------------------------------------------
NEW DISCUSSION on:
Backup Exec 11d with Exchange 2007

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938272/4946246/148

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

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

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

NEW DISCUSSION on:
VMware admin working with Exchange admin

DISCUSSION from Colin Steele:
Make sure you have the proper software licensing, too. Here are two tips to
help you sort that out:
http://searchsystemschannel.techtarget.com/tip/0,289483,sid99_gci1256595,00.html
and
http://searchservervirtualization.techtarget.com/tip/0,289483,sid94_gci1243792,0
0.html Good luck.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938265/4946246/150

-----------------------------------------------------------------------
NEW QUESTION on:
Changing host machine name in Hyper-V

QUESTION from BladeMarvel:
In a Hyper-V system -- is it possible to change the computer name of a host
machine? Will it affect the setup or the other machines?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938317/4946246/151

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V on Windows 2008

QUESTION from BladeMarvel:
I want to set up Hyper-V on a Windows 2008 server and set up remote-admin
(where Hyper-V remains in a workgroup). Does anyone have instructions on how to
do this?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938288/4946246/152

-----------------------------------------------------------------------
NEW QUESTION on:
XenServer on Hitachi BladeSymphony 320

QUESTION from ITKE:
I have installed XenServer on a blade inside a Hitachi BladeSymphony 320.
The issue i have is that it doesnt recognize the FC HBA

Any suggestions

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938258/4946246/153

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V Guest: USB-over-network

QUESTION from BladeMarvel:
Has anyone had any experience with using USB-over-network in a Hyper-V Guest
environment? What are the best products?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938318/4946246/154

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

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

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

NEW QUESTION on:
Diferrence between Callmanager and SIP server

QUESTION from CiscoNW:
Hi There,

Anybody can help me to know the difference between Callmanager and SIP server?
Call processing difference.. and protocols used.

Thanks and regards,
Shaju

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5938320/4946246/156

-----------------------------------------------------------------------
NEW DISCUSSION on:
Dell Optiplex GX520 hibernation/sleep mode issues

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5938245/4946246/157

-----------------------------------------------------------------------
NEW ANSWER on:
How to block Google Talk via Fortigate 60?

ANSWER from Carlosdl:
Try blocking:

[CODE]chatenabled.mail.google.com
mail.google.com/mail/im/
mail.google.com/mail/channel/
talk.google.com
www.google.com/talk[/CODE]

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5938311/4946246/158

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

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 Technology Media ROI Experts and
events company.

Label Links

Break

Daily Question and Answer Update for Feb 24, 2009

Hot in Week

Popular

Archive

Footer Ads

Page

Label Links

Break

Daily Question and Answer Update for Feb 24, 2009

Like to share?

Hot in Week

Popular

Archive

Footer Ads