Definitely sounds like MDAC.

Use component checker (see link) to see what version of MDAC you have and, if necassary, reinstall.

http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

You may find that you have disparate parts of MDAC...

Was no-one taught BODMAS at school?

Order of calculation is Brackets, Division, Multiplication, Addition, Subtraction.

Can't remember what the 'O' stands for!!!

So far...82% of people have got this right.

Surely no-one cheated did they?

Please could you elaborate?

Regards

Jamie

Hi there,

Yukon DTS will certainly make this kind of activity alot easier through the use of Configurations (if I understand them correctly). The idea being that you can set up...

Yes. A UDF. I knew there was a way of doing this.

Triggers aren't an option for political reasons rather than technical. The client frowns on triggers.

Thanks talleman

Ignacio,

There are many such tools out on the market. Microsoft push their own product called Data Analyser although this isn't a zero-footprint tool.

Check out: MIS AG, ProClarity, Panorama....to name but...

A nice concise article as an introduction to the mega-complex area of performance tuning - just the sort of thing I need.

Much appreciated.

Jamie Thomson

Conchango UK

Works a treat. Thanks AH.

Still annoying about sp_depends though!!!