How to restore a SQL Server 2000 database using a backup
You can do this via the Microsoft console (look under programs/Microsoft SQL server) or via SQL command. I suggest you using the graphical way, that’s to say: <ul> Open the management console Provide login information Right click the database that you need to restore and choose restore If the database name isn’t listed right click [...]
View Answer
| April 19, 2013 9:18 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
You can do this via the Microsoft console (look under programs/Microsoft SQL server) or via SQL command. I suggest you using the graphical way, that’s to say: <ul> Open the management console Provide login information Right click the database that you need to restore and choose restore If the database name isn’t listed right click [...]
View Answer
| April 19, 2013 9:18 PM
Backup, Backup & recovery, SQL Server 2000, SQL Server backup and restore
Cannot open a .OST file in Outlook 2007
You need a OST to PST converter tool to convert offline .OST file to .PST file then you can access PST file with Outlook email client. Check out the free trial version of software. Thanks Alfa Tech
View Answer
| April 19, 2013 6:56 AM
.pst, OST, Outlook 2007
You need a OST to PST converter tool to convert offline .OST file to .PST file then you can access PST file with Outlook email client. Check out the free trial version of software. Thanks Alfa Tech
View Answer
| April 19, 2013 6:56 AM
.pst, OST, Outlook 2007
Easier way to Insert image to SharePoint
You are right, SharePoint does not support directly insert picture into Rich Text Editor. I stumble on this solution called SharePoint Rich Text Boost, which can let user insert images and Flash directly.
View Answer
| April 19, 2013 6:23 AM
SharePoint, SharePoint 2007, SharePoint 2007 insert picture, SharePoint Rich Text Editor
You are right, SharePoint does not support directly insert picture into Rich Text Editor. I stumble on this solution called SharePoint Rich Text Boost, which can let user insert images and Flash directly.
View Answer
| April 19, 2013 6:23 AM
SharePoint, SharePoint 2007, SharePoint 2007 insert picture, SharePoint Rich Text Editor
Create an add to calendar button
You already have that button in your calendar!
View Answer
| April 19, 2013 2:34 PM
Lotus Notes, Lotus Notes Calendar, Lotus notes Calendar Button
You already have that button in your calendar!
View Answer
| April 19, 2013 2:34 PM
Lotus Notes, Lotus Notes Calendar, Lotus notes Calendar Button
Command for auto reboot – Windows 7
The SHUTDOWN command does not have the capability to tell applications to save data and close. You can use “/r” for reboot which will trigger open applications to prompt to save data and not reboot if the applications remain open. Adding the “/f” will force a reboot but cause potential data loss because it forces [...]
View Answer
| April 19, 2013 7:22 PM
Reboot, Windows 7, Windows 7 Administration, Windows 7 reboot, Windows scripting
The SHUTDOWN command does not have the capability to tell applications to save data and close. You can use “/r” for reboot which will trigger open applications to prompt to save data and not reboot if the applications remain open. Adding the “/f” will force a reboot but cause potential data loss because it forces [...]
View Answer
| April 19, 2013 7:22 PM
Reboot, Windows 7, Windows 7 Administration, Windows 7 reboot, Windows scripting
Running system restore from command line on Windows Server 2003?
You can boot to safe mode with command prompt to launch the system restore gui. You have to type the following commands cd windowssystem32 cd restore rstrui.exe Select the date you want to roll back top Start your restore You can also read the post I wrote up on doing just that over here. This [...]
View Answer
| April 19, 2013 3:35 PM
Command line, System Restore, Windows Server 2003, Windows Server 2003 Backup
You can boot to safe mode with command prompt to launch the system restore gui. You have to type the following commands cd windowssystem32 cd restore rstrui.exe Select the date you want to roll back top Start your restore You can also read the post I wrote up on doing just that over here. This [...]
View Answer
| April 19, 2013 3:35 PM
Command line, System Restore, Windows Server 2003, Windows Server 2003 Backup
Multiple subnets on one physical network
If you just want to communicate with the radios, the easiest way would be to add another ip address to the network adapter that is going to your AP. You can put any number of addresses on one adapter, simulating multiple network cards sharing the same wire. To do this, you’ll have to ensure the [...]
View Answer
| April 19, 2013 5:11 AM
Access Points, Network design, Routers, Routing and switching, Routing table protocols, Subnet mask, Subnets, Switches, Wireless networks
If you just want to communicate with the radios, the easiest way would be to add another ip address to the network adapter that is going to your AP. You can put any number of addresses on one adapter, simulating multiple network cards sharing the same wire. To do this, you’ll have to ensure the [...]
View Answer
| April 19, 2013 5:11 AM
Access Points, Network design, Routers, Routing and switching, Routing table protocols, Subnet mask, Subnets, Switches, Wireless networks
Configuring VLAN’s on two HP procurve switches
You do not need to put any IP addresses on the VLAN 2 interfaces on either switch, that actually does what you don’t want and allows traffic to pass from vlan1 to vlan2, if you don’t put an IP address on vlan2 this can not happen. What you also need to do is add the [...]
View Answer
| April 19, 2013 10:26 PM
HP, HP ProCurve, Switches, VLAN, VLAN configuration
You do not need to put any IP addresses on the VLAN 2 interfaces on either switch, that actually does what you don’t want and allows traffic to pass from vlan1 to vlan2, if you don’t put an IP address on vlan2 this can not happen. What you also need to do is add the [...]
View Answer
| April 19, 2013 10:26 PM
HP, HP ProCurve, Switches, VLAN, VLAN configuration
Can a Pivot table be created in Oracle 10g?
Yes, but in 10g it is not as easy as it would be in 11g where the PIVOT clause was introduced. You could do it using the DECODE function, but you would need to know all the possible codes to construct the query. Something like this: <pre>SELECT MAX(DECODE(code,'AAA',amount,NULL)) AAA, MAX(DECODE(code,'BBB',amount,NULL)) BBB, MAX(DECODE(code,'CCC',amount,NULL)) CCC FROM codes;</pre> [...]
View Answer
| April 19, 2013 5:39 PM
Oracle 10g, Oracle 10g Pivot Table, Pivot Table Oracle 10g
Yes, but in 10g it is not as easy as it would be in 11g where the PIVOT clause was introduced. You could do it using the DECODE function, but you would need to know all the possible codes to construct the query. Something like this: <pre>SELECT MAX(DECODE(code,'AAA',amount,NULL)) AAA, MAX(DECODE(code,'BBB',amount,NULL)) BBB, MAX(DECODE(code,'CCC',amount,NULL)) CCC FROM codes;</pre> [...]
View Answer
| April 19, 2013 5:39 PM
Oracle 10g, Oracle 10g Pivot Table, Pivot Table Oracle 10g
Difference between SAS and SAP
I think you are referring to SAS and SAP. SAAS is on-demand application-software as a service where is license to the application is provided to the Customer. The customer can login to the UI with his user id and password and login to the system as per the license. Database maintenance won’t be with the [...]
View Answer
| April 19, 2013 7:49 AM
Business Intelligence, Business intelligence software, SAP, SAP BI, SAP Business Intelligence, SAS, SAS Business Intelligence software
I think you are referring to SAS and SAP. SAAS is on-demand application-software as a service where is license to the application is provided to the Customer. The customer can login to the UI with his user id and password and login to the system as per the license. Database maintenance won’t be with the [...]
View Answer
| April 19, 2013 7:49 AM
Business Intelligence, Business intelligence software, SAP, SAP BI, SAP Business Intelligence, SAS, SAS Business Intelligence software
Kaspersky Internet security 2012 update issue
In your case, there might be some problems with the security of Kaspersky antivirus software program in accessing your computer Internet connection. There might be a firewall set to block the connection of Kaspersky to your computer, try to add it to the exception of your firewall settings and try if it will work.
View Answer
| April 19, 2013 2:49 AM
Anitvirus update issue, Antivirus software, Kaspersky, Kaspersky Antivirus
In your case, there might be some problems with the security of Kaspersky antivirus software program in accessing your computer Internet connection. There might be a firewall set to block the connection of Kaspersky to your computer, try to add it to the exception of your firewall settings and try if it will work.
View Answer
| April 19, 2013 2:49 AM
Anitvirus update issue, Antivirus software, Kaspersky, Kaspersky Antivirus
What are the latest Java technologies?
http://java.sun.com/
View Answer
| April 19, 2013 3:14 PM
Hibernate, Java, Java Servlets, JSP, Struts
http://java.sun.com/
View Answer
| April 19, 2013 3:14 PM
Hibernate, Java, Java Servlets, JSP, Struts
I want to select months from Jan to Dec using SQL query
I think Cyberloco’s answer meets the requirements. Deleting my suggested approach.
View Answer
| April 19, 2013 7:44 PM
SQL development, SQL queries
I think Cyberloco’s answer meets the requirements. Deleting my suggested approach.
View Answer
| April 19, 2013 7:44 PM
SQL development, SQL queries
Error message CPF4131 AS400
You can disregard this question. The problem was in the program. Another programmer had made a change over the weekend. I recompiled the program and took a retry on the CL. The job finished successfully. ————————————————————————————— To answer the question how to look at a files permissions: <pre>DSPOBJAUT OBJ(filename) OBJTYPE(*FILE)</pre> Assuming you have authority to [...]
View Answer
| April 19, 2013 3:12 PM
AS/400, CPF4131, RPG
You can disregard this question. The problem was in the program. Another programmer had made a change over the weekend. I recompiled the program and took a retry on the CL. The job finished successfully. ————————————————————————————— To answer the question how to look at a files permissions: <pre>DSPOBJAUT OBJ(filename) OBJTYPE(*FILE)</pre> Assuming you have authority to [...]
View Answer
| April 19, 2013 3:12 PM
AS/400, CPF4131, RPG
Change English numbers to Arabic numbers
Can you be more specific? Are you attempting to take fields in Microsoft Excel (and what version) that contain values like 1, 2, 3, etc. and convert them to numerals like I, II, III, etc.? You have the ability to change or standardize the data type in each cell. Select the group of cells you [...]
View Answer
| April 19, 2013 2:38 PM
Arabic numerals, English numerals, Microsoft Excel
Can you be more specific? Are you attempting to take fields in Microsoft Excel (and what version) that contain values like 1, 2, 3, etc. and convert them to numerals like I, II, III, etc.? You have the ability to change or standardize the data type in each cell. Select the group of cells you [...]
View Answer
| April 19, 2013 2:38 PM
Arabic numerals, English numerals, Microsoft Excel
Using SUBSTR with interactive SQL
Unless something has changed SUBSTR cannot be used as the target of set. It can however be used as part of the expression setting the variable. Try: UPDATE LIBRARY/FILE_NAME SET FIELD_NAME1 = SUBSTR(FIELD_NAME1,1,193) || 'XXXX' || SUBSTR(FIELD_NAME1,198) WHERE FIELD_NAME2 = 99999
View Answer
| April 19, 2013 6:29 PM
AS/400, SQL
Unless something has changed SUBSTR cannot be used as the target of set. It can however be used as part of the expression setting the variable. Try: UPDATE LIBRARY/FILE_NAME SET FIELD_NAME1 = SUBSTR(FIELD_NAME1,1,193) || 'XXXX' || SUBSTR(FIELD_NAME1,198) WHERE FIELD_NAME2 = 99999
View Answer
| April 19, 2013 6:29 PM
AS/400, SQL
Receiving undeliverable email we did not send
Spammers use your eMail return address to keep themselves from getting blocked. There is nothing you can do about this, unless someone figures out a way to handle the problem network-wide. Bob here – This is also a technique used to spread viruses and spam in general. The fact that your email address gets used [...]
View Answer
| April 19, 2013 6:06 PM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, Spam, SQL Server, TrendMicro
Spammers use your eMail return address to keep themselves from getting blocked. There is nothing you can do about this, unless someone figures out a way to handle the problem network-wide. Bob here – This is also a technique used to spread viruses and spam in general. The fact that your email address gets used [...]
View Answer
| April 19, 2013 6:06 PM
Desktops, Exchange, Exchange security, Management, Microsoft Windows, OS, Security, Servers, Spam, SQL Server, TrendMicro
Group policy: Restricting users from accessing control panel
User configuration/Administrative templates/control panel/prohibit access to control panel.
View Answer
| April 19, 2013 8:50 AM
Active Directory, Auditing, DataCenter, Policies
User configuration/Administrative templates/control panel/prohibit access to control panel.
View Answer
| April 19, 2013 8:50 AM
Active Directory, Auditing, DataCenter, Policies
Finding incoming and outgoing mail server types and names.
Where is your email coming from – is it in-house at your work? Directly from an ISP? A web-based email? Whoever handles your email account will have this information available, for both incoming (POP3) and outgoing (SMTP) servers. If you are at work, ask your IT Department. If you are at home using an ISP [...]
View Answer
| April 19, 2013 6:19 PM
Mail servers, Outlook, Outlook Express
Where is your email coming from – is it in-house at your work? Directly from an ISP? A web-based email? Whoever handles your email account will have this information available, for both incoming (POP3) and outgoing (SMTP) servers. If you are at work, ask your IT Department. If you are at home using an ISP [...]
View Answer
| April 19, 2013 6:19 PM
Mail servers, Outlook, Outlook Express
Is a 3 drive RAID 5 array a good idea?
I first suggest you choosing drives that are “hot swappable” so you can always do your operations with the system online; then RAID 5 is a really good choice (the best to my point of view). For the array controller failure oh well that’s something that can happen but at that point the disks should [...]
View Answer
| April 19, 2013 4:00 AM
RAID, RAID 5, RAID Array
I first suggest you choosing drives that are “hot swappable” so you can always do your operations with the system online; then RAID 5 is a really good choice (the best to my point of view). For the array controller failure oh well that’s something that can happen but at that point the disks should [...]
View Answer
| April 19, 2013 4:00 AM
RAID, RAID 5, RAID Array
