Difference between SQL and T-SQL(Microsoft SQL Server 2000)
From TechTarget.com: What is the difference between SQL and T-SQL? Why would a company use one over the other? This question posed on 14 February 2002 ANSI SQL is the standard Structured Query Language. Most database vendors support SQL. T-SQL is Microsoft’s “flavor” of SQL; it is ANSI SQL with Microsoft’s extensions. A company could [...]
View Answer
| March 15, 2005 9:42 AM
Database Management Systems, DataCenter, MySQL, SQL Server
From TechTarget.com: What is the difference between SQL and T-SQL? Why would a company use one over the other? This question posed on 14 February 2002 ANSI SQL is the standard Structured Query Language. Most database vendors support SQL. T-SQL is Microsoft’s “flavor” of SQL; it is ANSI SQL with Microsoft’s extensions. A company could [...]
View Answer
| March 15, 2005 9:42 AM
Database Management Systems, DataCenter, MySQL, SQL Server
I have a project involving an DS400 SAN connected to 2 Intel Servers IBM345 running Windows Server2003
Did you choose network attached or server attached setup? If network – yes, both or either. If server connect configuration was used then you have to switch controllers and that requires a restart – I think? I have only worked with one and it is network attached.
View Answer
| March 15, 2005 7:00 AM
IBM, IT architecture, SAN, Servers, Windows 2000 Server, Windows Server 2003
Did you choose network attached or server attached setup? If network – yes, both or either. If server connect configuration was used then you have to switch controllers and that requires a restart – I think? I have only worked with one and it is network attached.
View Answer
| March 15, 2005 7:00 AM
IBM, IT architecture, SAN, Servers, Windows 2000 Server, Windows Server 2003
SUBJ: Deleting mail in an inbox older then X days
1. Create a new user of that name on active directory and then sign on as that user to delete. Or use forwarding in delivery options. 2. Not quite sure what you are trying to achieve here. Could be that you can set a predetemined limit to that mailbox once again indelivery option area of [...]
View Answer
| March 15, 2005 4:11 AM
Exchange, Exchange 2000, Exchange 2003, Installation, Migration, Outlook, Tech support, Vendor support
1. Create a new user of that name on active directory and then sign on as that user to delete. Or use forwarding in delivery options. 2. Not quite sure what you are trying to achieve here. Could be that you can set a predetemined limit to that mailbox once again indelivery option area of [...]
View Answer
| March 15, 2005 4:11 AM
Exchange, Exchange 2000, Exchange 2003, Installation, Migration, Outlook, Tech support, Vendor support
Cant send/recieve in outlook 2003
Hi, Is their a firewall in betweeen? I believe the firewall is blocking access for this particular machine as you say it works from other machine. Please provide more inputs. Thanks.
View Answer
| March 15, 2005 4:00 AM
Exchange, Hardware, Help Desk, Servers, Tech support, Third-party services
Hi, Is their a firewall in betweeen? I believe the firewall is blocking access for this particular machine as you say it works from other machine. Please provide more inputs. Thanks.
View Answer
| March 15, 2005 4:00 AM
Exchange, Hardware, Help Desk, Servers, Tech support, Third-party services
nodes update via Group Policy
Hi, Why not go for MS Software Update Services (SUS)? Once installed, you can then define Group Policy which will help you to update all the client machines automatically. More info at: http://www.microsoft.com/windowsserversystem/sus/susdeployment.mspx
View Answer
| March 15, 2005 3:43 AM
DataCenter
Hi, Why not go for MS Software Update Services (SUS)? Once installed, you can then define Group Policy which will help you to update all the client machines automatically. More info at: http://www.microsoft.com/windowsserversystem/sus/susdeployment.mspx
View Answer
| March 15, 2005 3:43 AM
DataCenter
Setting Group Policy on XP/2000 using Windows2003 Server
In AD users and computers select the security group you want to work with, usually a site unit. Open properties > group policy > edit > user configuration > administrative templates > desktop. This will direct you to the core of what you’re looking for. Familiarize yourself with all the parameters in the tree. There [...]
View Answer
| March 14, 2005 12:16 PM
DataCenter, Tech support
In AD users and computers select the security group you want to work with, usually a site unit. Open properties > group policy > edit > user configuration > administrative templates > desktop. This will direct you to the core of what you’re looking for. Familiarize yourself with all the parameters in the tree. There [...]
View Answer
| March 14, 2005 12:16 PM
DataCenter, Tech support
HP EVA3000 or IBM DS4300 ?
I cannot speak for the IBM, but I have extensive experience with the EVA-3000 and EVA-5000. Both are excellent SAN storage devices. The EVA is a very mature platform – originally designed by DEC. The IBM product is very new. You also posted previously about weather to use NAS or SAN. I have specific experience [...]
View Answer
| March 13, 2005 12:17 PM
HP, IBM, Storage
I cannot speak for the IBM, but I have extensive experience with the EVA-3000 and EVA-5000. Both are excellent SAN storage devices. The EVA is a very mature platform – originally designed by DEC. The IBM product is very new. You also posted previously about weather to use NAS or SAN. I have specific experience [...]
View Answer
| March 13, 2005 12:17 PM
HP, IBM, Storage
Considerations for making norent programs reentrant.
Use AMODE(31),RMODE(ANY) to allow your programs to run above the line. Re-entrant programs stay in memory after they are called the first time (to eliminate load time for the second and subsequent calls). As a result, working storage variables have te be re-initialized (by the program) at the beginning of each call.
View Answer
| March 11, 2005 8:47 AM
COBOL
Use AMODE(31),RMODE(ANY) to allow your programs to run above the line. Re-entrant programs stay in memory after they are called the first time (to eliminate load time for the second and subsequent calls). As a result, working storage variables have te be re-initialized (by the program) at the beginning of each call.
View Answer
| March 11, 2005 8:47 AM
COBOL
Saving Mails sent through SMTP
Please clarify – is your “SMTP server” the SMTP component of Exchange, or is it a separate product either on the same physical box or on a different server? It depends on your software implementation, but if memory serves me correctly, the SMTP standard does not make allowances for message saving. In theory, it should [...]
View Answer
| March 10, 2005 7:39 AM
DataCenter, Microsoft Systems Management Server
Please clarify – is your “SMTP server” the SMTP component of Exchange, or is it a separate product either on the same physical box or on a different server? It depends on your software implementation, but if memory serves me correctly, the SMTP standard does not make allowances for message saving. In theory, it should [...]
View Answer
| March 10, 2005 7:39 AM
DataCenter, Microsoft Systems Management Server
Workstation security
User accounts do not have permission to edit the registry this is why SUS will not run under a user account …however you can set up SUS to run under the Administrator account from the user account. “Run this program as….” and select “always run this program as….” Your updates will be able to run. [...]
View Answer
| March 10, 2005 7:26 AM
DataCenter, Development
User accounts do not have permission to edit the registry this is why SUS will not run under a user account …however you can set up SUS to run under the Administrator account from the user account. “Run this program as….” and select “always run this program as….” Your updates will be able to run. [...]
View Answer
| March 10, 2005 7:26 AM
DataCenter, Development
3d drawing
Depending on what level of detail and accuracy you need this is either going to be easy or painful! If you are not using a 3D API like OpenGL or DirectX, you need to do the math yourself to project your 3D drawing onto a 2D surface and then just use the normal line drawing [...]
View Answer
| March 10, 2005 3:42 AM
Development, IT architecture
Depending on what level of detail and accuracy you need this is either going to be easy or painful! If you are not using a 3D API like OpenGL or DirectX, you need to do the math yourself to project your 3D drawing onto a 2D surface and then just use the normal line drawing [...]
View Answer
| March 10, 2005 3:42 AM
Development, IT architecture
WYSE 3730 LE
Going out on a limb here – since I’m not familiar with the specific product, but am in general. You didn’t specify, but I’m assuming that you mean one of the Wyse Winterm thin clients. A quick search of the Wyse support web site (wyse.com AskWyse.com) indicates that these systems are usually managed with a [...]
View Answer
| March 9, 2005 6:19 PM
DataCenter, Help Desk, Networking, TCP, Tech support
Going out on a limb here – since I’m not familiar with the specific product, but am in general. You didn’t specify, but I’m assuming that you mean one of the Wyse Winterm thin clients. A quick search of the Wyse support web site (wyse.com AskWyse.com) indicates that these systems are usually managed with a [...]
View Answer
| March 9, 2005 6:19 PM
DataCenter, Help Desk, Networking, TCP, Tech support
Hot Key programing-2
Pressing Alt+F4 brings up the shut down menu. Then pressing U you tell to “Turn Off”. Additionally you can use R for “Restart” or S for “Standby”.
View Answer
| March 9, 2005 2:04 PM
Help Desk, Tech support, Vendor support
Pressing Alt+F4 brings up the shut down menu. Then pressing U you tell to “Turn Off”. Additionally you can use R for “Restart” or S for “Standby”.
View Answer
| March 9, 2005 2:04 PM
Help Desk, Tech support, Vendor support
Hot Key programing
Pressing Alt+F4 brings up the shut down menu. Then pressing U you tell to “Turn Off”. Additionally you can use R for “Restart” or S for “Standby”.
View Answer
| March 9, 2005 2:02 PM
Help Desk, Tech support, Vendor support
Pressing Alt+F4 brings up the shut down menu. Then pressing U you tell to “Turn Off”. Additionally you can use R for “Restart” or S for “Standby”.
View Answer
| March 9, 2005 2:02 PM
Help Desk, Tech support, Vendor support
Cat 5 Shielded Cable
The Stranded Shielding of the cable connects to the metal casing on the plug.
View Answer
| March 8, 2005 10:11 AM
Cabling, Networking
The Stranded Shielding of the cable connects to the metal casing on the plug.
View Answer
| March 8, 2005 10:11 AM
Cabling, Networking
can’t receive mails
Before you can expect any useful advice, you need to give some details: - What email program are you using; - Which protocol (e.g., smtp, pop3, imap, some proprietary protocol); - What platform (OS); - How does your network configuration look like; - Is there a firewall between you and your target; - Are there [...]
View Answer
| March 7, 2005 8:57 PM
DataCenter, DHCP, DNS, E-mail applications, Exchange, Hardware, Networking, Networking Equipment, Networking services, QoS, Routers, Security, Sendmail, Servers, Switches, Tech support
Before you can expect any useful advice, you need to give some details: - What email program are you using; - Which protocol (e.g., smtp, pop3, imap, some proprietary protocol); - What platform (OS); - How does your network configuration look like; - Is there a firewall between you and your target; - Are there [...]
View Answer
| March 7, 2005 8:57 PM
DataCenter, DHCP, DNS, E-mail applications, Exchange, Hardware, Networking, Networking Equipment, Networking services, QoS, Routers, Security, Sendmail, Servers, Switches, Tech support
Scheduling unattended full system backup
Todd, We are currently on v4R4 as well. My experience has been submitting directly from the system console essentially the day before you want it and I’ve found: 23 hours 59 minutes with some seconds.
View Answer
| March 4, 2005 9:04 AM
DataCenter
Todd, We are currently on v4R4 as well. My experience has been submitting directly from the system console essentially the day before you want it and I’ve found: 23 hours 59 minutes with some seconds.
View Answer
| March 4, 2005 9:04 AM
DataCenter
How to configure user to be local administrator for all PC’s in a domain without making him domain administrator
On the local computer, do the following: 1. Right Click on My Computer 2. Select Manage 3. Scroll to Local User and Groups and under Groups; 4. Double click on Administrators 5. Search for the Account (from your AD) you want to enable as a local Administrator 6. Click Add…that’s it! Cheers. PS. You can [...]
View Answer
| March 4, 2005 8:07 AM
DataCenter
On the local computer, do the following: 1. Right Click on My Computer 2. Select Manage 3. Scroll to Local User and Groups and under Groups; 4. Double click on Administrators 5. Search for the Account (from your AD) you want to enable as a local Administrator 6. Click Add…that’s it! Cheers. PS. You can [...]
View Answer
| March 4, 2005 8:07 AM
DataCenter
Unable to access windows 95 sharing files from windows xp
Authentication – XP and 2000 use better methods of identifying computers and users for the purpose of security. 95 uses the older, less secure methods. Recent patches to XP have closed the ‘loophole’ of those older methods to protect the system. You will need to go to group policy and allow the older methods. The [...]
View Answer
| March 3, 2005 7:19 AM
DataCenter, Hardware, Microsoft Windows, Networking
Authentication – XP and 2000 use better methods of identifying computers and users for the purpose of security. 95 uses the older, less secure methods. Recent patches to XP have closed the ‘loophole’ of those older methods to protect the system. You will need to go to group policy and allow the older methods. The [...]
View Answer
| March 3, 2005 7:19 AM
DataCenter, Hardware, Microsoft Windows, Networking
Domino mail: Dealing with leavers/resignations; forwarding
Once you delete a user from the Domino directory, the server should stop receiving email for that user. The oly way youhave to view pass email for this user is to restore the mail file if the mail file has been delete.
View Answer
| March 2, 2005 12:00 PM
Career development, DataCenter, Development, Help Desk, Lifecycle development, Security, Software Quality Assurance, Tech support
Once you delete a user from the Domino directory, the server should stop receiving email for that user. The oly way youhave to view pass email for this user is to restore the mail file if the mail file has been delete.
View Answer
| March 2, 2005 12:00 PM
Career development, DataCenter, Development, Help Desk, Lifecycle development, Security, Software Quality Assurance, Tech support
