Daily Question and Answer Update for Mar 6, 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/6042320/4946246/1
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

NEW ANSWER on:
SQL Server 2000 backup problem using batch file

ANSWER from Mrdenny:
Please post your batch file, as well as the error message you are receiving
when you try to log into CRE. Without this information it is impossable to
guess as to what the problem could be.

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

-----------------------------------------------------------------------
NEW QUESTION on:
PVCS tracker query new or edit problem.

QUESTION from B28b00:
when using PVCS Tracker with query new or edit, there was no response.

PVCS was installed with Oracle version 10, jre1.6 and PVCS was not working.
PVCS was asking to install INET. we installed it using admin ID but the
installation was unsuccessful. Can you send us the INET software so we can...

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

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

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

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

NEW ANSWER on:
What is the role of a network manager?

ANSWER from Coolmech:
A network manager oversees the network, monitoring its performance, security,
error detection, and so on.

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

-----------------------------------------------------------------------
NEW ANSWER on:
Open XL file from ILE program

ANSWER from Yorkshireman:
If it is an interactive session, then you can use the STRPCO command and run
excel from the iSeries

You could configure the 'transfer data from iSeries' button to Excel, and let
them click on that to access the data directly and cut out some of that IFS
nonsense...

If the conversion is batch,...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Alternative for LEFT OUTER JOIN

DISCUSSION from 4knowledgexchng:
Hi..
Am using Hibernate on Postgres

So I am using HQL query and in HQL to use a left outer join the two entities
must be assosiated..
And I cannot assosiate those two entities at this point cos it may tweak the
existing data.
So i wanted an immidiate alternative for left outer join..

And i...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Do I need to understand networking before getting into the VoIP field?

QUESTION from NetworkingATE:
I've been in the telephony field with TDM switching, but there is a trend with
this technology to move toward VoIP. Can you please tell me where I can get
started in learning this technology? Is it better to first understand networks?


VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042357/4946246/8

-----------------------------------------------------------------------
NEW QUESTION on:
How can I get an IT job now if I couldn't in 2005 with my I.S. degree?

QUESTION from NetworkingATE:
I earned a degree in Computer Information Systems (C.I.S.) in 2004. During my
placement year (in 2002) I worked as a software tester at the beginning and
then moved into development. After my degree I was engaged with my family
business, and at the end of 2005 I moved to the UK (to accompany my part...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Locking Forms in Access 2000

ANSWER from RoadDust:
Hi,

I would set the Allow Edits and Allow Deletions properties for the form to No
and the Allow Additions to Yes. This will allow the user to add new records
but not be able to edit existing records.

Dustin

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
help on Bulk insert and xp_cmdshell rename

ANSWER from Carlosdl:
As for the insert , the problem seems to be that you have defined an incorrect
row terminator. You should be using 'n' instead of '/n'.

To rename the file, try something like this:

[CODE]declare @command varchar(1000)
set @command = 'rename c:table.csv table_old.csv'
exec master.dbo.xp_cm...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Combining fields to create a unique ID in Microsoft Access

DISCUSSION from FSUResA:
It did help. I actually created the combination with the expression builder in
a query using the "&" to join the fields.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to Determine Database Access on AS/400

ANSWER from Philpl1jb:
It's the object security that's important

DSPOBJAUT mylib/myfile
Individuals/Groups/*PUBLIC may be granted use/change and when you press F11 it
steps through more details
ie: read/change/delete exist (they could delete the actual file) alteer to
change the file structure etc.

Phil

Hi,

...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

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

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

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

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

NEW ANSWER on:
What is the role of a network manager?

ANSWER from Coolmech:
A network manager oversees the network, monitoring its performance, security,
error detection, and so on.

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

-----------------------------------------------------------------------
NEW ANSWER on:
AS/400 - Don't prompt me for user/pass when starting 5250 emulator

ANSWER from Yorkshireman:
The 5250 SDLC access is for interactive access - so it's predicated on there
being a person in front of the glass.
You don't want real people getting to your data without authorisation, so it
wants a user id and password.

Maybe you need to rethink the data access route and get the data you nee...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Increasingly lengthy SAVSYS times

ANSWER from Yorkshireman:
I assume you have analysed the content of the SAVSYS data? and minimised it?

Then run some DSPOBJD reports to files, and query them by owner ID.

You should have some figurative profiles on the system - QPGMR is a favourite,
and maybe QUSER.

Set up individual profiles to be members of the a...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Solaris virtualization techniques

ANSWER from Ranger2k:
There are 2 methods of virtualizing a Solaris 10 server:
1. Container / Zones
2. LDOMS
Quoting Sun's website - "Solaris Containers isolate software applications and
services using flexible, software-defined boundaries. Solaris Containers allow
many private execution environments be created within...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042324/4946246/19

-----------------------------------------------------------------------
NEW QUESTION on:
Memory for Mac OS X

QUESTION from Kimmer:
I need to add memory to my MAC and cannot figure out what I need. It is a MAC
OSX G4, serial # W82350TXL3V. I am really in need of the exact, specific type
of memory to order. Thank you!

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

-----------------------------------------------------------------------
NEW QUESTION on:
How can I get an IT job now if I couldn't in 2005 with my I.S. degree?

QUESTION from NetworkingATE:
I earned a degree in Computer Information Systems (C.I.S.) in 2004. During my
placement year (in 2002) I worked as a software tester at the beginning and
then moved into development. After my degree I was engaged with my family
business, and at the end of 2005 I moved to the UK (to accompany my part...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042326/4946246/21

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
iSeries Access printing with Lexmark 2381 printer

DISCUSSION from Bigmac46:
Toip of form response reminded me that you also need to set the TEAR OFF
position. That info is also in the 2400 series guide.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Does more memory will help

DISCUSSION from Coolmech:
CPU utilization has direct effect on the amount of RAM and more importantly the
clock speed of the installed RAM module. Improving the clock speed of the CPU
(by upgrading or overclocking) will enchance the application performance. The
100% utilization of CPU refers to the processor running at its p...

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

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

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

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

NEW DISCUSSION on:
database

DISCUSSION from Findsarfaraz:
Can you post a link to SQLlite... is it free or open source... or both.

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

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

-----------------------------------------------------------------------
NEW QUESTION on:
Showing Records when Setting Criteria

QUESTION from Hritguy:
Goal: To show all customer orders. Along with those orders, I want to show all
related notes on the progress for filling those orders. Problem: Some orders
have no notes. When I set the criteria to show all orders and to show the
notes, only orders with notes now appear in the report.
Question: Is...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Oracle database and Crystal

ANSWER from Cairmor:
in Crystal XI after opening a new blank report to create a connection to Oracle
Database,
- right click on Databse Fileds --> Database Expert (or menu Database -->
Database Expert)
- click on create new connection
- one of the option is Oracle where you can defne the server from which you
...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Crystal Reports XI: Multi-Level subreports?

ANSWER from Cairmor:
A subreport can never have a subreport in any version of Crystal. A main
report can have several subreports, however.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Are you using Excel for cost estimating?

ANSWER from Labnuke99:
I have used EXCEL extensively in this process, although I'm not right now and I
do not have copies of the materials I developed as this was sensitive data that
I'm sure my previous employers would not approve. I was a consultant for many
years and I found that every organization had EXCEL and it pr...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042353/4946246/30

-----------------------------------------------------------------------
NEW QUESTION on:
EDI - Required Fields and Elements

QUESTION from HIPAAnalyst:
EDI transactions have required and situational/optional segments. Within a
required segment you may have required and situational/optional elements. My
question is, do all values within a required element must be implemented/used
or is it possible to use some (but not all) values within that require...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042378/4946246/31

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

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

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

NEW ANSWER on:
AS/400 - Don't prompt me for user/pass when starting 5250 emulator

ANSWER from Yorkshireman:
The 5250 SDLC access is for interactive access - so it's predicated on there
being a person in front of the glass.
You don't want real people getting to your data without authorisation, so it
wants a user id and password.

Maybe you need to rethink the data access route and get the data you nee...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Using SOAP with iSeries

ANSWER from Yorkshireman:
Have you tried the Lansa guys?
IME they have some pretty heavyweight techy guys in the cupboards, and if you
haven't already presented thenm with the problem, they may have a ready made
solution, or have another client who has had the same problem.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
New Web Service Project

ANSWER from Yorkshireman:
Web Services and the 'Power i' ( !)

Go to Scott Klements most excellent open source product FTPAPI - start at
ScottKlement.com - any sort of web search will find it.

Inspecting the code, reading through the forms, l

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Alternative for LEFT OUTER JOIN

DISCUSSION from 4knowledgexchng:
Hi..
Am using Hibernate on Postgres

So I am using HQL query and in HQL to use a left outer join the two entities
must be assosiated..
And I cannot assosiate those two entities at this point cos it may tweak the
existing data.
So i wanted an immidiate alternative for left outer join..

And i...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Showing Records when Setting Criteria

QUESTION from Hritguy:
Goal: To show all customer orders. Along with those orders, I want to show all
related notes on the progress for filling those orders. Problem: Some orders
have no notes. When I set the criteria to show all orders and to show the
notes, only orders with notes now appear in the report.
Question: Is...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Finding the average of a data type on a SQL Server

ANSWER from Carlosdl:
I don't see the AVG operator in your code, in the first place.

The message means that you cannot calculate the average of a varchar type field
(and you are converting to varchar some of the columns). If that was possible,
you could calculate the average for 'spring' and 'summer', for example.

...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Locking Forms in Access 2000

ANSWER from RoadDust:
Hi,

I would set the Allow Edits and Allow Deletions properties for the form to No
and the Allow Additions to Yes. This will allow the user to add new records
but not be able to edit existing records.

Dustin

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
double quotes with InStr method

DISCUSSION from Thongtarget21:
Thanks Dustin. I'm going to try that out.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042380/4946246/40

-----------------------------------------------------------------------
NEW DISCUSSION on:
What language "Next" from RPG(LE)

DISCUSSION from KSoniat:
Thanks guys, that's exactly the info I am looking for...
I thought it was "just me" on the web languages coming and going.

Regards,
K

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042294/4946246/41

-----------------------------------------------------------------------
NEW QUESTION on:
Event fires for all collection members when one member triggers?

QUESTION from Zybron:
I have a usercontrol that contains a collection as a list(of <custom class>).
Within the collection class for this usercontrol I have a shared event that is
raised when a collection member is added to the class. Within the usercontrol
class I have an event that is triggered when the collection class...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042381/4946246/42

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/43

-----------------------------------------------------------------------
NEW ANSWER on:
OracleClient

ANSWER from Carlosdl:
What exactly do you mean by "The system did not support". Are you getting an
error ? what is the exact error message ?

What version of the .NET framework have you installed ?

You might need to [A
href="http://www.microsoft.com/downloads/details.aspx?FamilyID=4f55d429-17dc-45e
a-bfb3-076d1c05.
..

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

-----------------------------------------------------------------------
NEW ANSWER on:
Disable Form Controls in VB 2008 until selected

ANSWER from Straub:
On the form load event set all the controls enabled property to false such as
control1.enabled=false

Then on the datetimepicker1.change or datetimepicker1.lostfocus event set all
the controls to
control1.enabled=true

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

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

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

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

NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/47

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 - Error 0x80094801 Denied by Policy Module

QUESTION from CraiglL:
Hi im trying to import a certificate request from a Linux server on a windows
2008 enterprise certificate authority domain controller. The certificate is in
PKCS10 format. When I try to import it using the Microsoft certification
authority tool I receive the following message:

Log Name: Appl...

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

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

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

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

NEW DISCUSSION on:
print to HP OfficeJet 7780

DISCUSSION from Avensis:
hello there, sorry to hear of your printer troubles, how frustrating. The first
2 answers probably hold more water than this but i was curious and had to take
a look. You may have already looked at this page but give it a whirl
http://h10025.www1.hp.com/ewfrf/wc/document?docname=c01548600&lc=en&dlc...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042276/4946246/50

-----------------------------------------------------------------------
NEW DISCUSSION on:
SharePoint-questions and answers section

DISCUSSION from Stix:
JIschu-No, nothing yet i'm afraid

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042347/4946246/51

-----------------------------------------------------------------------
NEW ANSWER on:
Open XL file from ILE program

ANSWER from Yorkshireman:
If it is an interactive session, then you can use the STRPCO command and run
excel from the iSeries

You could configure the 'transfer data from iSeries' button to Excel, and let
them click on that to access the data directly and cut out some of that IFS
nonsense...

If the conversion is batch,...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
DNS issue within the local network

DISCUSSION from Fahad:
Petkoa,

Thank you for your detailed explanation,

I wanted to confirm that can we assign multiple IP addresses on a single port
on a Router just
as you have mentioned, where you said that we can redirect the UDP traffic
entering the default gateway of the Router to the DNS Server .

My other...

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

-----------------------------------------------------------------------
NEW QUESTION on:
instant search won't work on business contact but works on contacts outlook
2007

QUESTION from Mjullie1:
I recently loaded business contact manager on to my outlook 2007 program.
Instant search works on contacts, but not on business contacts.
Does Instant Search work on Business Contact Manager? If so how is it set up?

Also, What is the file called that holds the Business contacts and What is
i...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042348/4946246/54

-----------------------------------------------------------------------
UPDATED ANSWER on:
Transfer of an computer with OEM XP to a new user.

ANSWER from S99abx:
You are right.
AS Long as u keep the original Proccessor, and HDD.
A Windows XP OEM license lets you install Windows XP on that system only.
You can reinstall the OS as many times as you want, but you cannot use the
CD-Key on any other Factory installed OS systems like DELL or Gateway etc....
Y...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Memory for Mac OS X

QUESTION from Kimmer:
I need to add memory to my MAC and cannot figure out what I need. It is a MAC
OSX G4, serial # W82350TXL3V. I am really in need of the exact, specific type
of memory to order. Thank you!

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server 2000 backup problem using batch file

ANSWER from Mrdenny:
Please post your batch file, as well as the error message you are receiving
when you try to log into CRE. Without this information it is impossable to
guess as to what the problem could be.

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

-----------------------------------------------------------------------
NEW QUESTION on:
What value is a Cisco or Microsoft certification to a Telecom Engineer?

QUESTION from NetworkingATE:
I have a Bachelor of Science (B.Sc.) degree in Telecommunication Engineering,
with a main emphasis on Global System for Mobile Communications (GSM), code
division multiple access (CDMA), Wireless Local Loop (WLL) and WiMax. I'm not
sure if all this is in high-demand in the world -- especially in the...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Samsung Omnia and Opera Browser.

DISCUSSION from JennyMack:
Hi there,

I wish I could provide a better answer, but the issue might be with ActiveSync
itself -- I would say, if you can't find a workaround, try repairing the
software, or doing a fresh install. That may resolve it for you.

Thanks,
Jenny

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Inter-Forest Exchange Migration from Exchange 2003 to Exchange 2007

DISCUSSION from JBoslooper:
Hello,

Is there anyone with an answer for this scenario?

I have roughly the same situation. 2 Separate Forests, joined by a trust. I
need to migrate from one Exchange 2007 server to another Exchange 2007 server
(Inter-Forest).

I know about ExMerge however with the new and almighty Excha...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Combining fields to create a unique ID in Microsoft Access

DISCUSSION from FSUResA:
It did help. I actually created the combination with the expression builder in
a query using the "&" to join the fields.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042352/4946246/61

-----------------------------------------------------------------------
NEW QUESTION on:
Exchange 2003 distribution group receiving only internal email

QUESTION from Technochic:
Are the people who are sending to the group getting a non-delivery report? Are
they sending to the correct address? Internally it might be pg-company
distribution group, but the address to send to externally might be
distgroup1@company.com or something like that. Check to see what the email
address ...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Are you using Excel for cost estimating?

ANSWER from Labnuke99:
I have used EXCEL extensively in this process, although I'm not right now and I
do not have copies of the materials I developed as this was sensitive data that
I'm sure my previous employers would not approve. I was a consultant for many
years and I found that every organization had EXCEL and it pr...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/64

-----------------------------------------------------------------------
NEW DISCUSSION on:
Reboot error

DISCUSSION from Technochic:
What is the Operating System and service Pack level please? When did the error
start? Were there any changes made prior to this showing up? If so, what were
they and can you un-do them?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042354/4946246/65

-----------------------------------------------------------------------
NEW DISCUSSION on:
iSeries Access printing with Lexmark 2381 printer

DISCUSSION from Bigmac46:
Toip of form response reminded me that you also need to set the TEAR OFF
position. That info is also in the 2400 series guide.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Does more memory will help

DISCUSSION from Coolmech:
CPU utilization has direct effect on the amount of RAM and more importantly the
clock speed of the installed RAM module. Improving the clock speed of the CPU
(by upgrading or overclocking) will enchance the application performance. The
100% utilization of CPU refers to the processor running at its p...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042327/4946246/67

-----------------------------------------------------------------------
NEW DISCUSSION on:
Difference between Win XP and Win2k Pro

DISCUSSION from Coolmech:
There is not much difference between windows 2000 professional and XP
professional.
Apart from a few basic changes like, Windows XP is more generally more user
friendly as compared to Windows 2000 professional like XP offers a number of
helpful safety tools like easy login and log off, XP offers en...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042355/4946246/68

-----------------------------------------------------------------------
NEW QUESTION on:
Understand Event Viewer - Delete Action on Folders - Event ID 560

QUESTION from Maryam82:
I've enabled audit logs on several folders on windows server 2003 environment.
It records the deleted action on folder and sub-folder.

The problem is I want to make sure, that when I see Delete in Accesses field,
it is for certain the user deleted the folder/file.

When replicating the action, ...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042356/4946246/69

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 - Error 0x80094801 Denied by Policy Module

QUESTION from CraiglL:
Hi im trying to import a certificate request from a Linux server on a windows
2008 enterprise certificate authority domain controller. The certificate is in
PKCS10 format. When I try to import it using the Microsoft certification
authority tool I receive the following message:

Log Name: Appl...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042345/4946246/70

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

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

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

NEW ANSWER on:
Blackberry Services on "used" blackberry

ANSWER from KarlG:
Blackberry has a Windows Mobile app now that will turn a windows mobile 6 or
better device into a real push blackberry. You did not say what phone you
currently have - but that is what it will depend on. To find out more about
this check out this link:

http://www.downloadsquad.com/2008/12/18/blac...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Samsung Omnia and Opera Browser.

DISCUSSION from JennyMack:
Hi there,

I wish I could provide a better answer, but the issue might be with ActiveSync
itself -- I would say, if you can't find a workaround, try repairing the
software, or doing a fresh install. That may resolve it for you.

Thanks,
Jenny

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

-----------------------------------------------------------------------
NEW QUESTION on:
Unable to view Company Directory / GAL on mobile device

QUESTION from Gillyt:
I just setup a couple of device using Exchange Active sync. Everything is
working fine except being able to view the company director / gal. When i type
a name to do a search it gives the message " the search could not be completed.
Please try again later" How do enable access to it?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042338/4946246/74

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/75

-----------------------------------------------------------------------
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/6042275/4946246/76

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

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

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

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

NEW ANSWER on:
What is the role of a network manager?

ANSWER from Coolmech:
A network manager oversees the network, monitoring its performance, security,
error detection, and so on.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042323/4946246/81

-----------------------------------------------------------------------
NEW DISCUSSION on:
print to HP OfficeJet 7780

DISCUSSION from Avensis:
hello there, sorry to hear of your printer troubles, how frustrating. The first
2 answers probably hold more water than this but i was curious and had to take
a look. You may have already looked at this page but give it a whirl
http://h10025.www1.hp.com/ewfrf/wc/document?docname=c01548600&lc=en&dlc...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
New Web Service Project

ANSWER from Yorkshireman:
Web Services and the 'Power i' ( !)

Go to Scott Klements most excellent open source product FTPAPI - start at
ScottKlement.com - any sort of web search will find it.

Inspecting the code, reading through the forms, l

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042286/4946246/83

-----------------------------------------------------------------------
NEW DISCUSSION on:
DNS issue within the local network

DISCUSSION from Fahad:
Petkoa,

Thank you for your detailed explanation,

I wanted to confirm that can we assign multiple IP addresses on a single port
on a Router just
as you have mentioned, where you said that we can redirect the UDP traffic
entering the default gateway of the Router to the DNS Server .

My other...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Do I need to understand networking before getting into the VoIP field?

QUESTION from NetworkingATE:
I've been in the telephony field with TDM switching, but there is a trend with
this technology to move toward VoIP. Can you please tell me where I can get
started in learning this technology? Is it better to first understand networks?


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

-----------------------------------------------------------------------
NEW QUESTION on:
What value is a Cisco or Microsoft certification to a Telecom Engineer?

QUESTION from NetworkingATE:
I have a Bachelor of Science (B.Sc.) degree in Telecommunication Engineering,
with a main emphasis on Global System for Mobile Communications (GSM), code
division multiple access (CDMA), Wireless Local Loop (WLL) and WiMax. I'm not
sure if all this is in high-demand in the world -- especially in the...

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

-----------------------------------------------------------------------
NEW QUESTION on:
How can I get an IT job now if I couldn't in 2005 with my I.S. degree?

QUESTION from NetworkingATE:
I earned a degree in Computer Information Systems (C.I.S.) in 2004. During my
placement year (in 2002) I worked as a software tester at the beginning and
then moved into development. After my degree I was engaged with my family
business, and at the end of 2005 I moved to the UK (to accompany my part...

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

-----------------------------------------------------------------------
NEW QUESTION on:
how to measure network speed on wan

QUESTION from Mahaveers:
how to monitor the network speed on wan accurately.
i did a tacert and path ping n i just got 2 hops staistics and trace was
complete without any error , however the time it took was 318 ms average , i
tried the trace from both the sides(ends) of the WAN i got the same average
time of 318ms, my net...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042358/4946246/88

-----------------------------------------------------------------------
ORACLE 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/6042275/4946246/89

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

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

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

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

UPDATED ANSWER on:
Oracle database and Crystal

ANSWER from Cairmor:
in Crystal XI after opening a new blank report to create a connection to Oracle
Database,
- right click on Databse Fileds --&gt; Database Expert (or menu Database --&gt;
Database Expert)
- click on create new connection
- one of the option is Oracle where you can defne the server from which you
...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle Request Set Run Time Log File Posting

ANSWER from Carlosdl:
You are using PUT_LINE, from what package ? UTL_FILE ?

If so, you could use the procedure FFLUSH.

FFLUSH physically writes pending data to the file when called.

Depending on how often you are writing to the file, you could also open and
close the file each time you need to write to it. Wh...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Calling a report from a form

ANSWER from Long4short:
expired passwords will let you into the application but will inhibit doing
certain things amoung which is opening reports......change the password and try
again.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to Determine Database Access on AS/400

ANSWER from Philpl1jb:
It's the object security that's important

DSPOBJAUT mylib/myfile
Individuals/Groups/*PUBLIC may be granted use/change and when you press F11 it
steps through more details
ie: read/change/delete exist (they could delete the actual file) alteer to
change the file structure etc.

Phil

Hi,

...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Oracle BI Ad-Hoc graph - Trying to have numeric value appear above bar chart
columns

QUESTION from Nanapap2:
An Oracle BI Ad-Hoc report has been created and the data format for numeric
fields is set to be Custom 999999.
When the bar chart is displayed, selecting "Show Data Labels for bars" in the
"Plot Area" tab of "Edit Graph", It is placing a value such as 15.00 instead of
15. Also it will place a value...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/99

-----------------------------------------------------------------------
NEW ANSWER on:
OracleClient

ANSWER from Carlosdl:
What exactly do you mean by "The system did not support". Are you getting an
error ? what is the exact error message ?

What version of the .NET framework have you installed ?

You might need to [A
href="http://www.microsoft.com/downloads/details.aspx?FamilyID=4f55d429-17dc-45e
a-bfb3-076d1c05.
..

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

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

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

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

NEW ANSWER on:
SAP on iSeries

ANSWER from Yorkshireman:
SAP released SAP on Iseries, and IBM approved - have you looked at their
respective web sites? trolled through the various other sappy forums?

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042279/4946246/102

-----------------------------------------------------------------------
NEW DISCUSSION on:
SAP Business One 2007 - Create user

DISCUSSION from JewelsNorth:
Hi. Were you able to find a demo userid and password for the SAP Business One?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/6042360/4946246/103

-----------------------------------------------------------------------
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/6042275/4946246/104

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

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

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

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

NEW QUESTION on:
isa 2004 server

QUESTION from 27015111:
Hi,
I am planinig to install isa 2004 server in my DC.[win 2003 server ]
But My DC is configured to single ehernet card.
Should i install 2nd N/W card to boost ISA 2004 Performence or a Single Card
will do.
We are not planning for Hardware Firewall in near future.
Thanks alot
Badri


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

-----------------------------------------------------------------------
NEW ANSWER on:
Copying our disaster recovery database on a SQL Server

ANSWER from Mrdenny:
There isn't really an easy way to do this.

About the easiest way to do it would be to stop the SQL Service on the DR
server, and copy the database files. Then restart the datbase serer. Then
attach the copied files as another database name. How quick it backs up will
depend on how large the da...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Kerberos and client accsess

QUESTION from Braz:
We just rolled out Kerberos for our AS400 users and a question came up with EIM
is there a way to set up a windows login and then that creates the AS400 user
id or reverse it and set up the AS400 user and have that then create the
windows exchange login.

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042296/4946246/111

-----------------------------------------------------------------------
NEW DISCUSSION on:
SAP Business One 2007 - Create user

DISCUSSION from JewelsNorth:
Hi. Were you able to find a demo userid and password for the SAP Business One?

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Checklists for Router, Firewall and Switch security

ANSWER from Rklanke:
Check NIST for various publications.

[A href="http://www.nist.org/nist_plugins/content/content.php?content.28"]NIST
SP 800-70 Security Configuration Checklists Program for IT Products[/A]

(The below SP 800-70 description is from NIST.gov, edited)

The Security Configuration Checklists Progra...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Windows Server 2008 - Error 0x80094801 Denied by Policy Module

QUESTION from CraiglL:
Hi im trying to import a certificate request from a Linux server on a windows
2008 enterprise certificate authority domain controller. The certificate is in
PKCS10 format. When I try to import it using the Microsoft certification
authority tool I receive the following message:

Log Name: Appl...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042345/4946246/115

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

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

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

NEW DISCUSSION on:
Linked server problems

DISCUSSION from KH:
Have you configured SQL 2005 to accept remote connections?
[B]Yes[/B]

Are you sure that the instance name is correct?
[B] Yes[/B]

Are you able to connect to the SQL 2005 instance from the other server?

[B] The machine where SQl 2005 is installed also has SQL2000 on it if i go
in...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Copying our disaster recovery database on a SQL Server

ANSWER from Mrdenny:
There isn't really an easy way to do this.

About the easiest way to do it would be to stop the SQL Service on the DR
server, and copy the database files. Then restart the datbase serer. Then
attach the copied files as another database name. How quick it backs up will
depend on how large the da...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server 2000 backup problem using batch file

ANSWER from Mrdenny:
Please post your batch file, as well as the error message you are receiving
when you try to log into CRE. Without this information it is impossable to
guess as to what the problem could be.

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

-----------------------------------------------------------------------
NEW ANSWER on:
iSeries to SQL Server via SSIS 2005

ANSWER from Mrdenny:
You can use a script task with SSIS to change the connection string values as
well as the values of other objects within the package.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Deciding on a RAID Level for a 64-bit SQL Server 2005

ANSWER from Mrdenny:
RAM is dependant on the application that you are running. But since you have 4
drives, I would suggest raid 1+0. That would give you 1 TB of disk space.

The RAID level that you select will depend on what kind of load you'll be
placing on the database. If you are using a low IO database applica...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Finding the average of a data type on a SQL Server

ANSWER from Carlosdl:
I don't see the AVG operator in your code, in the first place.

The message means that you cannot calculate the average of a varchar type field
(and you are converting to varchar some of the columns). If that was possible,
you could calculate the average for 'spring' and 'summer', for example.

...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
help on Bulk insert and xp_cmdshell rename

ANSWER from Carlosdl:
As for the insert , the problem seems to be that you have defined an incorrect
row terminator. You should be using 'n' instead of '/n'.

To rename the file, try something like this:

[CODE]declare @command varchar(1000)
set @command = 'rename c:table.csv table_old.csv'
exec master.dbo.xp_cm...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Upgrading to a 64-bit SQL Server 2005 environment

DISCUSSION from Naterw:
32 bit or 64 bit the rules for memory are the same really. Watch your page
life expectancy counter primarily and if it's very low (below 300) you need
more memory, if it's very high (hundreds of thousands) you could make due with
less memory.

As a general rule for my systems I like to keep mem...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/125

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

ANSWER from Technochic:
Here is an [A
href="http://www.microsoft.com/sqlserver/2005/en/us/features.aspx"]excellent
web page[/A] to help you.

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

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

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

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

NEW ANSWER on:
Copying our disaster recovery database on a SQL Server

ANSWER from Mrdenny:
There isn't really an easy way to do this.

About the easiest way to do it would be to stop the SQL Service on the DR
server, and copy the database files. Then restart the datbase serer. Then
attach the copied files as another database name. How quick it backs up will
depend on how large the da...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Server 2000 backup problem using batch file

ANSWER from Mrdenny:
Please post your batch file, as well as the error message you are receiving
when you try to log into CRE. Without this information it is impossable to
guess as to what the problem could be.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Deciding on a RAID Level for a 64-bit SQL Server 2005

ANSWER from Mrdenny:
RAM is dependant on the application that you are running. But since you have 4
drives, I would suggest raid 1+0. That would give you 1 TB of disk space.

The RAID level that you select will depend on what kind of load you'll be
placing on the database. If you are using a low IO database applica...

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

-----------------------------------------------------------------------
NEW ANSWER on:
VMware ESX 3.5 Backup Exec 12.5 error message

ANSWER from Quincy:
See Symantec Support document explaining below:

Document ID: 311188
http://support.veritas.com/docs/311188 E-Mail this document to a colleague
Vmware ESX 3.5 backup fails with error " Final error: 0xe000955b - Cannot run
the Vmware VCB command 'vcbmounter.exe'. Ensure that the Vmware VCB fram...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/6042363/4946246/131

-----------------------------------------------------------------------
NEW DISCUSSION on:
BRMS using newly expired tapes

DISCUSSION from AnchorS:
Hi, it's my understanding that BRMS will look to the epired tapes, then use the
least used tape (media uses). Unfortunately it's hard to control the usage of
expired tapes as BRMS is attempting to spread the wear and tear on all tapes.
As per IBM, we can not control that, other than making the t...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

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

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

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

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

NEW ANSWER on:
Solaris virtualization techniques

ANSWER from Ranger2k:
There are 2 methods of virtualizing a Solaris 10 server:
1. Container / Zones
2. LDOMS
Quoting Sun's website - "Solaris Containers isolate software applications and
services using flexible, software-defined boundaries. Solaris Containers allow
many private execution environments be created within...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Virtual Center Server and Double Take with ESXi Enterprise Version

ANSWER from Mrdenny:
It should work fine as the Central Server is simply a SQL Server database.

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

-----------------------------------------------------------------------
NEW ANSWER on:
VMware ESX 3.5 Backup Exec 12.5 error message

ANSWER from Quincy:
See Symantec Support document explaining below:

Document ID: 311188
http://support.veritas.com/docs/311188 E-Mail this document to a colleague
Vmware ESX 3.5 backup fails with error " Final error: 0xe000955b - Cannot run
the Vmware VCB command 'vcbmounter.exe'. Ensure that the Vmware VCB fram...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/138

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V quick migration vs. live migration

QUESTION from ITKE:
What is the difference between Quick Migration and Live Migration in Hyper-V?
Is one preferred over the other?

[I]user submitted[/I]

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042366/4946246/139

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

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

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

NEW QUESTION on:
Do I need to understand networking before getting into the VoIP field?

QUESTION from NetworkingATE:
I've been in the telephony field with TDM switching, but there is a trend with
this technology to move toward VoIP. Can you please tell me where I can get
started in learning this technology? Is it better to first understand networks?


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

-----------------------------------------------------------------------
NEW QUESTION on:
What value is a Cisco or Microsoft certification to a Telecom Engineer?

QUESTION from NetworkingATE:
I have a Bachelor of Science (B.Sc.) degree in Telecommunication Engineering,
with a main emphasis on Global System for Mobile Communications (GSM), code
division multiple access (CDMA), Wireless Local Loop (WLL) and WiMax. I'm not
sure if all this is in high-demand in the world -- especially in the...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042350/4946246/142

-----------------------------------------------------------------------
NEW QUESTION on:
Join our ITKnowledgeExchange.com LinkedIn group

QUESTION from ITKE:
We have created an[A
href="http://www.linkedin.com/groups?gid=1833776&trk=hb_side_g"]
ITKnowledgeExchange.com LinkedIn Group[/A]

If you are a member of LinkedIn come and join the group. You will be able to
continue the discussion or post questions that we will post onto the site.

Thanks
Sean
...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/6042301/4946246/143

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

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

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

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

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

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

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

Copyright 2009 TechTarget. All rights reserved.