Daily Question and Answer Update for Feb 10, 2009

New questions and answers have been added to the community for the following
tags:
- CRM
- Database
- DataCenter
- DataManagement
- Development
- Linux
- Microsoft Windows
- Networking
- Oracle
- 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/5808501/4946246/1

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

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

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

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

UPDATED ANSWER on:
SIP for contact centers

ANSWER from Techy001:
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.

Techy001 writes:

If we make SIP as contact center server, we can gain below functionalities:
1. unified ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808511/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/5808501/4946246/7

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

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

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

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

NEW DISCUSSION on:
In-Memory Database

DISCUSSION from Techy001:
Hi Sean,

Thanks for your update. I've search a lot but I would like to know how the
in-memory is getting loaded into the physical memory space of the application.
Please provide me a pointer where can get the detailed implementation of
in-memory database.

Thanks in advance.
Balaji

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to make installer of VB.NET including SQL Server 2000?

DISCUSSION from Mrdenny:
Someone with more experience with .NET will need to address the question about
putting the .NET installer in your package.

If your workstations are even close to fully patched then the .NET framework
will already be installed on the machine.

As for the connection string problem no workstations...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Access 2007 Report OutputTo Print

DISCUSSION from Riaane:
GGGRRR.... no, still the same problem. I am considering a career in knitting at
this stage. Please, can anyone help on this matter?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808528/4946246/14

-----------------------------------------------------------------------
NEW DISCUSSION on:
To retrieve records from SQL Server database

DISCUSSION from Kccrosser:
Carlosdl - you are correct, for the problem cases shown. I overlooked that you
listed all the distinct cases for start/end of fields and blank separators.

When I have encountered this problem in practice, there is usually a
requirement to also find words that may or may not have trailing commas ...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How to use embedded SQL in a RPG program used as a stored procedure

QUESTION from Warykat:
When I use embedded SQL in a RPG program and call it from another program
it works fine. But, when I try to use the program as a stored procedure
it gives me a SQL error. I have worked with stored procedures and understand
them, but have not been successful using embedded SQL with them.
Any id...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808487/4946246/16

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to block AS/400 users from using WinSQL

ANSWER from Philpl1jb:
I think you should be able to modify their user ids and limit what they can do.
Check into object authority, group authority.
/////////////////////////////////////////////////////////////

The data files should be limited to *public view
and your rpgle/cobol programs should use owner authority
...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
ASP.NET and Multiple Access Databases Open

ANSWER from Mshen:
That is possible, but I would recommend you close the database connection after
you get the information that you need from each.

Open Connection
Get Data from database
Close Connection
Work with data

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808552/4946246/18

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

DISCUSSION from Mshen:
One question you should be prepared for is: A customer is planning on setting
up a new office network, make a network diagram and present to the customer
everything that is involved. This is a very involved question that some
companies could ask from you.

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

-----------------------------------------------------------------------
NEW QUESTION on:
Problems with VAL function

QUESTION from Arlin:
I have a table with an NVarChar field that contains left aligned numeric
values. I've tried using the VAL function to return the integer values, but
I'm getting back Short Date results. What can I do to get integer results?
Thanks,
Arlin

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

-----------------------------------------------------------------------
NEW ANSWER on:
PL/SQL - Attribute to test not null and can take specific value instead

ANSWER from Carlosdl:
I'm not sure if I understand correctly your question.

If you want to assign some specific value to a varibale or parameter in PL/SQL
when it is null, you could use the NVL function, this way:

[CODE]l_variable := nvl(l_variable,'-');[/CODE]

If this is not what you meant, please provide more ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808499/4946246/21

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

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

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

NEW DISCUSSION on:
Remove password

DISCUSSION from BPandey:
If its a bios password, then shut down computer and open up CPU and remove the
BIOS battery. Now use a small wire to short the circuit by connecting the two
ends of wire to the minus and plus end points of battery inserter (the place
where battery is inserted ) for 2-3 second. This will remove t...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

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

-----------------------------------------------------------------------
NEW QUESTION on:
Domain Controller or Member Server for Exchange 2007

QUESTION from Labnuke99:
You should not install Exchange 2007 on a domain controller. The only case
where Exchange should be installed on a domain controller is when it is
implemented using the Small Business Server solution.

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

-----------------------------------------------------------------------
NEW ANSWER on:
AS400 Cobol screen write hanging up

ANSWER from Gilly400:

Hi,

Haven't done too much cobol on AS400, but I'd suggest starting with the DDS to
see if there's anything strange there. Has the Display file been compiled with
specific keywords (use DSPFD or CHGDSPF to check).

If all this looks OK, then I'd check the definition of the display file in
the...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808495/4946246/26

-----------------------------------------------------------------------
NEW QUESTION on:
Mainframe to Unix Codepage using Connect:Direct

QUESTION from HaroldB:
Hello,
I am using Connect:Direct to send a file from our Mainframe to a Unix Server.
My file contains French charcters, when the file is received on the Unix
server, the French characters are changed to '3/4'.

This is the codepage I am using on the from:
SYSOPTS=":CODEPAGE=(IBM-037,IBM-819):ty...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808516/4946246/27

-----------------------------------------------------------------------
NEW ANSWER on:
Printing special characters

ANSWER from Mimo:
The problem is the printer drivers. You need to have a PCL drivers. It should
fixe the problem

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808517/4946246/28

-----------------------------------------------------------------------
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/5808501/4946246/29

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

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

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

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

UPDATED ANSWER on:
ASP.NET and Multiple Access Databases Open

ANSWER from Mshen:
That is possible, but I would recommend you close the database connection after
you get the information that you need from each.

Open Connection
Get Data from database
Close Connection
Work with data

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

-----------------------------------------------------------------------
NEW ANSWER on:
Performane issues on my Subversion (SVN) server on NFS (NetApp)

ANSWER from Mimo:
Hello T0ns,

We don't have the subversion here but we had experiment the same kind a
probleme after a migration to NFS with EMC. The problem was the TCP window on
the linux server (EMC NAS). we hhad match the tcp window on the EMC with the
tcp window on the workstations and every thing whent bac...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Microsoft Excel - I need to find rows that match a user entered entries and sum
results of column b

DISCUSSION from Ksaep04:
Thanks for the help. It worked perfect!!!

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

-----------------------------------------------------------------------
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/5808501/4946246/37

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

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

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

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

UPDATED ANSWER on:
Sql Query

ANSWER from Techy001:
I think a value is missing for field [I][B]Diplome[/B][/I]

This might not be the only error. If you are getting some error message,
please post it.

(kccrosser)
You are missing two data fields - "Nom" and "Diplome", so your value fields
don't match the list of field names.

(techy001)
If y...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to make installer of VB.NET including SQL Server 2000?

DISCUSSION from Mrdenny:
Someone with more experience with .NET will need to address the question about
putting the .NET installer in your package.

If your workstations are even close to fully patched then the .NET framework
will already be installed on the machine.

As for the connection string problem no workstations...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Bare minimum templates for Project Management

QUESTION from Jaideepkhanduja:
20 projects, 80 teams members, are engaged. for project management what will be
the bare minimum templates required for best control of the projects. teams are
scattered at various locations. can someone list the name of the templates
required (for complete project management, and covering the whole...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808556/4946246/44

-----------------------------------------------------------------------
UPDATED ANSWER on:
PM Tools for team members

ANSWER from Jaideepkhanduja:
A lot depends on what you want to achieve

It sounds like you're in a good position, as you can use task management skills
rather than project management skills.
I suggest what you probrably need is to evaluate all the project management
tools (including Excel!) using the client as the nominal pr...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Excel Macro to password protect

DISCUSSION from Smarbada:
I understand what this code is doing and how it works but I got it to work once
and then I entered it again using the number 3 rather than 30 to test it and
now it doesn't run. Hum maybe something I did. But thanks so much for your time
on this.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
To retrieve records from SQL Server database

DISCUSSION from Kccrosser:
Carlosdl - you are correct, for the problem cases shown. I overlooked that you
listed all the distinct cases for start/end of fields and blank separators.

When I have encountered this problem in practice, there is usually a
requirement to also find words that may or may not have trailing commas ...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Conditional Formatting - Excel 2003

QUESTION from Lhunter:
Hello, I would like to know how to setup a conditional format for the following
example.

Ex. Column 1: Company
Column 2: Begin Date
Column 3: End Date
Column 4: Exceed Date if >3 (Calculates Column 2 & 3
in Days)

Conditional Format for Column 4: if days exceeded 3 and "eguals...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
ASP.NET and Multiple Access Databases Open

ANSWER from Mshen:
That is possible, but I would recommend you close the database connection after
you get the information that you need from each.

Open Connection
Get Data from database
Close Connection
Work with data

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
(AS/400 - RPG(ILE)) Date-Conversion

ANSWER from Philpl1jb:
the functionality is available

here dateout is 8S 0 in DDMMCCYY and datein is 7S 0 in CYYMMDD

eval dateOut = %UNS(%CHAR(%date(DATEIN : *cymd )
: *eur0))

This will error if DATEIN is invalid so you should put it in
a monitor block.
...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Performane issues on my Subversion (SVN) server on NFS (NetApp)

ANSWER from Mimo:
Hello T0ns,

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Pop-Up Calendar with RPG

DISCUSSION from Mcl:
Here is [A
href="http://www.martinvt.com/Code_Samples/Pop-Up_Calendar/pop-up_calendar.html"
]another[/A]

Regards
Mike

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

-----------------------------------------------------------------------
NEW QUESTION on:
Problems with VAL function

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808553/4946246/53

-----------------------------------------------------------------------
NEW DISCUSSION on:
Microsoft Excel - I need to find rows that match a user entered entries and sum
results of column b

DISCUSSION from Ksaep04:
Thanks for the help. It worked perfect!!!

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

-----------------------------------------------------------------------
NEW QUESTION on:
TextBox problem in Visual Basic .NET 2008

QUESTION from Carlosdl:
How about doing something like this:

when double click the list box:

[CODE]textbox1 = textbox1 & ',' & <data from the list box>[/CODE]

(you will need to parse the resultant data in textbox1)

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808558/4946246/55

-----------------------------------------------------------------------
NEW DISCUSSION on:
What are the containers available in VB 6.0

DISCUSSION from Carlosdl:
You will need to provide more information in order to get some useful
response.

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL+ running time error

ANSWER from Carlosdl:
This could be a permissions problem in vista. Make sure you have write access
to the location where you want to create the spool file.

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

-----------------------------------------------------------------------
NEW ANSWER on:
Why isn't my data displaying in the next page of Gridview?

ANSWER from 2bill:
clicking the "next page" button does a postback to the server. when the server
responds with the page, all the logic for connecting the grid to the datasource
and showing the grid is in your button click handler. this means you have to
click the button to see the grid again (next page). I would thin...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808560/4946246/58

-----------------------------------------------------------------------
NEW QUESTION on:
How to debug a workflow which is in error

QUESTION from Carlosdl:
That will depend on the workflow software you are using, which you did not
specify.

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

-----------------------------------------------------------------------
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/5808501/4946246/60

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

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

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

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

NEW QUESTION on:
Mainframe to Unix Codepage using Connect:Direct

This is the codepage I am using on the from:
SYSOPTS=":CODEPAGE=(IBM-037,IBM-819):ty...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808516/4946246/65

-----------------------------------------------------------------------
MICROSOFT WINDOWS 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/5808501/4946246/66

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

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

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

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

NEW DISCUSSION on:
Microsoft SQL Server certification - Exams 70-432, 70-433 and 70-448

DISCUSSION from DeshRaja:
thank you very Mrdanny for the answer - deshraja

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808502/4946246/71

-----------------------------------------------------------------------
NEW DISCUSSION on:
Remove password

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Access 2007 Report OutputTo Print

DISCUSSION from Riaane:
GGGRRR.... no, still the same problem. I am considering a career in knitting at
this stage. Please, can anyone help on this matter?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808528/4946246/73

-----------------------------------------------------------------------
NEW DISCUSSION on:
Restrict users from browsing my computer

DISCUSSION from SbElectric:
In line with Mshen?s comment ? When you use browse, do you mean RPC into your
computer and see your files or open internet explorer and browse other sites??
- are you thinking about restricting guest users to view your file and
folders? This can be done on Windows XP environment.
You ma...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Excel Macro to password protect

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

-----------------------------------------------------------------------
NEW ANSWER on:
internet Sharing

ANSWER from Technochic:
The way you have phrased this question is very confusing. I really cannot
determine what it is exactly that you re asking. Would you please get someone
to help you re-write it so you can get the assistance you need?Thanks!

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Migrating Windows 2000 Server to Windows Server 2003 0x57 error message

ANSWER from Spadasoe:
Follow this [A href="http://support.microsoft.com/kb/216498"]Link[/A] to remove
the AD metadata information for your replaced server.
****************************
Check your current domain controller to make sure it holds all the FSMO roles.
If there is a problem, check [A href="http://support.mic...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Conditional Formatting - Excel 2003

QUESTION from Lhunter:
Hello, I would like to know how to setup a conditional format for the following
example.

Ex. Column 1: Company
Column 2: Begin Date
Column 3: End Date
Column 4: Exceed Date if >3 (Calculates Column 2 & 3
in Days)

Conditional Format for Column 4: if days exceeded 3 and "eguals...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808533/4946246/78

-----------------------------------------------------------------------
NEW ANSWER on:
Exchange 2003 on Windows Server 2003 full exchange administrator error

ANSWER from Mshen:
To run ForestPrep, you will need to following user permissions on that
account:
Enterprise Administrator
Schema Administrator
Local Machine Administrator (if running on member server only)

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

-----------------------------------------------------------------------
NEW QUESTION on:
Domain Controller or Member Server for Exchange 2007

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808515/4946246/80

-----------------------------------------------------------------------
NEW QUESTION on:
Notes Documents to PDF (based on Lotus Form)

QUESTION from Maramor:
Lotus Domino 6.5

OK we have a Time keeping system that we used in the past. We have a audit
requirement and would like to automate the collection of information needed.
Typically I would open the database, select the view, select the documents and
print to PDF from form typlate.

I am not the...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Microsoft Excel - I need to find rows that match a user entered entries and sum
results of column b

DISCUSSION from Ksaep04:
Thanks for the help. It worked perfect!!!

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808535/4946246/82

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 creating test VM's with Hyper-V

QUESTION from ITKE:
I have setup Windows Server 2008 Enterprise 64x on my desktop and have the
Hyper-V feature
enabled. Is it possible to create test virtual machines on it like XenServer
5.0 /
XenDesktop and VMWare ESX 3i ?

[I]User Submitted[/I]

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808536/4946246/83

-----------------------------------------------------------------------
NEW ANSWER on:
SQL+ running time error

ANSWER from Carlosdl:
This could be a permissions problem in vista. Make sure you have write access
to the location where you want to create the spool file.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808508/4946246/84

-----------------------------------------------------------------------
NEW ANSWER on:
Printing special characters

ANSWER from Mimo:
The problem is the printer drivers. You need to have a PCL drivers. It should
fixe the problem

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

-----------------------------------------------------------------------
NEW ANSWER on:
Rerouting traffic requests based on destination IP range

ANSWER from Mimo:
Frome My point of view their is more thant one answer to your question.

First i would call your client ISP to open the internationnal trafic. their is
no reason except for nationnal security to stop internationnal web site. But
i'm not in your contry.

second if you want to use a proxy use th...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808537/4946246/86

-----------------------------------------------------------------------
NEW QUESTION on:
How can I identify all network system hostnames through CMD?

QUESTION from Labnuke99:
In a Windows network you can use nbtstat -a to identify each machine based on
the IP address.

[CODE]nbtstat -a 192.168.1.5[/CODE]

It will output several lines some on which will have the computers hostname.

To rename the machine you have to be on that computer in order to rename it.

Ther...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808538/4946246/87

-----------------------------------------------------------------------
UPDATED ANSWER on:
Are Hard Drives Destined To Be Extinct?

ANSWER from Mimo:
i'm not an expert on hard drive but here is what I think, It is possible that
hard drive will disapear but I thik that the Flash hard drive will be use more
for getting faster cash I/O than replacing hard drive. Look a the new SUN NAS.
they are using 10k RPM SATA drive disk with flash drive and th...

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

-----------------------------------------------------------------------
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/5808501/4946246/89

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

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

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

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

NEW QUESTION on:
Cannot open website

QUESTION from BPandey:
why i cannot open a specific site from my desktop but it opens up on the dhcp
server within the same network.The same site can be accessed easily from
computers on other networks.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808540/4946246/94

-----------------------------------------------------------------------
NEW DISCUSSION on:
Restrict users from browsing my computer

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

-----------------------------------------------------------------------
NEW ANSWER on:
internet Sharing

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
What questions should I expect for a Network Engineer interview?

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

-----------------------------------------------------------------------
NEW ANSWER on:
Efficiency differences between circuit switching and virtual switching

ANSWER from Sudhanshu:
In circuit switching, circuits are dedicated between source and destination;
whereas in virtual circuits or packet switching, they are not dedicated.

Circuit switching is ideal when data must be transmitted quickly, must arrive
in sequencing order and at a constant arrival rate. Therefore, when t...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to terminate a cable and color arrangement

ANSWER from Chigbie:
It is not really a good idea to make patch cables unless absolutely necessary!
The crimped connectors tend to come loose and be less reliable than factory
made patch cables. You will encounter network problems that are difficult to
diagnose. Having said that, check out this [A href=" http://www.lans...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Router configured one hop from PC with default gateway as IP address

ANSWER from Labnuke99:
Unless the devices are on the same subnet, the traffic would not flow if the
default gateway is across another subnet. You can have multiple routers on a
subnet as needed.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Determine Internet connection type from originating IP Adress

DISCUSSION from Carlosdl:
This is the link:

[A href="http://www.ip-adress.com/ip_tracer/"]IP-address.com - Free IP Tracker
and IP Locator[/A]

http://www.ip-adress.com/ip_tracer/

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808526/4946246/101

-----------------------------------------------------------------------
NEW QUESTION on:
Where did the email really come from?

QUESTION from Labnuke99:
SPAMers will often say that they are in one country when they are actually in
another country.

SPAM is typically sent via a botnet made up of computers all over the internet,
so the SPAM could pretty much be coming from any countery in the world. The
person sending the SPAM could be in any count...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808527/4946246/102

-----------------------------------------------------------------------
NEW ANSWER on:
Rerouting traffic requests based on destination IP range

ANSWER from Mimo:
Frome My point of view their is more thant one answer to your question.

First i would call your client ISP to open the internationnal trafic. their is
no reason except for nationnal security to stop internationnal web site. But
i'm not in your contry.

second if you want to use a proxy use th...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How can I identify all network system hostnames through CMD?

QUESTION from Labnuke99:
In a Windows network you can use nbtstat -a to identify each machine based on
the IP address.

[CODE]nbtstat -a 192.168.1.5[/CODE]

It will output several lines some on which will have the computers hostname.

To rename the machine you have to be on that computer in order to rename it.

Ther...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808538/4946246/104

-----------------------------------------------------------------------
UPDATED ANSWER on:
DNS Pointers

ANSWER from Labnuke99:
The Domain Name System (DNS) is just a way to name your equipment so you don't
need to address everything by IP. Most applications can use both DNS and IP,
so the answer depends on preference. If you don't mind accessing things by IP
address, then it doesn't matter. If you need to access everythi...

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

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

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

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

NEW DISCUSSION on:
PL/SQL - How to make a check whether the attribute is positive or zero

DISCUSSION from Inprise:
Yes it s a database table column,need to check this before DML
operation(INSERT/DELETE) and it s of NUMBER datatype
and it s a procedure parameter

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808497/4946246/107

-----------------------------------------------------------------------
NEW QUESTION on:
how to check address not null but can take -(hyphen) instead being NULL

QUESTION from Inprise:
Hi Experts,

How can we make a check on an attribute not null but can take - rather

I have address 3 which can't take null instead - would be fine

how this can be check n PL/SQL procedure

I can check IF address 3 IS NULL THEN
...
END IF

But i want to test with test case tat it can...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808498/4946246/108

-----------------------------------------------------------------------
NEW ANSWER on:
PL/SQL - Attribute to test not null and can take specific value instead

ANSWER from Carlosdl:
I'm not sure if I understand correctly your question.

If you want to assign some specific value to a varibale or parameter in PL/SQL
when it is null, you could use the NVL function, this way:

[CODE]l_variable := nvl(l_variable,'-');[/CODE]

If this is not what you meant, please provide more ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808499/4946246/109

-----------------------------------------------------------------------
NEW ANSWER on:
Errors in Creating Oracle packages

ANSWER from Carlosdl:
There is more than one error:

- Remove the semicolon and add the IS (or AS) and BEGIN keywords after the
signature definition of the procedure.
- Add the END keyword corresponding to the end of the procedure.

This would be the modified script:

[CODE]CREATE OR REPLACE package body PKG_IMAGE...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808500/4946246/110

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

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

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

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

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

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

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

NEW DISCUSSION on:
Remove password

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808513/4946246/116

-----------------------------------------------------------------------
NEW DISCUSSION on:
Restrict users from browsing my computer

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808529/4946246/117

-----------------------------------------------------------------------
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/5808501/4946246/118

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

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

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

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

NEW DISCUSSION on:
Microsoft SQL Server certification - Exams 70-432, 70-433 and 70-448

DISCUSSION from DeshRaja:
thank you very Mrdanny for the answer - deshraja

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Trouble backing up our SQL Server transaction logs

DISCUSSION from Mrdenny:
Not sure why my answer was removed.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808503/4946246/124

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to make installer of VB.NET including SQL Server 2000?

DISCUSSION from Mrdenny:
Someone with more experience with .NET will need to address the question about
putting the .NET installer in your package.

If your workstations are even close to fully patched then the .NET framework
will already be installed on the machine.

As for the connection string problem no workstations...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
To retrieve records from SQL Server database

DISCUSSION from Kccrosser:
Carlosdl - you are correct, for the problem cases shown. I overlooked that you
listed all the distinct cases for start/end of fields and blank separators.

When I have encountered this problem in practice, there is usually a
requirement to also find words that may or may not have trailing commas ...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5808505/4946246/126

-----------------------------------------------------------------------
NEW DISCUSSION on:
How do I avoid a security exposure using XP_SendMail

DISCUSSION from Mrdenny:
Can you provide more information about what you are trying to do with the
xp_sendmail? I assume because you are using xp_sendmail you are using SQL
2000?

By granting the guest account access to the database, you will be granting
anyone who accesses your SQL Server access to what ever rights the ...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Copying view from remote to local SQL Server with SSMS

DISCUSSION from Tsp1965:
Thanks for that - I had a nasty feeling about that. It seems very sad that
Microsoft have disimproved a system that worked well on ss2k.

Another gripe I have with ss2008 and SSMS is the nightmare it has made of
permissions. When I set up a new table on my development server with ss2k I
could set ...

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

-----------------------------------------------------------------------
NEW ANSWER on:
PL/SQL - Attribute to test not null and can take specific value instead

ANSWER from Carlosdl:
I'm not sure if I understand correctly your question.

If you want to assign some specific value to a varibale or parameter in PL/SQL
when it is null, you could use the NVL function, this way:

[CODE]l_variable := nvl(l_variable,'-');[/CODE]

If this is not what you meant, please provide more ...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL+ running time error

ANSWER from Carlosdl:
This could be a permissions problem in vista. Make sure you have write access
to the location where you want to create the spool file.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808508/4946246/130

-----------------------------------------------------------------------
STORAGE 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/5808501/4946246/131

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

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

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

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

UPDATED ANSWER on:
Looking for email archiving solution

ANSWER from ITKE:
We went through this process two years ago. We looked at HP RISS, Symantec
Evault and Quest Archive Manager. We decided on the Quest solution and are very
happy with it. Symantec gets high marks from Gartner and for good reason; it
was just more expensive and Quest gave us all of the above you are l...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Looking For Midwest Based iSeries Backup & Recovery Services - Hosting Company

ANSWER from Kacerc:
You can also look into Iron Mountain. They do offsite tape storage and
automatic back ups. I would guess they do DR also. kacerc

Check out www.SunGard.com Have used their services in the past. They have
great facilities and very knowledgeable people.

IBM also has a DR facility outside Ch...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Performane issues on my Subversion (SVN) server on NFS (NetApp)

ANSWER from Mimo:
Hello T0ns,

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

-----------------------------------------------------------------------
NEW ANSWER on:
Looking for multi-vendor Storage Virtualization

ANSWER from Billm11:
Depending on your meaning of "simple concept" you could have a look at Datacore
software, I would avoid SAN Melody, but SAN Symphony may meet your requirement.
This is a software application, which runs on a windows-based server
infrastructure, and provides a level of storage virtualisation. You can...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808545/4946246/139

-----------------------------------------------------------------------
NEW QUESTION on:
Backing up entire virtual machines.

QUESTION from ITKE:
I want to backup all my virtual machines, as a whole. Not just files
on a virtual machine, I want to grab the whole virtual machine. Is
there a way to automate this? I have about 10 virtual servers, each has
between 2-5 virtual machines running. I am using Hyper-V

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Are Hard Drives Destined To Be Extinct?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808539/4946246/141

-----------------------------------------------------------------------
NEW ANSWER on:
scsi

ANSWER from Mimo:
i'm not sure I understand your question. if your "What scsi.." mean Why the
answer is that the SCSI protocole was built tike that. If the "what scsi..."
mean What quind of device can be connect to scsi. the answer is anny kind of
scsi device as long as you close the line. mean that the last devic...

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

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

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

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

NEW ANSWER on:
Looking for multi-vendor Storage Virtualization

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808545/4946246/144

-----------------------------------------------------------------------
NEW QUESTION on:
Backing up entire virtual machines.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5808546/4946246/145

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 creating test VM's with Hyper-V

[I]User Submitted[/I]

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

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

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

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

NEW DISCUSSION on:
video conferencing by ip

DISCUSSION from Techy001:
Yes, as Labnuke99 said, it is IP all the way through. I would like to provide
few more info on the same.

H.323 is one of the VoIP protocol which is based on packet-IP network. So,
whatever packet comes it will be flowing through IP (internet).

H.323 uses additional protocols called H.225 an...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
SIP for contact centers

Techy001 writes:

If we make SIP as contact center server, we can gain below functionalities:
1. unified ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5808511/4946246/149

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

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.