Hi,
Hope this isn't too much of a stupid question, but I'll ask it anyway. The reason for asking is too long and involved to go into here, so I won't...;)
I have created a small VB app that checks to see if URL1 is up and valid, if not it directs users to URL2. This works well, but just...
Hi,
I have recently setup SQL Server 2000 using Server 2003 Clustering services. The two node servers have dual processors. I have setup the clustering service in an Active/Passive configuration, with the SQL service assigned to one of the groups, so if node1 fails the SQL duties are passed to...
...I was asked to have a look at a friends ADSL connection last night. He had been complaining of slow access times and timeouts. I could see, from the modem utility software, that the line was continuously generating errors. On seeing this I phoned the provider to request a line test, at the...
I am looking for an alert to let me know when my DB gets to a certain % remaining. I know the alert 9002 alerts you to DB logs getting to a certain %, is there a similar alert for a database.
The reason I am asking this is due to a problem, I'm yet to trace, with the database not expanding...
Say I have a table with a couple of hundred records in it.
I only want to return records 1, 3, 7, 10, 14, 20, 89 etc etc....
I would assume(wrongly) that the syntax would be the following -
select * from table where field = 1, 3, 7, 10.......etc
Can someone point me in the right direction...
Hi,
I need to create a dual boot system with XP Pro and Windows 2000 Pro. The only problem is I have XP installed at them moment and I gather best practice is to install the oldest O/S first. This isn't really an option. I have 2 HD's in my PC, 160GB(XP PRO), 80GB(empty).
So, I am basically...
Hi guys,
I had been tasked to setup a generic mail box using IMAP on 5 PC's. Each PC can be used by 5 users. So in order to setup this generic mailbox on their windows profile, I had to logon to each PC with 5 different usernames and run through the profile/email account creation some 30...
Hi,
I have managed to setup IMAP within OL2002 using a rule to send sent emails to the IMAP sent folder and not the 'Personal Folders' sent items folder. I have also set this IMAP account up using a seperate profile which the user will access using a shorcut(with appropriate switch) setup on...
Hi,
I'm in the process of testing out log shipping on SQL Server 200 Standard Edition and as such I am having to do so manually, no cool easy to use wizards for me!:(
Am I correct in thinking that once a full backup has been taken of the database and restored on the standby server, there is no...
Hi,
Does anyone know if there is a way to exclude the log file from being backed up while creating a differntial backup through enterprise manager. It seems to lump the mdf and ldf into the same backup device. There is an option when you create a full DB backup to only backup the ldf, but I...
I have what seems like an easy problem to solve but I just can't seem to work it out!
I have two email accounts setup in Outlook 2002, one Exchange the other POP3. I can't for the life of me get the recieved email to deliver into the appropriate inbox. All the email appears into one inbox...
I've been assigned to administer a SQL server 2000 database. I want to implement a log shipping routine, however I have just noticed that the server is installed with Standard edition. With a bit of digging about I have found that the log shipping wizard isn't available in this version...
I have created a simple VB app with several label and text boxes. All is well on the PC I have developed on, but when I create the exe and bring it into work the label boxes have disappeared. The program worked fine in both VB and the compiled exe on the development PC. I have installed the...
Hi,
I am using the Full recovery model on SQL Server 2000, if I was to schedule the TXN log backups to run, say three times a day, would this prevent users from using the system related to the database, or would it not make a difference to the front end?
Also, when I create a backup job in...
I can't seem to get anywhere with this problem. When I attempt to configure any of my ports in the RRAS console I get the following error.
The port information cannot be saved.
Cannot complete this function
(800703eb)
I can't find anything about it anywhere on the net. I don't suppose...
Hi,
I have set up a simple GPO at the domain level. My W2K client seems to be receiving the Security settings of the GPO, e.g. I can set the password length and it is reflected on the Client. However when I change something on the GPO Administrative Template e.g. Disable Advanced button on...
Hi,
I have a Wirelss laptop that has problems connecting to the Default Domain Policy on the DC. I think I have narrowed it down to the fact that the Wireless card sets itself up after the attempt to connect to the GPO. I manages to log on and find the roaming profile, but it looks like the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.