OS

Managing SQL 2000 server over the internet

I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.

Proccess keep running. Cant find a solution

Hi, I have SQL Server 2000 SP4 running on a server with 2GB RAM , 18GB free in the DB disk and 2.3 GB free in the OS disk. It was running normally til 2 days ago. Now I have processes (dtss and jobs) running for 2 days. I tried to stop sqlServerAgent, but it happened again. What may be wrong? How...

Exchange/OWA Password Change error

We are getting IIS error 5 when users are trying to change their password through OWA. I've deleted and recreated the virtual PWD directory in IIS with sucess once but the problem has reappeared and it doesn't help this time. Running 2k3 server sp1 and 2k3 Exchange sp2 Mcafee Groupsheid for...

Wireless connection unable to browse Internet

I run a Windows 2003 Server LAN, with Windows XP clients. All machines are members of the LAN and Group Policy is in place. The LAN uses DHCP with DNS servers and gateway specified. Notebooks that are part of the domain, when connected to the network (wired or wireless)have no problems accessing...

Remote Authentication to AD Server

Our main site uses Active Directory, but our small remote sites do not; users up to this point had no need to log on to the domain. Now, we have a remote user that needs to log on to the domain. How do I point him there? What will I need at the AD end? Sites are connected via DSL. Prior to my...

Count Distinct Rows on Multiple Columns

I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane ...

Viewing SQL2005 Stored Procedure Code(DataReader)

We have a developer team that has been accustomed to viewing stored porcedure code through Enterprise Manager in SQL2000. We noticed that when having the same DataReader rights in SQL Management Studid(SQL2005) they cannot view the stored procedure code. Is this a bug in SQL2005 or is there another...

Wake-On-LAN / Cisco Mac address-tables

Recently I scheduled my computers to power on using Wake-On-LAN. There seems to be an issue with some of the computers not turning on. All the computers have identical hardware and have the same BIOS settings. I did some investigation and I noticed that the computers that were not turning on did...

Max Row Size Error in SQL 2000 Update Error

Dear All, I have two tables T1 & T2.T1 is having 14501452 and T2 is having 15012458.I am running following queries and getting max row size error. "update t2 set t2.present='Y' from t1 where t2.no=t1.no" Please help

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 access will see the database...

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 still not send the file. Can...

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...

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...

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...

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...

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...

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...

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...

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...

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