SQL Error
It has nothing to do with the file size. Look at the data being imported – there is a field being converted to an integer data type which causing the problem. Since an integer is defined as whole number data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647), it’s likely that character data is being [...]
View Answer
| March 30, 2007 10:59 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
It has nothing to do with the file size. Look at the data being imported – there is a field being converted to an integer data type which causing the problem. Since an integer is defined as whole number data from -2^31 (-2,147,483,648) through 2^31 – 1 (2,147,483,647), it’s likely that character data is being [...]
View Answer
| March 30, 2007 10:59 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
File copy limmits in Windows XP
Don’t know the limits, but once a month one of us copies approx 40,000 directories, each with 2 512K files and a 1k file. so thats 120000 files. (from a server to a USB hard drive on a workstation) The 40,000 directories are selected from approx 100,000 in the parent. using windows explorer it has [...]
View Answer
| March 27, 2007 11:29 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Storage
Don’t know the limits, but once a month one of us copies approx 40,000 directories, each with 2 512K files and a 1k file. so thats 120000 files. (from a server to a USB hard drive on a workstation) The 40,000 directories are selected from approx 100,000 in the parent. using windows explorer it has [...]
View Answer
| March 27, 2007 11:29 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Storage
The time is wrong in one of my Domain controllers…………..
Hi, I should dive some extra information about my problem,first I should say:when I change manually the time of Mail server,all problems that I said appeare,if i don’t change manually the time of Mail server I can logon to it and have share folder on it but clients still have problem!!! Here are some event [...]
View Answer
| March 25, 2007 7:48 AM
Active Directory, Desktops, Management, Microsoft Windows, Network monitoring, Networking, OS, Security, Servers, SQL Server, Tech support
Hi, I should dive some extra information about my problem,first I should say:when I change manually the time of Mail server,all problems that I said appeare,if i don’t change manually the time of Mail server I can logon to it and have share folder on it but clients still have problem!!! Here are some event [...]
View Answer
| March 25, 2007 7:48 AM
Active Directory, Desktops, Management, Microsoft Windows, Network monitoring, Networking, OS, Security, Servers, SQL Server, Tech support
Network Slowdown/Delay between XP and 2003 Server
More questions than answers - A) Domain or workgroup? B) If domain, local or romaing profiles? C) DNS (active directory or not)? D) What else shares the T1 to the colocation? E) What type documents? Plaintext or XML? PDFs or MS Office? IF office haveyou reviewed the kb article on Word and Excel problems on [...]
View Answer
| March 23, 2007 3:33 PM
Availability, Bandwidth, Desktops, Management, Microsoft Windows, Networking, OS, Performance management, Security, Servers, SQL Server, Tech support
More questions than answers - A) Domain or workgroup? B) If domain, local or romaing profiles? C) DNS (active directory or not)? D) What else shares the T1 to the colocation? E) What type documents? Plaintext or XML? PDFs or MS Office? IF office haveyou reviewed the kb article on Word and Excel problems on [...]
View Answer
| March 23, 2007 3:33 PM
Availability, Bandwidth, Desktops, Management, Microsoft Windows, Networking, OS, Performance management, Security, Servers, SQL Server, Tech support
Remote Administration
You can use Remote Administrator. It installs as a service, but you don’t have to leave it in a logged in scenario. When you log out of RA it logs out the Windows user. I have personally stopped using RA and use the built in Remote Desktop provided by MS. You can find it in [...]
View Answer
| March 23, 2007 10:55 AM
DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server
You can use Remote Administrator. It installs as a service, but you don’t have to leave it in a logged in scenario. When you log out of RA it logs out the Windows user. I have personally stopped using RA and use the built in Remote Desktop provided by MS. You can find it in [...]
View Answer
| March 23, 2007 10:55 AM
DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server
Auto Logoff
The only MS way is using winexit.scr screensaver. You can read more on it at http://support.microsoft.com/kb/314999
View Answer
| March 23, 2007 10:51 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
The only MS way is using winexit.scr screensaver. You can read more on it at http://support.microsoft.com/kb/314999
View Answer
| March 23, 2007 10:51 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Default User Profile
I you have an Active Directory, use global policy. If you have it as workgroup, you will need to use local policy on each of the computer
View Answer
| March 22, 2007 1:20 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I you have an Active Directory, use global policy. If you have it as workgroup, you will need to use local policy on each of the computer
View Answer
| March 22, 2007 1:20 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
DHCP relay Agent in DELL switches
Provided that you have your VLAN setup correctly, and furthermore that you have your DHCP forwarding correct, then the DHCP REQ comes from a LAN port on subnet 172.16.5.x, and the TCP packet has headers that identify the route taken to get to the dhcp server. The dhcp server assigns addresses per that packet address. [...]
View Answer
| March 20, 2007 4:56 PM
Dell, Desktops, DHCP, DNS, Management, Microsoft Windows, Networking, Networking services, OS, Routers, Security, Servers, SQL Server, Switches
Provided that you have your VLAN setup correctly, and furthermore that you have your DHCP forwarding correct, then the DHCP REQ comes from a LAN port on subnet 172.16.5.x, and the TCP packet has headers that identify the route taken to get to the dhcp server. The dhcp server assigns addresses per that packet address. [...]
View Answer
| March 20, 2007 4:56 PM
Dell, Desktops, DHCP, DNS, Management, Microsoft Windows, Networking, Networking services, OS, Routers, Security, Servers, SQL Server, Switches
Performance Tuning One Table
When the performance on one table is bad, it can either be an indexing problem, or a storage problem. If an indexing problem, add the required index, or remove the superfluous indeces. If a storage problem, figure out how and where to store the table. This latter is specific to the DBMS in use. However, [...]
View Answer
| March 14, 2007 1:19 PM
SQL Server
When the performance on one table is bad, it can either be an indexing problem, or a storage problem. If an indexing problem, add the required index, or remove the superfluous indeces. If a storage problem, figure out how and where to store the table. This latter is specific to the DBMS in use. However, [...]
View Answer
| March 14, 2007 1:19 PM
SQL Server
Daylight Saving Time fallout
April should be fine, also November, as you have paid the Microsoft convenience tax. Those of us using Linux, BSD, et Al. live in a UTC world and did not have to deal with the change at the servers. Workstations were a one line change in the login script. Collaboration software always has its cost [...]
View Answer
| March 13, 2007 3:42 PM
Desktops, Exchange, Management, Microsoft Windows, OS, Security, Servers, SQL Server
April should be fine, also November, as you have paid the Microsoft convenience tax. Those of us using Linux, BSD, et Al. live in a UTC world and did not have to deal with the change at the servers. Workstations were a one line change in the login script. Collaboration software always has its cost [...]
View Answer
| March 13, 2007 3:42 PM
Desktops, Exchange, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Help: System Time is Wrong
Bad situation. You would need to determine the impact on your applications and data if you just set the time back. Issues such as invoices be paid before they are generated, trucks and freight arriving at destinations before the left. You best bet may be to determine what data is time sensitive, which data is [...]
View Answer
| March 13, 2007 3:22 PM
SQL Server
Bad situation. You would need to determine the impact on your applications and data if you just set the time back. Issues such as invoices be paid before they are generated, trucks and freight arriving at destinations before the left. You best bet may be to determine what data is time sensitive, which data is [...]
View Answer
| March 13, 2007 3:22 PM
SQL Server
Monitoring and Denying IP addresses assignment in Windows 2000 Domain
Check out www.netlatency.com. Although they’ve recently (how recently I don’t know) gotten into VoIP, their base is managing all of the devices on a network without a ton of overhead Good luck – and no – I won’t make a dime (or more) whether or not you check them out. Bob
View Answer
| March 11, 2007 4:16 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Check out www.netlatency.com. Although they’ve recently (how recently I don’t know) gotten into VoIP, their base is managing all of the devices on a network without a ton of overhead Good luck – and no – I won’t make a dime (or more) whether or not you check them out. Bob
View Answer
| March 11, 2007 4:16 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
External IP Connection
This is a tuff one with out knowing your network setup. I went through a similar situation several years ago setting up Oracle behind firewalls and routers and accessing directly from the DMZ. I would suggest that you run Ethereal on both “sides” of you connection attempt and get a clear picture of what is [...]
View Answer
| March 2, 2007 4:35 PM
SQL Server
This is a tuff one with out knowing your network setup. I went through a similar situation several years ago setting up Oracle behind firewalls and routers and accessing directly from the DMZ. I would suggest that you run Ethereal on both “sides” of you connection attempt and get a clear picture of what is [...]
View Answer
| March 2, 2007 4:35 PM
SQL Server
ASP .NET SQL Statement
Wolfman24, After reviewing the code posted in your last question, you can do something like this: Dim lCommand As SqlCommand Try lCommand = New SqlCommand(“Select data from table where data = “”" & UserID & “”"”, conNCIGFDNN) If lCommand.ExecuteScalar Is Nothing Then Insert() ‘call your insert code Else Update() ‘call your update code End If [...]
View Answer
| March 2, 2007 9:52 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server, Web site design & management
Wolfman24, After reviewing the code posted in your last question, you can do something like this: Dim lCommand As SqlCommand Try lCommand = New SqlCommand(“Select data from table where data = “”" & UserID & “”"”, conNCIGFDNN) If lCommand.ExecuteScalar Is Nothing Then Insert() ‘call your insert code Else Update() ‘call your update code End If [...]
View Answer
| March 2, 2007 9:52 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server, Web site design & management
SQL – IF Exists Update Else Insert
First, why are you creating the connection, executing one SQL, and then dropping the connection? Normally, you’d open the connection once, and leave it open for the duration of the application. Next, make a stored procedure (see CREATE PROCEDURE) which does the following: UPDATE the existing record If the number of affected rows is zero [...]
View Answer
| February 28, 2007 4:14 PM
SQL, SQL Server, Web site design & management
First, why are you creating the connection, executing one SQL, and then dropping the connection? Normally, you’d open the connection once, and leave it open for the duration of the application. Next, make a stored procedure (see CREATE PROCEDURE) which does the following: UPDATE the existing record If the number of affected rows is zero [...]
View Answer
| February 28, 2007 4:14 PM
SQL, SQL Server, Web site design & management
Lotus Domino Database Structure
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..
View Answer
| February 23, 2007 12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Lotus Notes viewa are not same as table structures but you can make them similar to tables. Views are not RBBMS compliant. but these viewa can be exported to tables using odbc connection or Decs or LEI etc..
View Answer
| February 23, 2007 12:12 AM
Architecture/Design, Availability, Database, DB2, Desktops, Development, Installation, Management, Microsoft Windows, Oracle, Oracle administration, OS, Security, Servers, Software testing, SQL, SQL Server
Correlated Subquery – NOT EXIST
Please post the full sql statement so I can determine where to put the not exists clause.
View Answer
| February 21, 2007 3:36 PM
MySQL, SQL, SQL Server
Please post the full sql statement so I can determine where to put the not exists clause.
View Answer
| February 21, 2007 3:36 PM
MySQL, SQL, SQL Server
DST – Server 2000
I just went over this with our network administrator. Yes you can use TZEdit to update the Time Zone information on your Windows 2000 Servers. When I tried it for myself, it appears the TZEdit has to be ran on each server individually instead of grouping them together. Once you open TZEdit, just select your [...]
View Answer
| February 21, 2007 2:34 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I just went over this with our network administrator. Yes you can use TZEdit to update the Time Zone information on your Windows 2000 Servers. When I tried it for myself, it appears the TZEdit has to be ran on each server individually instead of grouping them together. Once you open TZEdit, just select your [...]
View Answer
| February 21, 2007 2:34 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Help on SQL Expression
There are easier ways to do this. The following example uses DB2 date comparisons. SQL Server will likely use something very similar CASE WHEN seniority + 10 YEARS <= CURRENT DATE THEN 160 — 5 to 10 years falls through the cracks here! WHEN seniority + 1 YEAR <= CURRENT DATE THEN 120 WHEN month [...]
View Answer
| February 21, 2007 11:21 AM
Development, SQL, SQL Server
There are easier ways to do this. The following example uses DB2 date comparisons. SQL Server will likely use something very similar CASE WHEN seniority + 10 YEARS <= CURRENT DATE THEN 160 — 5 to 10 years falls through the cracks here! WHEN seniority + 1 YEAR <= CURRENT DATE THEN 120 WHEN month [...]
View Answer
| February 21, 2007 11:21 AM
Development, SQL, SQL Server
VSS Backup Fails On Servers Running SQL Server 2005
The backup last night failed again, but this time the SQL Server VSS Writer stayed disabled on one server. The other server had it enabled again and vssadmin list writers showed it at a state of 1 (no problems). However, VSS was disabled on both servers and Backup Exec wasn’t able to back it up [...]
View Answer
| February 9, 2007 10:05 AM
Backup, SQL Server 2005, VSS Backup
The backup last night failed again, but this time the SQL Server VSS Writer stayed disabled on one server. The other server had it enabled again and vssadmin list writers showed it at a state of 1 (no problems). However, VSS was disabled on both servers and Backup Exec wasn’t able to back it up [...]
View Answer
| February 9, 2007 10:05 AM
Backup, SQL Server 2005, VSS Backup
