Nuts, one of the standard ones that come with SQL, I'd hoped it was a 3rd party one instead .

I take it you're using...

I'm afraid so, we're also on Itaniums in our production environment and have similar problems.

The issue here is that the dll's that are being used in the XP are compiled...

No, just the SQL Service pack, thinking back to when we were on SQL 7 we had several occurances where people on a higher SP had opened and saved the...

Not a problem, I found a small utility called MD5File.exe which you can use to generate an MD5 hash for a file and then repeat after it's been copied, so...

A seperate NIC is also the way to go, I'd forgotten that bit

I'd agree with Brian, we have a very similar situation and manage perfectly well with MSCS.  I've done some research into Veritas clustering in the past and whilst it looks...

I agree with Hilary, FTS is definately the way to go in this situation.

If you're storing documents inside SQL Server (PDF etc) you can also download iFilters for them which...

I've sucessfully used robocopy for this type of thing in the past, but because I'm paranoid I also generate a MD5hash before and after I sent it, so long as...

When you say you updated the statistics, do you have auto-update on or do you do it manually, It could be that the table has reached the limit where the...

that kind of implies that none of the queries were running more than 1500 ms, but if that's not the case then you should definately double-check by running it on...

I tend to run profiler on the server but have it set to only log queries with a duration of 15000 ms (15 seconds), this significantly reduces the results being...

You need to qualify the object with it's owner name.

create view dbo.checks with schemabinding as select sno from dbo.test

Should do it

DTS packages are things that you have created to do a specific job on a server(s).

Jobs are generally used to start the DTS package running at a certain time (and...

Hi Dave,

Can I just confirm that you are capturing the SQL:BatchCompleted events rather than the batch starting ones, I know you've said you are but please double-check, if it's completed...

It sounds to me as if too many people have access to sysadmin, just look at it this way, sysadmin on a SQL Server is effectively GOD, do you really...