Max Row Size Error in SQL 2000 Update Error
Are there any other columns you could filter by so that the number of rows updated could be shared among separate queries? For example, you could update all rows before a certain date with in one batch and all rows after in another batch. This could help lighten the load.
View Answer
| January 8, 2007 11:07 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Are there any other columns you could filter by so that the number of rows updated could be shared among separate queries? For example, you could update all rows before a certain date with in one batch and all rows after in another batch. This could help lighten the load.
View Answer
| January 8, 2007 11:07 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
main storage & pool sizes
This is hard to answer from a removed distance. I kind of doubt that anything has been lost. Can you give us a snap shot of the Wrksyssts with a view of the memory? Sometimes it just doesn’t look like it adds up or maybe you have set aside memory for a pool you are [...]
View Answer
| January 7, 2007 10:51 AM
DataCenter
This is hard to answer from a removed distance. I kind of doubt that anything has been lost. Can you give us a snap shot of the Wrksyssts with a view of the memory? Sometimes it just doesn’t look like it adds up or maybe you have set aside memory for a pool you are [...]
View Answer
| January 7, 2007 10:51 AM
DataCenter
Worth investing in server
Deekay, I went through a similar decision process about 8 years ago. 5 users growing to 8, needed shared access to 1 application (database for accounting/payroll), file storage, and shop drawings. We decided to install a server and set up a Windows domain. The capabilities have significantly enhanced several aspects of business and made management [...]
View Answer
| January 7, 2007 8:59 AM
Servers
Deekay, I went through a similar decision process about 8 years ago. 5 users growing to 8, needed shared access to 1 application (database for accounting/payroll), file storage, and shop drawings. We decided to install a server and set up a Windows domain. The capabilities have significantly enhanced several aspects of business and made management [...]
View Answer
| January 7, 2007 8:59 AM
Servers
Count distinct rows on multiple columns
If you just wanted a count of the student IDs present, you could use COUNT(DISTINCT id). However, you want a running tally-mark. This involves sorting the file to temporary storage, then looking for changes, and putting a 1 in the slot where you have the changes: WITH sorted AS( SELECT * FROM sampleData ORDER BY [...]
View Answer
| April 19, 2013 11:35 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
If you just wanted a count of the student IDs present, you could use COUNT(DISTINCT id). However, you want a running tally-mark. This involves sorting the file to temporary storage, then looking for changes, and putting a 1 in the slot where you have the changes: WITH sorted AS( SELECT * FROM sampleData ORDER BY [...]
View Answer
| April 19, 2013 11:35 PM
Access, Data/Application Integration, Database, DB2, Desktops, Development, Management, Microsoft Windows, Oracle, Oracle Business Applications, Oracle development, OS, PeopleSoft, Programming Languages, Security, Servers, SQL, SQL Server, T-SQL, Windows
Wake-On-LAN / Cisco Mac address-tables
Have you set the NIC property to use the Magic Packet Frame? This worked for me. Once the LAN controller has been put into the Magic Packet mode, it scans all incoming frames addressed to the node for a specific data sequence, which indicates to the controller that this is a Magic Packet frame.
View Answer
| January 5, 2007 1:10 PM
Cabling, Cisco, Desktops, Hardware, Hubs, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches
Have you set the NIC property to use the Magic Packet Frame? This worked for me. Once the LAN controller has been put into the Magic Packet mode, it scans all incoming frames addressed to the node for a specific data sequence, which indicates to the controller that this is a Magic Packet frame.
View Answer
| January 5, 2007 1:10 PM
Cabling, Cisco, Desktops, Hardware, Hubs, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches
Routing entry in SBSD
This is exactly what a routing entry does – gives control to the named program. Most subsytems have a default entry of sequence no 9999 which calls QCMD (or occasionally QCMDB or QCMDI for batch / interactive respectively) with a match value of *ANY on the routing data. There are frequently lower numbered entries which [...]
View Answer
| January 5, 2007 8:03 AM
DataCenter
This is exactly what a routing entry does – gives control to the named program. Most subsytems have a default entry of sequence no 9999 which calls QCMD (or occasionally QCMDB or QCMDI for batch / interactive respectively) with a match value of *ANY on the routing data. There are frequently lower numbered entries which [...]
View Answer
| January 5, 2007 8:03 AM
DataCenter
Roaming Profles and Default Printers WinXP Server 2003
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q234270 http://www.windowsnetworking.com/articles_tutorials/Managing-Printers-Group-Policy-Part1.html http://www.windowsnetworking.com/articles_tutorials/Managing-Printers-Group-Policy-Part2.html Hi, I dealt with this issue over a year ago with a big project I worked on. I think this has to do with Windows 2003 applying the policy at boot up. Does your script remove and add the printers when it is applied? Check the links above. I used vb to [...]
View Answer
| January 4, 2007 8:29 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q234270 http://www.windowsnetworking.com/articles_tutorials/Managing-Printers-Group-Policy-Part1.html http://www.windowsnetworking.com/articles_tutorials/Managing-Printers-Group-Policy-Part2.html Hi, I dealt with this issue over a year ago with a big project I worked on. I think this has to do with Windows 2003 applying the policy at boot up. Does your script remove and add the printers when it is applied? Check the links above. I used vb to [...]
View Answer
| January 4, 2007 8:29 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
Exchange 2003 not able to change send and receive file size limits
Did you change this setting for all users or only one user?
View Answer
| January 4, 2007 2:44 AM
Desktops, Exchange, Exchange security, Hardware, Interoperability, Management, Microsoft Windows, OS, Security, Servers, Software, Spam, SQL Server, Tech support
Did you change this setting for all users or only one user?
View Answer
| January 4, 2007 2:44 AM
Desktops, Exchange, Exchange security, Hardware, Interoperability, Management, Microsoft Windows, OS, Security, Servers, Software, Spam, SQL Server, Tech support
Front End Development for AS400
In my experience, it really depends on the complexity of the application. I’ve created several GUI interfaces into our AS400. If you’re rewriting a report, or if it’s a simple application, or if it’s new development, web based applications are the best, but, if it’s a complicated application sometimes you best bet is to build [...]
View Answer
| January 3, 2007 11:08 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
In my experience, it really depends on the complexity of the application. I’ve created several GUI interfaces into our AS400. If you’re rewriting a report, or if it’s a simple application, or if it’s new development, web based applications are the best, but, if it’s a complicated application sometimes you best bet is to build [...]
View Answer
| January 3, 2007 11:08 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Email, PC/Windows Connectivity, Web development
Add to the domain or not
For security and consistency have him as part of the domain and access through the VPN. If he has to access shares it is better for you to control all the security after all, you are probably already responsible for anything that goes wrong.
View Answer
| January 3, 2007 10:54 AM
DataCenter, DHCP, DNS, Networking services
For security and consistency have him as part of the domain and access through the VPN. If he has to access shares it is better for you to control all the security after all, you are probably already responsible for anything that goes wrong.
View Answer
| January 3, 2007 10:54 AM
DataCenter, DHCP, DNS, Networking services
Data Center cabling without Patch Panels
The only way to really remove patch panels is to locate the edge switches in the cabnet with the servers. If you have 40 servers, then a 48 port switch with 10g upllinks will work well. So the connections would be server -(1000bT)> switch in rack -(10000 Fiber)> core. Make sure that clusters are scattered [...]
View Answer
| January 2, 2007 2:32 PM
Cabling, DataCenter, standards
The only way to really remove patch panels is to locate the edge switches in the cabnet with the servers. If you have 40 servers, then a 48 port switch with 10g upllinks will work well. So the connections would be server -(1000bT)> switch in rack -(10000 Fiber)> core. Make sure that clusters are scattered [...]
View Answer
| January 2, 2007 2:32 PM
Cabling, DataCenter, standards
Telecom Integration
You have two quite separate questions here. Was that the intention ? 1 What are the issues with telecom and data integration ? 2 What does managing telecoms involve ? As written, the scope of both questions is too wide (for me) to give you a focused answer, but here are some thoughts. 1 What [...]
View Answer
| January 1, 2007 4:48 PM
Budgeting, Mobile, Outsourcing, Project management, Vendors, VoIP, Wireless
You have two quite separate questions here. Was that the intention ? 1 What are the issues with telecom and data integration ? 2 What does managing telecoms involve ? As written, the scope of both questions is too wide (for me) to give you a focused answer, but here are some thoughts. 1 What [...]
View Answer
| January 1, 2007 4:48 PM
Budgeting, Mobile, Outsourcing, Project management, Vendors, VoIP, Wireless
USB Modem
If I remember correctly the FCC has set the max rate @ 51K for the U.S.
View Answer
| January 1, 2007 4:11 PM
Hardware
If I remember correctly the FCC has set the max rate @ 51K for the U.S.
View Answer
| January 1, 2007 4:11 PM
Hardware
Domain Rename
Check Event Log of the Servers that holds the FSMO Roles, espacially the Schema Master and Domain Naming Master.
View Answer
| January 1, 2007 8:20 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Check Event Log of the Servers that holds the FSMO Roles, espacially the Schema Master and Domain Naming Master.
View Answer
| January 1, 2007 8:20 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Domain Administration with Linux
You should use Samba (www.samba.org). I recommend reading all documentation before deploying it. As I am actually not using it I don’t know its managing limitations if you have an existing AD running.
View Answer
| December 30, 2006 11:07 AM
Availability, Enterprise Desktop, Linux, Network management software, Networking
You should use Samba (www.samba.org). I recommend reading all documentation before deploying it. As I am actually not using it I don’t know its managing limitations if you have an existing AD running.
View Answer
| December 30, 2006 11:07 AM
Availability, Enterprise Desktop, Linux, Network management software, Networking
Domain Administration in Linux
You could use Samba 3.0 to setup a Windows NT like domain, but Linux doesn’t have anything comparable to Active Directory at this point. There is a thesis that has been written about using Samba 4 (the version under development) as an Active Directory DC, but since it’s not out yet, you’re out of luck [...]
View Answer
| December 29, 2006 10:27 PM
Availability, Enterprise Desktop, Linux, Network management software, Networking
You could use Samba 3.0 to setup a Windows NT like domain, but Linux doesn’t have anything comparable to Active Directory at this point. There is a thesis that has been written about using Samba 4 (the version under development) as an Active Directory DC, but since it’s not out yet, you’re out of luck [...]
View Answer
| December 29, 2006 10:27 PM
Availability, Enterprise Desktop, Linux, Network management software, Networking
Changing File Ownership to allow Disk Quota’s to work – Windows 2000
Here is a suggestion from a users group: SubInACL in the Win2k Resource kit is able to do this: subinacl /noverbose /file serversharedir /setowner=whoever subinacl /noverbose /subdirectories serversharedir* /setowner=whoever If you don’t have the Win2k RK, the SubInACL.exe in the Windows Server 2003 RK (free) will maybe work on Win2k as well. Windows Server 2003 [...]
View Answer
| December 28, 2006 10:38 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Here is a suggestion from a users group: SubInACL in the Win2k Resource kit is able to do this: subinacl /noverbose /file serversharedir /setowner=whoever subinacl /noverbose /subdirectories serversharedir* /setowner=whoever If you don’t have the Win2k RK, the SubInACL.exe in the Windows Server 2003 RK (free) will maybe work on Win2k as well. Windows Server 2003 [...]
View Answer
| December 28, 2006 10:38 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
DHCP assigned addres conflict
In the scope settings you need to put in exclusions for the IP addresses that are used statically. For example: Scope: 192.168.10.1 – 192.168.10.254 can be DHCP and 192.168.10.1 – 192.168.10.65 can be excluded and reserved for static use.
View Answer
| December 28, 2006 3:51 PM
DataCenter, DHCP, DNS, Networking, Networking services, Project management
In the scope settings you need to put in exclusions for the IP addresses that are used statically. For example: Scope: 192.168.10.1 – 192.168.10.254 can be DHCP and 192.168.10.1 – 192.168.10.65 can be excluded and reserved for static use.
View Answer
| December 28, 2006 3:51 PM
DataCenter, DHCP, DNS, Networking, Networking services, Project management
Critical Error in Security Log
Account Logon Event Type 673 0×20 – KRB_AP_ERR_TKT_EXPIRED: Ticket expired Associated internal Windows error codes ? STATUS_TIME_DIFFERENCE_AT_DC Corresponding debug output messages ? DebugLog(?Trying to renew a ticket past its renew timen?) ? DebugLog(?Trying to renew an expired ticketn?) Possible Cause and Resolution ? The smaller the value for the Maximum lifetime for user ticket Kerberos [...]
View Answer
| December 28, 2006 9:25 AM
Biometrics, configuration, DataCenter, Desktops, Digital certificates, Identity & Access Management, Management, Microsoft Systems Management Server, Microsoft Windows, OS, Patch management, patching, PEN testing, Platform Security, provisioning, Security, Security tokens, Servers, Single sign-on, Software, SQL Server, Tech support, vulnerability management
Account Logon Event Type 673 0×20 – KRB_AP_ERR_TKT_EXPIRED: Ticket expired Associated internal Windows error codes ? STATUS_TIME_DIFFERENCE_AT_DC Corresponding debug output messages ? DebugLog(?Trying to renew a ticket past its renew timen?) ? DebugLog(?Trying to renew an expired ticketn?) Possible Cause and Resolution ? The smaller the value for the Maximum lifetime for user ticket Kerberos [...]
View Answer
| December 28, 2006 9:25 AM
Biometrics, configuration, DataCenter, Desktops, Digital certificates, Identity & Access Management, Management, Microsoft Systems Management Server, Microsoft Windows, OS, Patch management, patching, PEN testing, Platform Security, provisioning, Security, Security tokens, Servers, Single sign-on, Software, SQL Server, Tech support, vulnerability management
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
If you install Client Access for iSeries on your developer’s machines they should have the proper DB2 ODBC drivers installed. Cheers, Paul
View Answer
| December 28, 2006 8:46 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
If you install Client Access for iSeries on your developer’s machines they should have the proper DB2 ODBC drivers installed. Cheers, Paul
View Answer
| December 28, 2006 8:46 AM
Access, ASP.NET, C, Database, DataCenter, DataManagement, DB2, DB2 Universal Database, Desktops, ESRI, HEAT, HTML, Management, Microsoft Office, Microsoft Windows, MySQL, Oracle, OS, PC/Windows Connectivity, Perl, PHP, Security, Servers, SQL Server, T-SQL, VB.NET, VBScript, Web site design & management, WebSphere Studio, XML
