Depending on a number of things: you could truncate the table if you wanted to completely empty the it.

put the db in simple recovery and delete the records in...

Find the mdac.inf file (probably C:\Windows\Inf)

Right Click -> Install point at location for win2k or whatever disk.  This should reinstall to whatever is the on the disk.  You can then...

I think I have fixed it.  I don't know whether this is a school boy error or not. 

When I applied SP4 I connected to the Server via Remote Desktop. ...

Thanks for the suggestion.  But the proc is called in exactly the same casing.  I would love to get to the bottom of this.

Cheers

Jamie

Hi Colin,

Thanks for the reply.  I did a bit of research before posting my original post and what you have said rings kind of true as the proc was called...

Senthil,

The best way I have found for this is using the following counter in perfmon:

Process\PrivateBytes\SqlServr

Then reset the scale to 0.000001

Jamie