Execute SP through DOS
sqlcmd -E -S %1 -d %2 -Q "EXEC schema.spname %3 %4 %1 corresponds to server_name %2 corresponds to database_name %3 corresponds to param1 %4 corresponds to param2 ...
View Answer
| May 9, 2013 10:46 PM
DOS Batch, SQL Server, SQL Server 2005
sqlcmd -E -S %1 -d %2 -Q "EXEC schema.spname %3 %4 %1 corresponds to server_name %2 corresponds to database_name %3 corresponds to param1 %4 corresponds to param2 ...
View Answer
| May 9, 2013 10:46 PM
DOS Batch, SQL Server, SQL Server 2005
Domain user adjust time when it is Day Light Saving
You can grant this right to all your users by editing a GPO and setting the “Change the system time” right which can be found at “Computer Configuration > Policies > Windows Settings > Security Settings > Local Policies > User Rights Assignments > Change the system time”. The users shouldn’t need to change anything [...]
View Answer
| May 9, 2013 2:24 AM
Domain Administration, Domain Group Policy, Domain Users
You can grant this right to all your users by editing a GPO and setting the “Change the system time” right which can be found at “Computer Configuration > Policies > Windows Settings > Security Settings > Local Policies > User Rights Assignments > Change the system time”. The users shouldn’t need to change anything [...]
View Answer
| May 9, 2013 2:24 AM
Domain Administration, Domain Group Policy, Domain Users
Event View Error Message
Go to the properties of your SMTP Virtual Server in System Manager. You might need to modify a few of your settings based on your email usage. Have a look on MS’s KB too. The majority if not all the below messages will be there.
View Answer
| May 9, 2013 10:57 AM
Active Directory, DataCenter, DHCP, Microsoft Windows, Networking, Security, WINS
Go to the properties of your SMTP Virtual Server in System Manager. You might need to modify a few of your settings based on your email usage. Have a look on MS’s KB too. The majority if not all the below messages will be there.
View Answer
| May 9, 2013 10:57 AM
Active Directory, DataCenter, DHCP, Microsoft Windows, Networking, Security, WINS
HP LASERJET 3005: Stops and starts printing again from the beginning
Try uninstall and again fresh install the printer with minimum options or select only the necessary options. In the mean time u have to contact with the vendor from where u bought the printer or contact printer hw person. Thanks
View Answer
| May 9, 2013 9:51 AM
Firmware, HP LaserJet, HP P3005N, HP Printer, HP Printer Drivers, HP Printer Problem
Try uninstall and again fresh install the printer with minimum options or select only the necessary options. In the mean time u have to contact with the vendor from where u bought the printer or contact printer hw person. Thanks
View Answer
| May 9, 2013 9:51 AM
Firmware, HP LaserJet, HP P3005N, HP Printer, HP Printer Drivers, HP Printer Problem
TOO LONG TO OPEN
Try to copy the PST file to your computer first before opening it. The hard disk drive reads and writes data faster compared to a USB disk drive. Also, make sure that the outlook software application is properly working and installed into your computer system.
View Answer
| May 9, 2013 8:55 AM
Outlook
Try to copy the PST file to your computer first before opening it. The hard disk drive reads and writes data faster compared to a USB disk drive. Also, make sure that the outlook software application is properly working and installed into your computer system.
View Answer
| May 9, 2013 8:55 AM
Outlook
MS Access database
If your end users have MS Access installed on their machines, then you could just have them link to the MDE file on the server via a windows shortcut. This method even supports having multiple users at a time.
View Answer
| May 9, 2013 11:39 AM
Microsoft Access, Microsoft Access database
If your end users have MS Access installed on their machines, then you could just have them link to the MDE file on the server via a windows shortcut. This method even supports having multiple users at a time.
View Answer
| May 9, 2013 11:39 AM
Microsoft Access, Microsoft Access database
USB Memory
I have seen on the web that if the device supports AutoRun/AutoPlay (winXP) then you can auto run a program. To quote something I found online. >Ordinary memory sticks do not have an unique ID. They have some sort of hardwareID but it is not unique, and is used to identify USB hardware to host [...]
View Answer
| May 9, 2013 6:30 AM
Storage
I have seen on the web that if the device supports AutoRun/AutoPlay (winXP) then you can auto run a program. To quote something I found online. >Ordinary memory sticks do not have an unique ID. They have some sort of hardwareID but it is not unique, and is used to identify USB hardware to host [...]
View Answer
| May 9, 2013 6:30 AM
Storage
SBS 2008 to Exchange 2010
Hi Scev, It is good to know that you are upgrading. You might find useful articles on net. I have accumulated some for your help. Go through these, I am sure these will help you out. http://www.petri.co.il/forums/showthread.php?t=42303 http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/7fad67a7-1301-4b92-8ff9-07482ffb212f/ Hope you could do it without any trouble. Do update us again. Thank you Anil
View Answer
| May 9, 2013 9:13 AM
Exchange 2007, Exchange 2010, SBS 2008, Small Business Server 2008
Hi Scev, It is good to know that you are upgrading. You might find useful articles on net. I have accumulated some for your help. Go through these, I am sure these will help you out. http://www.petri.co.il/forums/showthread.php?t=42303 http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/7fad67a7-1301-4b92-8ff9-07482ffb212f/ Hope you could do it without any trouble. Do update us again. Thank you Anil
View Answer
| May 9, 2013 9:13 AM
Exchange 2007, Exchange 2010, SBS 2008, Small Business Server 2008
ASP.NET
http://support.microsoft.com/kb/316383 This is how you create word document from .net.
View Answer
| May 9, 2013 7:09 PM
ASP.NET, Visual Studio 2008
http://support.microsoft.com/kb/316383 This is how you create word document from .net.
View Answer
| May 9, 2013 7:09 PM
ASP.NET, Visual Studio 2008
AS/400 Network Printer
Hello, To setup a network printer you will need the IP address. On the command line: CRTDEVPRT <F4> See sample below… Device Description = Name of Printer Device Class = *LAN Device Type = *IPDS Device Model = 0 Lan Attachment = *IP Advanced Function Printing = *YES Port Number = 5001 Online at IPL [...]
View Answer
| May 9, 2013 3:41 PM
AS/400 network printers, AS/400 printing
Hello, To setup a network printer you will need the IP address. On the command line: CRTDEVPRT <F4> See sample below… Device Description = Name of Printer Device Class = *LAN Device Type = *IPDS Device Model = 0 Lan Attachment = *IP Advanced Function Printing = *YES Port Number = 5001 Online at IPL [...]
View Answer
| May 9, 2013 3:41 PM
AS/400 network printers, AS/400 printing
Where do ICT professionals search and/or share online?
Hi Eddacker, Welcome to IT Knowledge Exchange. I know I’m a little biased, but that place is <i>here!</i> We have a strong enterprise IT community asking and answering questions related to a wide range of IT topics, including TCP/IP and Security. Feel free to click on those links to browse the conversations occurring in those [...]
View Answer
| May 9, 2013 1:47 PM
Information and communication technologies industry, Knowledge Transfer, Networking, Professional development, Server room, SMB, TCP/IP
Hi Eddacker, Welcome to IT Knowledge Exchange. I know I’m a little biased, but that place is <i>here!</i> We have a strong enterprise IT community asking and answering questions related to a wide range of IT topics, including TCP/IP and Security. Feel free to click on those links to browse the conversations occurring in those [...]
View Answer
| May 9, 2013 1:47 PM
Information and communication technologies industry, Knowledge Transfer, Networking, Professional development, Server room, SMB, TCP/IP
Unable to Join Domain from Client PC
Go to Active Directory then Computers. Find the computer “XXXXXXX” and delete it. Join the computer again to the domain.
View Answer
| May 9, 2013 8:45 AM
Active Directory, Active Directory Domain, Windows Server 2000, Windows Server configuration
Go to Active Directory then Computers. Find the computer “XXXXXXX” and delete it. Join the computer again to the domain.
View Answer
| May 9, 2013 8:45 AM
Active Directory, Active Directory Domain, Windows Server 2000, Windows Server configuration
Invalid or nonexistent document in Lotus Notes 8
Try File, Database, Refresh Design. If that doesn’t work, File, Database, Replace Design.
View Answer
| May 9, 2013 6:23 PM
Lotus Notes, Lotus Notes 6.5, Lotus Notes 8, Lotus Notes Upgrades
Try File, Database, Refresh Design. If that doesn’t work, File, Database, Replace Design.
View Answer
| May 9, 2013 6:23 PM
Lotus Notes, Lotus Notes 6.5, Lotus Notes 8, Lotus Notes Upgrades
How to share Outlook folder with another user in Exchange 2007?
See this link for more help: David ************** The link David gives has a perfect explanation. To make it more understandable I look at it this way. The shared folder is the kitchen. File>open gives them access to front room only, not the kitchen. In order to see the shared folder (kitchen) they have to [...]
View Answer
| May 9, 2013 4:26 PM
Exchange 2007, Outlook, Shared folders
See this link for more help: David ************** The link David gives has a perfect explanation. To make it more understandable I look at it this way. The shared folder is the kitchen. File>open gives them access to front room only, not the kitchen. In order to see the shared folder (kitchen) they have to [...]
View Answer
| May 9, 2013 4:26 PM
Exchange 2007, Outlook, Shared folders
Email recall in Lotus Notes v7.0
Lotus Notes 7 does not allow you to recall messages. You need to be using Lotus Notes 8 on Lotus Notes 8 servers and the admin has to allow the recall functionality
View Answer
| May 9, 2013 12:55 AM
Lotus Domino, Lotus email, Lotus Notes, Lotus Notes 7.x
Lotus Notes 7 does not allow you to recall messages. You need to be using Lotus Notes 8 on Lotus Notes 8 servers and the admin has to allow the recall functionality
View Answer
| May 9, 2013 12:55 AM
Lotus Domino, Lotus email, Lotus Notes, Lotus Notes 7.x
What is SYSVOL folder in Windows 2003 server
The Sysvol folder on a Windows domain controller is used to replicate file-based data among domain controllers. Because junctions are used within the Sysvol folder structure, Windows NT file system (NTFS) version 5.0 is required on domain controllers throughout a Windows distributed file system (DFS) forest. This is a quote from microsoft themselves, basically the [...]
View Answer
| May 9, 2013 12:56 AM
SYSVOL folder, Windows Server 2003
The Sysvol folder on a Windows domain controller is used to replicate file-based data among domain controllers. Because junctions are used within the Sysvol folder structure, Windows NT file system (NTFS) version 5.0 is required on domain controllers throughout a Windows distributed file system (DFS) forest. This is a quote from microsoft themselves, basically the [...]
View Answer
| May 9, 2013 12:56 AM
SYSVOL folder, Windows Server 2003
VLAN basics step by step
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 other thing to note is layer 2 switches [...]
View Answer
| May 9, 2013 3:47 PM
Cisco switches, DHCP, LAN Security, VLAN configuration, VLAN management, Windows Server 2003
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 other thing to note is layer 2 switches [...]
View Answer
| May 9, 2013 3:47 PM
Cisco switches, DHCP, LAN Security, VLAN configuration, VLAN management, Windows Server 2003
Latest network or CCNA related interview questions & answers
There is no set list of questions for any interview. Some interviewers like to ask all candidates the same questions, some like to ask questions that come out of the discussions with the candidate. An interview is not an exam like the Cisco CCNA, it is a process to try and find out about a [...]
View Answer
| May 9, 2013 6:55 AM
CCNA, Job interviews, Network
There is no set list of questions for any interview. Some interviewers like to ask all candidates the same questions, some like to ask questions that come out of the discussions with the candidate. An interview is not an exam like the Cisco CCNA, it is a process to try and find out about a [...]
View Answer
| May 9, 2013 6:55 AM
CCNA, Job interviews, Network
Get source code from .EXE file
Hello, It really depends on the type of software we are talking about. Something proprietary like Windows 7 or Photoshop? Don’t even think about it. Extremely illegal and could mean trouble for a very long time. These billion dollar corporations take intellectual property very seriously. However, if the software is under the “GNU” license, the [...]
View Answer
| May 9, 2013 2:28 PM
.exe, Source code, Source code control, Source code management
Hello, It really depends on the type of software we are talking about. Something proprietary like Windows 7 or Photoshop? Don’t even think about it. Extremely illegal and could mean trouble for a very long time. These billion dollar corporations take intellectual property very seriously. However, if the software is under the “GNU” license, the [...]
View Answer
| May 9, 2013 2:28 PM
.exe, Source code, Source code control, Source code management
MS Access 2007, IIF and Null expressions
You could use the IsNull Function. Something like this: <pre>IIf(<b>IsNull</b>([1st Position Held Elected or Appointed]),<something else>,"25")</pre>
View Answer
| May 9, 2013 2:08 PM
Access 2007, IIF, Microsoft Access, Null Expressions
You could use the IsNull Function. Something like this: <pre>IIf(<b>IsNull</b>([1st Position Held Elected or Appointed]),<something else>,"25")</pre>
View Answer
| May 9, 2013 2:08 PM
Access 2007, IIF, Microsoft Access, Null Expressions
