Oh no! We've done the reinstall of SQL Server and attached the databases back to it. Unfortunately we still have the same problems. Does anyone know where...

yes, we have all the dts jobs saved in files. I think we are gonna just go for it today, we have a back up of the server which...

Just to update anyone who is interested.

I updated our servers to version 2.7 which I downloaded from the microsoft site. This was so straight forward and I...

Thanks for your info on this. So i've decided I am going to upgrade all servers running SQL Server to having MDAC 2.6 on them. Did you download...

The Problem is occuring on a users machine who is trying to run a DTS. When she runs it, it just crashes. This does not occur on any...

We have Spotlight on SQL Server by Quest. I like this software and use it alot. I can leave it running all day without it impacting our server...

Open Performance Monitor

Click View Log, Options Log and then enter the name you want to save it as (*.log) and change the interval seconds to something larger than its...

Is this only for tempdb or should we do this on all databases. I have just implemented a job that does the dbcc dbreindex periodically. Would you advise...

Thanks for that. Our version is 7.00.916

These means i have sp3. Should i get the sp4? What does it do if i do get it?

Meg

...

How can I tell if we have all the latest service packs on our server?

I could be totally wrong but....

I had a similar problem when i first started looking after our database. I noticed that every now and then a DBCC would start...

You might want to try putting your transaction logs on a different disk set to your data files. It takes the pressure off, the writing to file and writing...