Daily Question and Answer Update for Feb 18, 2009

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

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

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

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

NEW DISCUSSION on:
PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being
NULL

DISCUSSION from Inprise:
i can't use trigger,i hav to implement IF... THEN approach only within the
procedure

I used IF (p_street 3 IS NULL) THEN
raise_app_err(.....)
ELSE IF .......this s the place where i shud ensure to check street 3 shud take
only alphanumberic or hyphen
so i tried to use REGEXP_LIKE(p_street 3...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880706/4946246/2

-----------------------------------------------------------------------
UPDATED ANSWER on:
How can I pass tablename as a parameter in MySQL stored procedure?

ANSWER from Carlosdl:
It would be something [B][I]similar[/I][/B] to this:

[CODE]CREATE PROCEDURE test
( ImageID varchar(10),
Stat varchar(1),
tablename varchar(200))
BEGIN
SET @s = CONCAT('INSERT INTO ',tablename,' (ImageId,Status) values
(',ImageID,',',Stat,')')
PREPARE stmt FROM @s;
EXECUTE stmt;
DEAL...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880711/4946246/3

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

DISCUSSION from Arlin:
I ended up using the following in my query:

Expr2: CInt([Table_Field])

Worked fine.

Thanks,
Arlin

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880765/4946246/4

-----------------------------------------------------------------------
NEW DISCUSSION on:
What is difference between Clustered Index and Non-Cluster Index?

DISCUSSION from Mrdenny:
A clustered index doesn't actually change the order that the data is physically
sorted in. It used to back in SQL 6.5, but it hasn't since then.

I posted about the [A
href="http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-cluste
red-vs-nonclustered-indexes-whats-the-differen...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880766/4946246/5

-----------------------------------------------------------------------
NEW DISCUSSION on:
SQL Server does not exist or Access Denied Error

DISCUSSION from Mrdenny:
Server does not exist or access denied isn't an authentication problem. See
link I posted above.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Temporary recordset in MS Access VBA

DISCUSSION from Randym:
You say that you bind the form to the read only database. This is why you
can't make changes to the fields. If you don't want a temp table, you will
probably need to leave the form unbound and manully set the value of each field
from the recordset. Then when you make a change to the field and u...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
In-Memory Database

DISCUSSION from Msi77:
I didn't work with in-memory databases, but I believe that they resides in
memory (24x7), i.e. loading process is not a regular thing.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880768/4946246/8

-----------------------------------------------------------------------
NEW QUESTION on:
Combo search box - "Invalid Outside Proceedure"

QUESTION from Abaumeister:
..and before you ask, no I don't use anything linked into Access 2007 to
program my database.

So, I've been creating a form coming from the same table with the same
information to be used as a separate edit form. And now suddenly my "search
box" gets this error in my normal form. HELP!

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to move the msdb database to sql 2005

DISCUSSION from Bubbanm:
Thanks, what would be the best way to move the data over after I get the
database moved over

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
PL/SQL

DISCUSSION from Carlosdl:
Remember to set serveroutput on if you run your procedure from sql*plus.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880709/4946246/11

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

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

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

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

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

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

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

NEW DISCUSSION on:
Have you moved to online backup for your corporation and if so, are you still
using tape backup?

DISCUSSION from Nevermore929:
I was tasked by my boss to evaluate Iron Mountain's TEMS solution. The most
difficult part of the evaluation is finding a company that uses the email
archiving piece, and asking them a few of our questions. I know Iron Mountain
can provide us with some references, but we wanted to find our own firs...

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880719/4946246/17

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

DISCUSSION from KevinBeaver:
Maybe she could just tell you the password...? ;-) Check out this article I
wrote on BIOS password hacking - may have a few more tidbits you can use:
http://searchenterprisedesktop.techtarget.com/generic/0,295582,sid192_gci1206494
,00.html

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880720/4946246/18

-----------------------------------------------------------------------
NEW QUESTION on:
Cisco ASA WebVPN - Clientless SSL user sessions keeps dropping

QUESTION from OrangeNewbie:
I am having an issue where a Cisco ASA configured with WebVPN (Clientless SSL)
user access.
Connection via NT domain authentication is successful, and it is possible to
browse a CIFS share, however randomly (4 secs to about a minute) the session is
terminated with an idle timeout message.
I have c...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880721/4946246/19

-----------------------------------------------------------------------
UPDATED ANSWER on:
Submitting a batch job from a C program

ANSWER from Mrlchile:
I meant SBMJOB.

Yes, you can. Use the system() call to execute a CL command in a C program.
It can be found in the ILE C/C++ Run-Time Library Functions manual.
SC41-5607-02. You can use it to execute your SBMJOB command. Works great.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880695/4946246/20

-----------------------------------------------------------------------
NEW ANSWER on:
Checklist for managing risk of Data Center power shutdown

ANSWER from Sunsetrider:
This sounds like a disaster recovery excercise.

You need to have an inventory of hardware so that when you restart your data
centre, if you run into any problems, you can quickly get replacement parts
(hard drives, power supplies, etc.). Make sure you have quick access to your
off-site data b...

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

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

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

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

UPDATED ANSWER on:
How can I pass tablename as a parameter in MySQL stored procedure?

ANSWER from Carlosdl:
It would be something [B][I]similar[/I][/B] to this:

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880711/4946246/23

-----------------------------------------------------------------------
NEW QUESTION on:
IT requiement

QUESTION from Nikky613:
Hi there,
I'm currently studying IT- Network and Systems Engineering. I wanted to get
your professional opinion on a matter. I am not required or expected to study
Java Programming. But I want to get you input on that. Should I learn Java ...
will I need it for future purposes?

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

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

DISCUSSION from Arlin:
I ended up using the following in my query:

Expr2: CInt([Table_Field])

Worked fine.

Thanks,
Arlin

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880765/4946246/25

-----------------------------------------------------------------------
NEW DISCUSSION on:
SQL Server does not exist or Access Denied Error

DISCUSSION from Mrdenny:
Server does not exist or access denied isn't an authentication problem. See
link I posted above.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Submitting a batch job from a C program

ANSWER from Mrlchile:
I meant SBMJOB.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880695/4946246/27

-----------------------------------------------------------------------
NEW ANSWER on:
two dimentional output

ANSWER from Carlosdl:
If you are on SQL SERVER 2005 or above, you could use a query like this:

[CODE] SELECT *
FROM
(SELECT id,year,col1,col2,ddate,
ROW_NUMBER() OVER (partition by year ORDER BY ddate DESC) rowNumber
FROM yourTable) ordered_temp
WHERE rowNumber = 1;[/CODE]

If you are not using SQL SERVER...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Temporary recordset in MS Access VBA

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880767/4946246/29

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Restore takes 6-10 minutes to come up in Enterprise Manager

ANSWER from Barneyrubble318:
check out msdb.dbo.sp_delete_backuphistory

My guess is your msdb is full of backup history. When you use the GUI it is
reading through all of the history.

Create a SQL agent job to run daily and trim the history back 30 or 90 days.

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

-----------------------------------------------------------------------
NEW ANSWER on:
Setting up PHP environment - CGI vs Module

ANSWER from BrentSheets:
Moderator Note: I'm not a professional developer but I'm a hobbyist dabbling in
various Web development projects. You may be reading about security and
performance issues and wondering the best route to go. My personal preference
is a host that uses [A href="http://httpd.apache.org/docs/1.3/suexec.h...

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
PL/SQL

DISCUSSION from Carlosdl:
Remember to set serveroutput on if you run your procedure from sql*plus.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880709/4946246/32

-----------------------------------------------------------------------
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/5880710/4946246/33

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

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

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

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

NEW QUESTION on:
Suse booting on external Hard drive problems

QUESTION from Securityn00b12:
I have a Dell 1520 w/ Vista home basic, also an external hard drive. I am
trying to use the external HD to boot my Linux on. I installed Suse the first
time, and it set up shop on the external, but put the boot section in my MBR on
the internal HD on the laptop. Now, not a big deal, I reinstall Suse...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to configure password less authentication for selected users?

ANSWER from Wfr:
Have a look at the following article. It might help you.

[A href="http://hacktux.com/passwordless/ssh"]Paswordless SSH[/A].

For rsh you only need to have a .rhosts file in your home directory. It needs
to contain the name of your machine. Also permissions need to be 600. That
will allow th...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Installation of Ubuntu 8.04 for dual boot

QUESTION from Carlosdl:
You should tell your NW administrator before installing it, because you will
need an ip address for your ubuntu OS, (although if you don't use DHCP, you
could use the same static ip address you use in XP).

Your user account does not need any changes.

If you want to dual boot, you will need a...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880738/4946246/40

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

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

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

NEW DISCUSSION on:
AS/400 V5R3M000-2924 Print problem

DISCUSSION from Tomb1953:
Yes, I would be interested in trying the workaround.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Best IT solution for Home working

ANSWER from Viswanathan:
There's not much of a way to block screen shots unless you have full control of
the remote client - and even then I'm not sure of a way to block that because
someone could even use a digital camera to take a screenshot. That is something
that a lot of folks don't recognize when securing documents an...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Excel report generation from Oracle Forms 10g

ANSWER from Carlosdl:
If you want to generate the excel documents at the client side, you could use
WebUtil.

Have a look at the following pages:

[A
href="http://www.oracle.com/technology/products/forms/htdocs/webutil/howto_ole.h
tml"]HOW TO - Performing OLE on the client using WebUtil[/A]
[A href="http://www.oracle...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Keeping the settings from a Print Server, spooling on the client via TCP/IP
port

QUESTION from Huangdi:
Hi all,
We would like to set up WinXP clients on remote sites so that they receive
printer drivers and settings from a centralised (off site) Windows Server, but
then when they print will spool from the client directly to the printer through
a TCP/IP port. Does anyone know:
1) If this is possible...

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

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

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to track who amended a particular file

DISCUSSION from KevinBeaver:
I know this is basic - have you looked at the file properties (right-click on
the file) and then click Summary and look in the Origin section?

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
MS Office 2007 File Converter Pak does not work

DISCUSSION from Technochic:
You got that right Robert. Thanks for posting your results!

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
SQL Server does not exist or Access Denied Error

DISCUSSION from Mrdenny:
Server does not exist or access denied isn't an authentication problem. See
link I posted above.

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880715/4946246/49

-----------------------------------------------------------------------
UPDATED ANSWER on:
E2k7 receipient policy exclusiv for an OU

ANSWER from Technochic:
please explan what you mean by recipient policy? normaly you can do policy
with individual permision on a OU. it you think of recipient like receving and
sending email email please confirm

********
Exchange 2007 recipient policies are controlled from within the Exchange
Management Console, not...

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

-----------------------------------------------------------------------
NEW QUESTION on:
Suse booting on external Hard drive problems

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880736/4946246/51

-----------------------------------------------------------------------
NEW ANSWER on:
messaging interface

ANSWER from Technochic:
When you export your contacts folder, try exporting to a file instead of a
personal folder. Choose import/Export - then export to a file - then commas
separated values (windows) - choose your contacts folder - choose the location
where you can find it again. It will export to a .csv file, then run i...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Restore takes 6-10 minutes to come up in Enterprise Manager

ANSWER from Barneyrubble318:
check out msdb.dbo.sp_delete_backuphistory

My guess is your msdb is full of backup history. When you use the GUI it is
reading through all of the history.

Create a SQL agent job to run daily and trim the history back 30 or 90 days.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to configure password less authentication for selected users?

ANSWER from Wfr:
Have a look at the following article. It might help you.

[A href="http://hacktux.com/passwordless/ssh"]Paswordless SSH[/A].

For rsh you only need to have a .rhosts file in your home directory. It needs
to contain the name of your machine. Also permissions need to be 600. That
will allow th...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Is there any password protect option for folders in windows vista ?

ANSWER from Flame:
This [A
href="http://www.pcworld.com/article/110663/windows_tips_passwordprotect_your_se
nsitive_files_and_folders.html"]PC World Blog entry[/A] describes doing just
that, as well as a few other suggestions to secure your data.
-Good Luck!
-Flame

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Remote Desktop Connection

ANSWER from Flame:
No you do not

**************************
Try a service like [A href="www.dyndns.com"]DynDNS[/A] they set up a static IP
address that tracks on your dynamic address.
Good Luck!
-Flame
****************************

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

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle SQL-Pagination Help

ANSWER from Kccrosser:
A lot depends on how you are using the results. If this is a frequent query,
you might consider creating a Materialized View on the data, including the
rownumber as a column in the view.
With a Materialized View, you can index the columns and run very efficient
queries against the view, so your pa...

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

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

DISCUSSION from KevinBeaver:
I'm not real clear on your question but it sounds like you're just trying to
limit the sites that users can go to. If so, you can specify sites in in this
manner in Internet Explorer 7 under Tools/Internet Options/Content/Content
Advisor.

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Alternate site to download Windows 7 beta ?

DISCUSSION from Carlosdl:
I was trying to avoid torrents, but I guess that will be my only choice now.

Thanks,

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

-----------------------------------------------------------------------
NEW QUESTION on:
Combo search box - "Invalid Outside Proceedure"

QUESTION from Abaumeister:
..and before you ask, no I don't use anything linked into Access 2007 to
program my database.

So, I've been creating a form coming from the same table with the same
information to be used as a separate edit form. And now suddenly my "search
box" gets this error in my normal form. HELP!

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880748/4946246/60

-----------------------------------------------------------------------
NEW ANSWER on:
HP LaserJet 4250 with IPDS card and AS/400

ANSWER from Teandy:
Can you ping the printer from the iSeries? When you set up the printer, did
you configure it using a device description or a remote outq?

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

-----------------------------------------------------------------------
NEW ANSWER on:
VLAN basics step by step

ANSWER from AndOrTech:
The first thing that you have to remember is VLANs are a way to separate the
networks. VLAN's basicly just isolate the different traffic. All of your
security comes from your switch/router routes, ACL's,or filtering on the
switch/router. As well as integrated security on your srevers/domain. The ...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880749/4946246/62

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

ANSWER from Mimo:
you probleme is the tools you use to print to PDF. cute PDF can not be
scripted. use something hels like the reale PDF writer or other. their is some
toold that can scritp pdf out their. I just don't remember them. but you can
find them

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

-----------------------------------------------------------------------
NEW ANSWER on:
USB port control policy

ANSWER from Mimo:
the first thing you have to do is to standerdize one USB key and based your
policy on that. if you just disable USB you will have probleme with laptops
using mouce and KB. also PCs will have probleme.

so you have to define what you want to block
do you want to track what is transfer to usb
do...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880751/4946246/64

-----------------------------------------------------------------------
UPDATED ANSWER on:
Login Failure on Disconnected Domain Controllers

ANSWER from Spadasoe:
their can vbe a multiple probleme,

Look at the FSMO role of all of your DCs, the PDC emulator is still a valide
role....?
look at the prefered DC in your client registry. in a microsoft workd the
first DC to answer is the one that give the answer and this can be a remote
server and it become t...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Administrator user rights

ANSWER from Spadasoe:
from run, gpedit.msc. in the group policy editor (this will only apply to the
local machine), go to user configuration, administrative templates, control
panel, display. Enable elements as you see fit. Note, no user will be able to
make changes unless the policy is reset to mot configured.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880753/4946246/66

-----------------------------------------------------------------------
NEW QUESTION on:
Installation of Ubuntu 8.04 for dual boot

Your user account does not need any changes.

If you want to dual boot, you will need a...

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

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

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

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

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

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

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

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

UPDATED ANSWER on:
Best IT solution for Home working

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

-----------------------------------------------------------------------
NEW ANSWER on:
windows mobile 6.1 outlook set up

ANSWER from Labnuke99:
Rather than just clicking the reply button, select the Menu option, then the
Reply option and arrow to one side. There will be the Reply All option.

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880763/4946246/74

-----------------------------------------------------------------------
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/5880710/4946246/75

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

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

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

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

NEW QUESTION on:
IT requiement

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to track who amended a particular file

DISCUSSION from KevinBeaver:
I know this is basic - have you looked at the file properties (right-click on
the file) and then click Summary and look in the Origin section?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880742/4946246/81

-----------------------------------------------------------------------
NEW QUESTION on:
Cisco ASA WebVPN - Clientless SSL user sessions keeps dropping

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
High speed network connections between buildings that are 500-700 metres apart

DISCUSSION from Securityn00b12:
You could also use wireless as an alternative, although you would have to deal
with weather conditions affecting the signal. I would have to agree the best
choice would be Fiber.

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

-----------------------------------------------------------------------
NEW ANSWER on:
I lose my VPN Wireless connection if my wife logs onto the internet with her
laptop

ANSWER from Securityn00b12:
Well, first off, when you drop your VPN connection, do you lose all internet
connection? Or is it that the VPN connection is unavailable? It would almost
appear that there is something going on in the VPN client config or in the
Router config. If all your losing is the VPN I would check those first,...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Proxies

ANSWER from KarlG:
I guess we should start with the definition of Proxy. It means "to act on
behalf of another," and a proxy server acts on behalf of the user. All requests
from clients to the Internet go to the proxy server first.

The proxy evaluates the request, and if allowed, re-establishes it on the
outbound ...

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
Remote Desktop Connection

ANSWER from Flame:
No you do not

**************************
Try a service like [A href="www.dyndns.com"]DynDNS[/A] they set up a static IP
address that tracks on your dynamic address.
Good Luck!
-Flame
****************************

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

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

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880746/4946246/87

-----------------------------------------------------------------------
NEW DISCUSSION on:
Network Security refresher training

DISCUSSION from KevinBeaver:
Check out the Open Source Security Testing Methodology Manual at
www.isecom.org/osstmm. I've written articles, presented webcasts, and recorded
podcasts for various TechTarget sites that covers this area extensively. You
can link to them at www.principlelogic.com/resources.html. Hope this helps!

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880758/4946246/88

-----------------------------------------------------------------------
NEW DISCUSSION on:
one telephone line, one isp, two user groups

DISCUSSION from MaxW:
Thank you Nmeddick for your very helpfull answer. Both Systems are up and
running, independantly of each other. just fine
MaxW

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880759/4946246/89

-----------------------------------------------------------------------
NEW ANSWER on:
VLAN basics step by step

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880749/4946246/90

-----------------------------------------------------------------------
UPDATED ANSWER on:
Login Failure on Disconnected Domain Controllers

ANSWER from Spadasoe:
their can vbe a multiple probleme,

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

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

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

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

NEW DISCUSSION on:
Inserting 50000 rows

DISCUSSION from Ramesh55:
where the anonymous bloks are stored?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880704/4946246/93

-----------------------------------------------------------------------
NEW QUESTION on:
Anonymous blocks

QUESTION from Ramesh55:
Where the anonymous blocks are stored?

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being
NULL

DISCUSSION from Inprise:
i can't use trigger,i hav to implement IF... THEN approach only within the
procedure

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

-----------------------------------------------------------------------
NEW ANSWER on:
Microsoft Excel report generation from Oracle Forms 10g

ANSWER from Carlosdl:
If you want to generate the excel documents at the client side, you could use
WebUtil.

Have a look at the following pages:

[A
href="http://www.oracle.com/technology/products/forms/htdocs/webutil/howto_ole.h
tml"]HOW TO - Performing OLE on the client using WebUtil[/A]
[A href="http://www.oracle...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle SQL-Pagination Help

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
PL/SQL

DISCUSSION from Carlosdl:
Remember to set serveroutput on if you run your procedure from sql*plus.

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

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

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

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

NEW QUESTION on:
List of SAP t-codes for users

QUESTION from GrapePeelingDemon:
Hi,
I need a list of SAP users and their corresponding t-code access. I can do it
via SUIM user by user however this is too slow. Are their any other t-codes
which can do it?
Cheers

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880775/4946246/100

-----------------------------------------------------------------------
NEW QUESTION on:
ST03 refresh

QUESTION from Atul0umt:
In PRD the ST03 tcode gives the performance and workload analysis.
In this screen when we refresh for TOTAL servers then the refresh time is
not taken as current. It collects data till morning 8 am only.
At the end of the day the data gets refreshed.
We need to have this data refreshed e...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880776/4946246/101

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

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

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

UPDATED ANSWER on:
Best IT solution for Home working

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

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

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Exchange client is sending excessive outbound email

DISCUSSION from KevinBeaver:
How about a rule in Windows Firewall to block port 25?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880726/4946246/105

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to track who amended a particular file

DISCUSSION from KevinBeaver:
I know this is basic - have you looked at the file properties (right-click on
the file) and then click Summary and look in the Origin section?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880742/4946246/106

-----------------------------------------------------------------------
NEW QUESTION on:
Cisco ASA WebVPN - Clientless SSL user sessions keeps dropping

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How to configure password less authentication for selected users?

ANSWER from Wfr:
Have a look at the following article. It might help you.

[A href="http://hacktux.com/passwordless/ssh"]Paswordless SSH[/A].

For rsh you only need to have a .rhosts file in your home directory. It needs
to contain the name of your machine. Also permissions need to be 600. That
will allow th...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Checklist for managing risk of Data Center power shutdown

ANSWER from Sunsetrider:
This sounds like a disaster recovery excercise.

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

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

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880746/4946246/110

-----------------------------------------------------------------------
NEW DISCUSSION on:
Network Security refresher training

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880758/4946246/111

-----------------------------------------------------------------------
NEW ANSWER on:
USB port control policy

so you have to define what you want to block
do you want to track what is transfer to usb
do...

VIEW AND IMPROVE ANSWER
http://go.techtarget.com/r/5880751/4946246/112

-----------------------------------------------------------------------
UPDATED ANSWER on:
Login Failure on Disconnected Domain Controllers

ANSWER from Spadasoe:
their can vbe a multiple probleme,

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

-----------------------------------------------------------------------
NEW ANSWER on:
Administrator user rights

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

-----------------------------------------------------------------------
NEW QUESTION on:
Installation of Ubuntu 8.04 for dual boot

Your user account does not need any changes.

If you want to dual boot, you will need a...

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

-----------------------------------------------------------------------
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/5880710/4946246/116

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

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

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

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

NEW DISCUSSION on:
PL/SQL: How to check address NOT NULL but can take -(hyphen) instead being
NULL

DISCUSSION from Inprise:
i can't use trigger,i hav to implement IF... THEN approach only within the
procedure

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
How can I pass tablename as a parameter in MySQL stored procedure?

ANSWER from Carlosdl:
It would be something [B][I]similar[/I][/B] to this:

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Why does my SQL Trigger malfunction?

DISCUSSION from Arlin:
Removing the quotes did the trick.
Thanks,
Arlin

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

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

DISCUSSION from Arlin:
I've been away and just now catching up on the thread.
I'll try the "service account" approach tomorrow.
Thanks,
Arlin

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Creating a summary table in SQL Server

DISCUSSION from Elsuket:
The best way to execute dynamic T-SQL code is to execute it with through the
system stored procedure sp_executesql, which is able to cache the dynamic SQL
query plans (what does not do the EXEC command).

It also offers the advantage to use OUTPUT variables, and to affect them to the
local variabl...

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

-----------------------------------------------------------------------
NEW QUESTION on:
RPGLE Stored Proc to Reporting Services

QUESTION from Oldmickey:
Have SQLRPGLE program set-up to use cursor to return result set, want to use
this to return table to MS Reporting Services get error message "low-order
nibble of byte array offset 2451 is not valid. Byte Value OO. What does this
mean and why not data back to client?

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880693/4946246/126

-----------------------------------------------------------------------
NEW DISCUSSION on:
SQL Server does not exist or Access Denied Error

DISCUSSION from Mrdenny:
Server does not exist or access denied isn't an authentication problem. See
link I posted above.

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

-----------------------------------------------------------------------
NEW ANSWER on:
two dimentional output

ANSWER from Carlosdl:
If you are on SQL SERVER 2005 or above, you could use a query like this:

[CODE] SELECT *
FROM
(SELECT id,year,col1,col2,ddate,
ROW_NUMBER() OVER (partition by year ORDER BY ddate DESC) rowNumber
FROM yourTable) ordered_temp
WHERE rowNumber = 1;[/CODE]

If you are not using SQL SERVER...

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

-----------------------------------------------------------------------
NEW ANSWER on:
SQL Restore takes 6-10 minutes to come up in Enterprise Manager

ANSWER from Barneyrubble318:
check out msdb.dbo.sp_delete_backuphistory

My guess is your msdb is full of backup history. When you use the GUI it is
reading through all of the history.

Create a SQL agent job to run daily and trim the history back 30 or 90 days.

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

-----------------------------------------------------------------------
UPDATED ANSWER on:
My CL program is running CPYTOIMPF cmd & causes an SQL error

ANSWER from Philpl1jb:
Not sure but we could use some additional info.
Can you run the command CPYTOIMPF on another file?
Are there any unusual column types in the file you're attempting to copy? --
ie: BLOG's
Is there any crupt data in the file you're attempting to copy?
What is the value for the TO STREAM f...

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

-----------------------------------------------------------------------
NEW ANSWER on:
Oracle SQL-Pagination Help

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
How to move the msdb database to sql 2005

DISCUSSION from Bubbanm:
Thanks, what would be the best way to move the data over after I get the
database moved over

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

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

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

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

NEW DISCUSSION on:
Have you moved to online backup for your corporation and if so, are you still
using tape backup?

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880719/4946246/134

-----------------------------------------------------------------------
NEW QUESTION on:
Suse booting on external Hard drive problems

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880736/4946246/135

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V guest server move to from one host to another issue

QUESTION from JimmyIT:

I know that in order to move a hyper-v guest server from one host to
another you have to use the export command in order to move it. I am
currently using Windows Backup to backup the hyper-v guest and have
successfully restore the virtual on the same machine. But my problem
is that I cannot r...

VIEW AND ANSWER QUESTION
http://go.techtarget.com/r/5880762/4946246/136

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

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

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

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

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

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

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

UPDATED ANSWER on:
Best IT solution for Home working

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

-----------------------------------------------------------------------
NEW QUESTION on:
Hyper-V guest server move to from one host to another issue

QUESTION from JimmyIT:

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

-----------------------------------------------------------------------
NEW DISCUSSION on:
Alternate site to download Windows 7 beta ?

DISCUSSION from Carlosdl:
I was trying to avoid torrents, but I guess that will be my only choice now.

Thanks,

VIEW AND DISCUSS QUESTION
http://go.techtarget.com/r/5880747/4946246/144

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

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.

Label Links

Break

Daily Question and Answer Update for Feb 18, 2009

Hot in Week

Popular

Archive

Footer Ads

Page

Label Links

Break

Daily Question and Answer Update for Feb 18, 2009

Like to share?

Hot in Week

Popular

Archive

Footer Ads