Search results for query: *

Thanks for this i'll give it a go

I have a database stuck in a loading state. Is there any way i can stop it?

Thanks all but these steps i have already tried with no luck. ?????

Hi, Does anyone know how i can clear all locking on my DB? I am unable to get any info from the Database which is causing work to halt. When i try and go to current activity to find out the blocking it times out and i cannot view. If i try to KILL processes in isqlw it takes for ever. Is there...

Hi I have SQL Ent 2000 which is currently trying to complete a recovery. The Data FIle is 60GB and the Log file is 65GB and i have a massive 24MB free space left on the drive. When i open Enterprise Mgr it just hangs. Is there any way i can stop recovery before my Database Crashes. As i assume...

I have tried the repoair tool as well. Same problem. Ok until i reboot.

Please help. I have Office/Outlook 2003 installed on my WXP Pro machine. I have 2 profiles on the box, one is able to open and use Outlook but the other, my profile cannot open outlook. I get the following error: 'Cannot Start Microsoft Office Outlook. Unable to open the Outlook window. The...

I log on to the machine with an admin account account that also has Local admins on the machine and SQL admins. I then have to log on to Outlook with the domain account. I know it would all be easier if we were all on the domain but my customer is a government customer and this is they way they...

Hi, i'm trying to make use of SQL mail and getting nowhere. My SQL server is on a workgroup and the mail account i want to use is on a Domain. Although i have the OutLook Client on the same machine as the SQL server it is not recocgnised in the SQL MAil profile. Will my SQL server need to join...

Hi, I have a Data file of 17GB and a Transaction Log of 78GB! Can anyone tell me why this might be and how i sort it out? Thanks Dylan

Hi, This is probably a real simple question for most of you but i'm just not sure how to set it up in SQL. Using MSSQL 2K I want to set up a job to run a report off and then email that report to a recipitent. I know how to set up SQL Mail to email notification when a job completes and so...

The client machine is W2K pro using Norton Firewall. However this is disabled. ping requests from server to client timeout on IP address and host unknown for PINGing hostname. Thanks

Thanks for your help. i'm getting there. The client W2K machine with 192.168.... address can see the Server XP machine 192.168.0.1 but the Server (XP machine cannot see the client (W2K) ??? Almost there any ideas? thanks again

So i enable ICS on the XP machine (as this is the one hosting my internet connection) and set both the W2K and XP machines to obtain IP automatically??? or just the 2K machine and set static IP for the XP machine? Also the website you mentioned...

Ok here is is. I have one machine with XP Home and on machine with W2K Pro. I am trying to network them together simply by connecting a CAT5 cable from one machines NIC to the others. The XP home machine will be my main machine connected to the internet via a USB Cable modem I set up the...

Unfortunatley it's NG-FP3. So i guess i'm stuck. Reason - Customer wants a list...amongst other things. Cheers anyway

Hi, Does anyone know a way i can extract the rule base to a HTML format at all?? I am told there is a script that can do this. Thanks in advance Dylan

Thanks James. I ran your script and it said completed successfully, checked the database and all good. Thanks for your help guys. You have definatley saved my life here. Cheers Dylan

Thanks guys. Unfortunatley the tape has now been over written so doing the restore again is no longer an option. So i'm going to have to try going down the 'Searching the SQL Programming forum' in the hope that there's something out there that will help me force no recovery. Thanks for your...

Thanks for responding Bill. I have checked BackupExec and the recovery option was set to No Recovery. Will This be a problem?? Thanks Dylan