Is there a query to search text of all SQL Server database objects that reference a specific table/instance?
You can search the syscomments table within each database on the SQL 2000 server for the text you are looking for. This will search all procedures, views, triggers and UDFs. However the DTS packages are stored in a binary format, and the easiest method to use it to use is to open then up and [...]
View Answer
| May 9, 2013 6:26 PM
Database objects, Query, SQL Server migration
You can search the syscomments table within each database on the SQL 2000 server for the text you are looking for. This will search all procedures, views, triggers and UDFs. However the DTS packages are stored in a binary format, and the easiest method to use it to use is to open then up and [...]
View Answer
| May 9, 2013 6:26 PM
Database objects, Query, SQL Server migration
How to assign a numerical value to a word in Excel
The VLOOKUP function should meet your needs. Here’s a good online Excel resource. Another similar question on a forum can be found here also. In the IT trenches? So am I – read my IT Trenches blog.
View Answer
| May 9, 2013 12:07 PM
Excel 2003, Excel macros, Microsoft Excel
The VLOOKUP function should meet your needs. Here’s a good online Excel resource. Another similar question on a forum can be found here also. In the IT trenches? So am I – read my IT Trenches blog.
View Answer
| May 9, 2013 12:07 PM
Excel 2003, Excel macros, Microsoft Excel
Default gateway VS ip default route
The IP default gateway command is used on switches that do not have IP routing enabled. In other words it should be normally used in combination with the no IP routing command. It basically makes it like your switch is a dumb host on the network and needs a gateway. If you want your 3750 [...]
View Answer
| May 9, 2013 6:42 PM
Ethernet, Networking
The IP default gateway command is used on switches that do not have IP routing enabled. In other words it should be normally used in combination with the no IP routing command. It basically makes it like your switch is a dumb host on the network and needs a gateway. If you want your 3750 [...]
View Answer
| May 9, 2013 6:42 PM
Ethernet, Networking
Creating Login Script in Windows Server 2003
Hello, My favorite script sources are: http://www.amset.info/loginscripts/default.asp http://www.myitforum.com/articles/11/view.asp?id=6298 Elad.
View Answer
| May 9, 2013 3:52 PM
Login scripts, Windows Server, Windows Server 2003
Hello, My favorite script sources are: http://www.amset.info/loginscripts/default.asp http://www.myitforum.com/articles/11/view.asp?id=6298 Elad.
View Answer
| May 9, 2013 3:52 PM
Login scripts, Windows Server, Windows Server 2003
Allocate Unallocated space on a flash drive…
1. Download the Lexar tool and extract to your PC from following link <a href=”http://www.911cd.net/forums//index.php?s=d0f1d03f809777e2be9845f96234ef69&act=attach&type=post&id=369″ title=”http://www.911cd.net/forums//index.php?s=d0f1d03f809777e2be9845f96234ef69&act=attach&type=post&id=369″ target=”_blank”>http://www.911cd.net/forums//index.php?s”> 2. Click on the ‘Non-Active’ radio button at the bottom of the window 3. Now click on the ‘Format’ button 4. Remove and insert back of your Flash drive 5. Go back to disc management and reformat the [...]
View Answer
| May 8, 2013 10:20 AM
FAT, Flash drive, NTFS, Thumb Drive Formatting
1. Download the Lexar tool and extract to your PC from following link <a href=”http://www.911cd.net/forums//index.php?s=d0f1d03f809777e2be9845f96234ef69&act=attach&type=post&id=369″ title=”http://www.911cd.net/forums//index.php?s=d0f1d03f809777e2be9845f96234ef69&act=attach&type=post&id=369″ target=”_blank”>http://www.911cd.net/forums//index.php?s”> 2. Click on the ‘Non-Active’ radio button at the bottom of the window 3. Now click on the ‘Format’ button 4. Remove and insert back of your Flash drive 5. Go back to disc management and reformat the [...]
View Answer
| May 8, 2013 10:20 AM
FAT, Flash drive, NTFS, Thumb Drive Formatting
CLIENT MAC ADDR 00 16 35 66… GUID: 0EF0C… error on startup
It seems that the computer is trying to boot from the network, and it is not being able to contact the necessary servers to get its configuration. If that is not the intention, you might want to configure the BIOS to disable PXE boot, and/or change the boot order.
View Answer
| May 8, 2013 5:58 PM
Disk error, MAC address, Non-System disk, Startup issue, Windows XP Pro, Windows XP Professional
It seems that the computer is trying to boot from the network, and it is not being able to contact the necessary servers to get its configuration. If that is not the intention, you might want to configure the BIOS to disable PXE boot, and/or change the boot order.
View Answer
| May 8, 2013 5:58 PM
Disk error, MAC address, Non-System disk, Startup issue, Windows XP Pro, Windows XP Professional
Change screen resolution in SUSE Linux to 1024*768
Go to Failsafe Mode > Enter your user name as root and password now type:#sax2 (if the above is not work) then #sax2 -m 0=vesa (It leads to yast2 > hardware > graphics then set the lower resolution, (0 means zero)), if it not works then # sax2 -a (This command automatically tries to load [...]
View Answer
| May 8, 2013 6:24 AM
SUSE, SUSE Linux, SUSE Linux Enterprise Server
Go to Failsafe Mode > Enter your user name as root and password now type:#sax2 (if the above is not work) then #sax2 -m 0=vesa (It leads to yast2 > hardware > graphics then set the lower resolution, (0 means zero)), if it not works then # sax2 -a (This command automatically tries to load [...]
View Answer
| May 8, 2013 6:24 AM
SUSE, SUSE Linux, SUSE Linux Enterprise Server
What is the difference between the terminal server and Citrix server?
There are quite a few differences. We use both inside our network and some features that we like for Citrix vs Terminal Server (remote desktop) are: <ol> <li>Web access: Citrix provides the ability to access published desktops or applications through a web interface. Microsoft Terminal Services requires some add-on to provide this access.</li><li>Published applications: Citrix [...]
View Answer
| May 8, 2013 1:32 PM
Citrix Server, Windows Terminal Server
There are quite a few differences. We use both inside our network and some features that we like for Citrix vs Terminal Server (remote desktop) are: <ol> <li>Web access: Citrix provides the ability to access published desktops or applications through a web interface. Microsoft Terminal Services requires some add-on to provide this access.</li><li>Published applications: Citrix [...]
View Answer
| May 8, 2013 1:32 PM
Citrix Server, Windows Terminal Server
Connect to Oracle 10g with VB6 using ADO
One thing that is not clearly specified in the above article is that you need to have Oracle client software installed. The following article may help as well: Displaying an Oracle 10G XE Table with Visual Basic 6.0
View Answer
| May 8, 2013 4:45 PM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6
One thing that is not clearly specified in the above article is that you need to have Oracle client software installed. The following article may help as well: Displaying an Oracle 10G XE Table with Visual Basic 6.0
View Answer
| May 8, 2013 4:45 PM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6
Configuring multiple network cards in Ubuntu
Ubuntu will pick up your network cards individually and you should have a little network icon on the bottom or top of your screen which you can open up to view your network connections and open them up to make changes. If its not there you can also get to it through administration > Network [...]
View Answer
| May 8, 2013 11:04 PM
linux router, Network Adapters, Ubuntu
Ubuntu will pick up your network cards individually and you should have a little network icon on the bottom or top of your screen which you can open up to view your network connections and open them up to make changes. If its not there you can also get to it through administration > Network [...]
View Answer
| May 8, 2013 11:04 PM
linux router, Network Adapters, Ubuntu
How to protect an Excel sheet from printing?
This link should help you with your problem. Of course, they could always use Print Screen. Also, this link could help as well: Good luck!
View Answer
| May 8, 2013 8:28 PM
Document security, Microsoft Excel, Printing
This link should help you with your problem. Of course, they could always use Print Screen. Also, this link could help as well: Good luck!
View Answer
| May 8, 2013 8:28 PM
Document security, Microsoft Excel, Printing
Exchange 2007
Are you sure that the Microsoft Exchange System Attendant Service is running. I had the same issue in an exchange lab. After starting this service, as actually also the error message implies, everything worked fine. The Microsoft Exchange System Attendant service is primarily a collection of subcomponents that work together to proxy Active Directory requests [...]
View Answer
| May 8, 2013 6:32 AM
Exchange 2007, Exchange error messages
Are you sure that the Microsoft Exchange System Attendant Service is running. I had the same issue in an exchange lab. After starting this service, as actually also the error message implies, everything worked fine. The Microsoft Exchange System Attendant service is primarily a collection of subcomponents that work together to proxy Active Directory requests [...]
View Answer
| May 8, 2013 6:32 AM
Exchange 2007, Exchange error messages
Edit a text file with VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
You could use a script like this. Actually, it does not “replace” the line, but reads the complete file and writes the modified text back. It could take some time (and resources) to process large files this way. <pre>Const ForReading = 1 Const ForWriting = 2 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:your_file.txt", ForReading) [...]
View Answer
| May 8, 2013 1:58 PM
Access 2007, Text manipulation, VB, VBA
Change font size in Lotus Notes
Hello Lgentile, thank you for contributing to ITKnowledge Exchange. Allow me to reference one of the tips we’ve run on SearchDomino.com, entitled: Use a notes.ini setting to adjust font sizes in Lotus Notes. I hope that it helps you. Best Regards, Matt Gervais Associate Editor SearchDomino.com
View Answer
| May 8, 2013 6:53 PM
Lotus Notes, Lotus Notes Domino user settings
Hello Lgentile, thank you for contributing to ITKnowledge Exchange. Allow me to reference one of the tips we’ve run on SearchDomino.com, entitled: Use a notes.ini setting to adjust font sizes in Lotus Notes. I hope that it helps you. Best Regards, Matt Gervais Associate Editor SearchDomino.com
View Answer
| May 8, 2013 6:53 PM
Lotus Notes, Lotus Notes Domino user settings
Outlook 2007 Global Address List not updating in cached mode
Consider the suggestions in this support article.
View Answer
| May 8, 2013 5:34 AM
Exchange 2007, Global Address Lists, Outlook, Outlook 2007
Consider the suggestions in this support article.
View Answer
| May 8, 2013 5:34 AM
Exchange 2007, Global Address Lists, Outlook, Outlook 2007
How do I find the IP range?
The /30 means the subnet. A subnet mask of /30 = 255.255.255.252. So the IP addresses you can use are 10.14.6.1 and 10.14.6.2. Have a look at this 3com PDF, which should help you understand the basics of IP addressing and subnetting. The /30 subnet allows you 4 IP addresses in the range 10.14.6.1 – [...]
View Answer
| May 8, 2013 4:45 PM
IP address, IP range, Subnet mask calculation, Subnets, Subnetting
The /30 means the subnet. A subnet mask of /30 = 255.255.255.252. So the IP addresses you can use are 10.14.6.1 and 10.14.6.2. Have a look at this 3com PDF, which should help you understand the basics of IP addressing and subnetting. The /30 subnet allows you 4 IP addresses in the range 10.14.6.1 – [...]
View Answer
| May 8, 2013 4:45 PM
IP address, IP range, Subnet mask calculation, Subnets, Subnetting
Create .csv file as output from SAP
Dear Friend There are different ways in creating a CSV file. The right way is to use the function SAP_CONVERT_TO_CSV_FORMAT. You can just go through the function, everything is clear. To complete, for every convert function there is an equal and opposite convert function, so is TEXT_CONVERT_CSV_TO_SAP. Otherwise, you can create an internal table with [...]
View Answer
| May 8, 2013 9:37 PM
ABAP, SAP development
Dear Friend There are different ways in creating a CSV file. The right way is to use the function SAP_CONVERT_TO_CSV_FORMAT. You can just go through the function, everything is clear. To complete, for every convert function there is an equal and opposite convert function, so is TEXT_CONVERT_CSV_TO_SAP. Otherwise, you can create an internal table with [...]
View Answer
| May 8, 2013 9:37 PM
ABAP, SAP development
Configuring Cisco Wireless Router
Follow these commands using the CLI to configure the router, note this is a sample configuration, you can change the IP address what ever you need ip dhcp use vrf connected ip dhcp excluded-address 192.168.1.1 192.168.1.10 ip dhcp excluded-address 192.168.1.1 192.168.1.70 ! ip dhcp pool TEST import all network 192.168.1.0 255.255.255.0 default-router 192.168.1.1 interface Dot11Radio0 [...]
View Answer
| May 8, 2013 7:04 AM
Access Points, Cisco, Cisco 871, Cisco SDM, Router configuration, Routers, SBS, Security Device Manager, Wireless routers
Follow these commands using the CLI to configure the router, note this is a sample configuration, you can change the IP address what ever you need ip dhcp use vrf connected ip dhcp excluded-address 192.168.1.1 192.168.1.10 ip dhcp excluded-address 192.168.1.1 192.168.1.70 ! ip dhcp pool TEST import all network 192.168.1.0 255.255.255.0 default-router 192.168.1.1 interface Dot11Radio0 [...]
View Answer
| May 8, 2013 7:04 AM
Access Points, Cisco, Cisco 871, Cisco SDM, Router configuration, Routers, SBS, Security Device Manager, Wireless routers
Applying an ACL in Packet Tracer for class
One problem is that you used the source to be ‘any” and not the subnet. Also on the second part, you restricted it to echo-reply, which is a response to a PING, which if you wanted to restrict it to only allow ping should have just been echo. However the question says just ICMP, so [...]
View Answer
| May 8, 2013 12:26 PM
Access Control List, ACL, Packet Tracer
One problem is that you used the source to be ‘any” and not the subnet. Also on the second part, you restricted it to echo-reply, which is a response to a PING, which if you wanted to restrict it to only allow ping should have just been echo. However the question says just ICMP, so [...]
View Answer
| May 8, 2013 12:26 PM
Access Control List, ACL, Packet Tracer
Which domain user has logged onto which machine
We use a group policy logon script that records who logs into each computer. echo logon %username% %computername% %date% %time% >> \FILE_LOCATION.txt
View Answer
| May 8, 2013 10:26 PM
Domain Forest, User profiles, Windows Server 2003
We use a group policy logon script that records who logs into each computer. echo logon %username% %computername% %date% %time% >> \FILE_LOCATION.txt
View Answer
| May 8, 2013 10:26 PM
Domain Forest, User profiles, Windows Server 2003
