datamining SQL with access
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that [...]
Answer Question
| July 4, 2008 4:29 PM
Access, Data analysis, Data mining/analysis, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that [...]
Answer Question
| July 4, 2008 4:29 PM
Access, Data analysis, Data mining/analysis, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Exchange 2003 not able to change send and receive file size limits
I have a user that needed to send a 50 Mb PDF file. His send and receive file size limits were 10Mb. So I changed them to 60 Mb but Exchange would not retain the new changes. It allowed me to make the change but is not retaining the changed settings and the user could [...]
Answer Question
| January 4, 2007 9:18 PM
Desktops, Exchange, Exchange security, Hardware, Interoperability, Management, Microsoft Windows, OS, Security, Servers, Software, Spam, SQL Server, Tech support
I have a user that needed to send a 50 Mb PDF file. His send and receive file size limits were 10Mb. So I changed them to 60 Mb but Exchange would not retain the new changes. It allowed me to make the change but is not retaining the changed settings and the user could [...]
Answer Question
| January 4, 2007 9:18 PM
Desktops, Exchange, Exchange security, Hardware, Interoperability, Management, Microsoft Windows, OS, Security, Servers, Software, Spam, SQL Server, Tech support
Roaming Profles and Default Printers WinXP Server 2003
Does anyone know how default printers are handles when using Roaming Profiles with Windows XP and Server 2003? I am deploying printers per machine with GP; so all the computers do not have the same printers, but my clients are complaining that they always have to set the default printer. I thought this may be [...]
Answer Question
| January 4, 2007 11:36 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
Does anyone know how default printers are handles when using Roaming Profiles with Windows XP and Server 2003? I am deploying printers per machine with GP; so all the computers do not have the same printers, but my clients are complaining that they always have to set the default printer. I thought this may be [...]
Answer Question
| January 4, 2007 11:36 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
Changing File Ownership to allow Disk Quota’s to work – Windows 2000
Hello, I have a windwos 2000 domain, recently I have been trying to configure disk quotas. Problem is Disk Quotas work on file ownership and alot of the data on the server was copied over from another server when we merged with another office. Therefore a large amount of user data is owned by the [...]
Answer Question
| December 28, 2006 7:08 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Hello, I have a windwos 2000 domain, recently I have been trying to configure disk quotas. Problem is Disk Quotas work on file ownership and alot of the data on the server was copied over from another server when we merged with another office. Therefore a large amount of user data is owned by the [...]
Answer Question
| December 28, 2006 7:08 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Critical Error in Security Log
All, I mamange a Windows 2003 Small Business Server Network with 9 clients. The server provides all network services. We use Logon/logoff, shared storage, and print server functions. We do not use exchange except for the server reporting tool. We do use about 4 instances of SQL. All clients are Windows XP Professional patched to [...]
Answer Question
| December 28, 2006 7:08 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
All, I mamange a Windows 2003 Small Business Server Network with 9 clients. The server provides all network services. We use Logon/logoff, shared storage, and print server functions. We do not use exchange except for the server reporting tool. We do use about 4 instances of SQL. All clients are Windows XP Professional patched to [...]
Answer Question
| December 28, 2006 7:08 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
password recovery of win 2003 server…..
Hi, I disjointed my server from the domain and I forgot the local administrator password of this server!!!!now I don’t have the access to the server!!! I downloaded some free password recovery tools from internet but they are demo version!!! Could you please help me!!??? Thank you. —– Regards Mahnaz
Answer Question
| May 24, 2010 3:28 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Hi, I disjointed my server from the domain and I forgot the local administrator password of this server!!!!now I don’t have the access to the server!!! I downloaded some free password recovery tools from internet but they are demo version!!! Could you please help me!!??? Thank you. —– Regards Mahnaz
Answer Question
| May 24, 2010 3:28 AM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Domain Rename
I recently had to rename a domain. Everthing went fine and as planed (surprise!) using the latest tools. However, when I ran gpfixup it reported that the operation completed with errors, please check. Everything seems ok. Where and what should I be checking for these errors? There doesn’t seem to be anything in the documentaion [...]
Answer Question
| January 1, 2007 3:18 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
I recently had to rename a domain. Everthing went fine and as planed (surprise!) using the latest tools. However, when I ran gpfixup it reported that the operation completed with errors, please check. Everything seems ok. Where and what should I be checking for these errors? There doesn’t seem to be anything in the documentaion [...]
Answer Question
| January 1, 2007 3:18 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
iSeries accessibility to VB.NET, ASP 2.0/3.0 ,NET programmers in Visual Studio
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 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
My shop does not have WebSphere but does have a sizeable VB.NET team using the MS Visual Studio. They need access to the iSeries files in DB2/UDB – real-time. We already thanks to me have a number of batch/DTS package type transfers. Do any of you know packages that can make the iSeries files available [...]
Answer Question
| October 14, 2010 10:35 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
Inetinfo.exe service takes CPU usage…..
Hi, I have a so slow server!!! The OS is win2003 server Enterprise edition R2 and it is SQL Server and IIS server too. When I check the cpu usage the inetinfo service takes 50% !!!!!!and my server is too slow!!! What’s the problem!!!!??? What can I do!!!??? It’s too urgent for me!!! Could you [...]
Answer Question
| January 4, 2007 4:24 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
Hi, I have a so slow server!!! The OS is win2003 server Enterprise edition R2 and it is SQL Server and IIS server too. When I check the cpu usage the inetinfo service takes 50% !!!!!!and my server is too slow!!! What’s the problem!!!!??? What can I do!!!??? It’s too urgent for me!!! Could you [...]
Answer Question
| January 4, 2007 4:24 AM
DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
SQL Server 2000 Performance issue
Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the web application. I [...]
Answer Question
| December 26, 2006 5:02 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Hello! I am .Net developer.My client has more than 300 outlets for transaction sql server queries. When web application runs, SQL Server2000 occupies 100% CPU usage & uses 1.7GB memory usage. I am really confused how to minimize the CPU usage of SQL Server2000 as it slow down the performance of the web application. I [...]
Answer Question
| December 26, 2006 5:02 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL, SQL Server
Win XP Pro & Win 2K Pro – Track Logins
Is is possible to obtain local user sign-on information? i.e. time / date / user name. Also, what is the easiest way to create a login reports for future use. Thank you
Answer Question
| December 26, 2006 4:26 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Is is possible to obtain local user sign-on information? i.e. time / date / user name. Also, what is the easiest way to create a login reports for future use. Thank you
Answer Question
| December 26, 2006 4:26 PM
DataCenter, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Unchangeable Calendar items – setting an originator
Hi there, I’ve encountered a really peculiar problem… Background: We’re running an exchange server 2003, all clients use Outlook2003. Using the AD(2003) I’ve change a user details and email from dorothy to sigalit. The only things that I’ve change are her name, display name and email adrs. Few minutes after, I was asked to return [...]
Answer Question
| December 18, 2006 4:02 AM
Desktops, Exchange, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Hi there, I’ve encountered a really peculiar problem… Background: We’re running an exchange server 2003, all clients use Outlook2003. Using the AD(2003) I’ve change a user details and email from dorothy to sigalit. The only things that I’ve change are her name, display name and email adrs. Few minutes after, I was asked to return [...]
Answer Question
| December 18, 2006 4:02 AM
Desktops, Exchange, Management, Microsoft Office, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Windows XP power settings not staying…
The setup: Server: Windows server 2003. Workstations: Windows XP Mandatory roaming profiles. All computers login as the same user. I do not want the computers to go into standby or hibernate or turn off the monitor. I have configured mandatory profiles, set the workstations into ‘Presentation’ scheme, and even went into Group Policy and enable [...]
Answer Question
| October 6, 2008 11:24 AM
DataCenter, Desktop management applications, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
The setup: Server: Windows server 2003. Workstations: Windows XP Mandatory roaming profiles. All computers login as the same user. I do not want the computers to go into standby or hibernate or turn off the monitor. I have configured mandatory profiles, set the workstations into ‘Presentation’ scheme, and even went into Group Policy and enable [...]
Answer Question
| October 6, 2008 11:24 AM
DataCenter, Desktop management applications, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server, Tech support
Windows 2003 Server R2 mmc error…………….
Hi, When I use of some windows program or want to make a mmc for using windows programs it got an error about the version of mmc!!! My OS is windows 2003 Server R2,could you please help me? Thank you. — Regards Mahnaz
Answer Question
| December 12, 2006 3:32 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
Hi, When I use of some windows program or want to make a mmc for using windows programs it got an error about the version of mmc!!! My OS is windows 2003 Server R2,could you please help me? Thank you. — Regards Mahnaz
Answer Question
| December 12, 2006 3:32 AM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
AMD Sempron
Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?
Answer Question
| April 9, 2012 4:25 AM
390, Cabling, DataCenter, DB2, Desktop management applications, Desktops, Hardware, Hubs, Linux, Mainframe, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support
Hi all, I have one desktop running on AMD sempron 2200. In my home network. It?s clock speed is 1.5 GHz as per manufacture?s specification. but in system properties It showing only 800 MHz. OS is using XP SP2. But it working very smoothly. Anybody have any idea about why it likes this?
Answer Question
| April 9, 2012 4:25 AM
390, Cabling, DataCenter, DB2, Desktop management applications, Desktops, Hardware, Hubs, Linux, Mainframe, Management, Microsoft Windows, Networking, OS, Routers, Security, Servers, SQL Server, Switches, Systems management software, Tech support
convert public folder IPM.POST to IPM.NOTE
i have an sbs 2003 with exchange runing on it and gut a public folder that i’ve created for general mail to the employee’s. i’ve routed all mail to that folder from specific account, the problem is that the mail’s arrived as a IPM.POST format mails and not like the traditional mails that is more [...]
Answer Question
| December 4, 2006 6:56 PM
Application security, Availability, Bandwidth, Biometrics, Business/IT alignment, Database, DataCenter, Desktops, Digital certificates, E-business, Encryption, Exchange, Exchange security, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spam, SQL Server
i have an sbs 2003 with exchange runing on it and gut a public folder that i’ve created for general mail to the employee’s. i’ve routed all mail to that folder from specific account, the problem is that the mail’s arrived as a IPM.POST format mails and not like the traditional mails that is more [...]
Answer Question
| December 4, 2006 6:56 PM
Application security, Availability, Bandwidth, Biometrics, Business/IT alignment, Database, DataCenter, Desktops, Digital certificates, E-business, Encryption, Exchange, Exchange security, Identity & Access Management, Instant Messaging, Management, Microsoft Windows, Networking, OS, provisioning, Secure Coding, Security, Security tokens, Servers, Single sign-on, Spam, SQL Server
Accessing Mail Server
I have remote users who are not allowed on the domain… At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get [...]
Answer Question
| November 30, 2006 4:19 AM
Access, Availability, Cabling, DataCenter, Desktops, DHCP, DNS, Exchange, Hardware, Hubs, Management, Microsoft Office, Microsoft Windows, Networking, Networking services, OS, Patch management, Routers, Security, Servers, SQL Server, Switches, Web services, Wireless
I have remote users who are not allowed on the domain… At times they need to work in the main office and log in via wireless directly to the Wirelss ADSL modem/router.. putting them in a different ip range to the domain. Internet access works well with this arrangement but they are unable to get [...]
Answer Question
| November 30, 2006 4:19 AM
Access, Availability, Cabling, DataCenter, Desktops, DHCP, DNS, Exchange, Hardware, Hubs, Management, Microsoft Office, Microsoft Windows, Networking, Networking services, OS, Patch management, Routers, Security, Servers, SQL Server, Switches, Web services, Wireless
Database Tuning Advisor “not permitted” error on SQL Server 2005 DE
Hi! I’ve bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I’ve installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: “Tuning this edition of SQL Server 2005 is not permitted.” [...]
Answer Question
| November 29, 2006 10:05 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Hi! I’ve bought the Visual Studio 2005 Professional Edition and with it comes Visual Studio SQL Server 2005 Developers Edition. I’ve installed it and started developing my applications, but now when I try to tune it with the Database Tuning Advisor I get the error-message: “Tuning this edition of SQL Server 2005 is not permitted.” [...]
Answer Question
| November 29, 2006 10:05 AM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
SBS 2003 Monitoring No More
Running SBS2003 with patches up-to-date. I had been getting regular reports, daily and weekly, on the status of the server. These reports suddenly stopped after November 4. When I go to the Server Management console, and select Monitoring and Reports, I get the message, in the right hand pane “Server Error in ‘/Monitoring’ Application. ————————————————————————– [...]
Answer Question
| December 3, 2006 2:44 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Running SBS2003 with patches up-to-date. I had been getting regular reports, daily and weekly, on the status of the server. These reports suddenly stopped after November 4. When I go to the Server Management console, and select Monitoring and Reports, I get the message, in the right hand pane “Server Error in ‘/Monitoring’ Application. ————————————————————————– [...]
Answer Question
| December 3, 2006 2:44 PM
Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server, Tech support
Would upgrading to a managed/faster switch help?
I have a client that currenlty has an unmanaged 10/100 24 port D-Link switch. I was wondering the pros and cons to upgrading to a Cisco 2950 10/100/1000 switch. The current (simplified) network diagram. Clients/Server—–>Dlink Switch—–>Linksys Router—–>Internet I was thinking, if possible, upgrade to the Cisco switch because it has two 10/100/1000 ports. Could I [...]
Answer Question
| November 29, 2006 4:44 PM
Bandwidth, DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server
I have a client that currenlty has an unmanaged 10/100 24 port D-Link switch. I was wondering the pros and cons to upgrading to a Cisco 2950 10/100/1000 switch. The current (simplified) network diagram. Clients/Server—–>Dlink Switch—–>Linksys Router—–>Internet I was thinking, if possible, upgrade to the Cisco switch because it has two 10/100/1000 ports. Could I [...]
Answer Question
| November 29, 2006 4:44 PM
Bandwidth, DataCenter, Desktops, Management, Microsoft Windows, Networking, OS, Security, Servers, SQL Server
