Michael, many thanks for your code. I will look into sp_msforeachdb that look really useful. Thanks for replying. DP

Thanks Grant, my company provide code for SQL 7, 2000 and 2005 so it looks like I will have to code for both sys databases. Thanks for the guidance....

Thank you for your trouble Grant, I am grateful for your help. It seems that select * from [sysdatabases] is at the heart of the solution that I need....

🙂 Thanks very much I now have just the code that I need also you have shown me how to see inside system stored procedures, many thanks Jeff.

Thank you for that - I didn't know that there was an Advanced Express version but I'll track it down.

Andras,

Many thanks for your guidance on that.

Regards

DP

Many thanks Lowell.

Ian, many thanks I reckon that your idea of re-scripting the master stored procs is probably the way that I'll have to go. 

Chirag, I am not up to speed with...

Colin

Many thanks those two DBCC commands seem to give me reasonably consistent timings now for the same piece of code.

Thanks for the prompt reply.

David Putman

We originally had the same problem as the guy in Australia with dates in different country formats.  The SET DATEFORMAT method is one solution but a better solution is the...

Mr Grasshopper,

What you have here is a stored procedure that joins your product table to the product attribute table.  The other joins are to allow you to join to the...