Recent content by mlawrenson

thanks for these replies. Interesting that bfitzmai mentions that the web based courses are good refreshers, because really that is what I am after. Having completed solaris certification on version 7 back in 2001, I was working with 2 solaris servers for a while. But I haven't touched Solaris...

Hello, wondered if anyone had any experience of Sun Web Based Training? I am interested in the Solaris 9 OS courses which are only £305 bargain! Or is this a false economy and should I just do the classroom based course? Thanks in advance

Hello, I am having a few printing issues on Solaris 9, so I looked at the log file /var/lp/logs/lpsched, and the contents is as follows: 01/02 07:53:28: printer fault. type: mail sorchard, status: c msg: (printer breaks the connection) 01/02 07:53:32: printer fault. type: mail sorchard, status...

Hello, just taken the 9i performance tuning and failed by 3%. I used the Sybex study guide which was good, and helped me to pass other tests, I also use the "self test" software practice tests which again in the past have been very good. On the practices I was getting around 80%, but when I came...

We have a requirement to deploy Crystal Ease to 400+ PC's via Group Policy. The Crystal Ease software comes with its own MSI which installs without a problem if installed manually. The problem comes when the MSI is assigned to a group policy for deployment. There are 2 symptoms when this is...

Thought I'd update you on this. I ran the SQLIOStress Utility over last weekend and it reported various stale read errors. Check it out with our hardware vendor and they have released a firmware upgrade to their disk controller which fixes the problem of SQL Server stale reads, and other sql...

Did you ever get anywhere with this? I have got the exact same problem with one of my DTS jobs.

thanks mrdenny, where shall i put the file?

thanks for your replies. The stack dump starts with the following: This file is generated by Microsoft SQL Server 8.00.760 upon detection of fatal unexpected error. Then goes onto say: * BEGIN STACK DUMP: *...

Hello, We have a SQL Server 2000 SP3 running on Windows 2000 ADvanced Server, failover cluster. We have been getting consistency errors reported by dbcc checkdb. Normally we get them once or twice a year, but in the last few days we have been getting them regularly. We run a dbcc checkdb as...

Thanks again SQLBill. Do you have know of any document I can read on the point you make about always stopping the sql services by Cluster Manager. I'm putting a working intruction together and it would be nice to have something to back it up with.

Thanks for your replies. I found a best practices document on ms web site, that says "Starting, pausing, and stopping the SQL Server service should be done through Enterprise Manager whenever possible." But it doesn't really explain why, and it doesn't actually say not to shutdown the server...

Hello, Is it ok to just shutdown windows or should we stop the sql server services manually before we shutdown the server? I read a thread on here that has been archived regarding the correct procedure to follow when shutting down a sql server. Does anyone know the official line from Microsoft...

Thanks I took your advice and past. As mentioned elsewhere on this topic. The self test software practice exams are harder than the real thing, I was getting about 78% on the practice tests, but I got 88% on the real thing. Thanks again. Martyn

Hello I am about to go for the 1ZO-007 SQL exam. I have read the sybex study guide and I bought the "Self Test Software" practice exams. I'm doing ok on the practice exams. But I find that I keep running out of time. Have other people found that they have run out of time on the real exam?