wow. thank you very much, that's exactly what i want. implemented and wrapped. nice job -thank you.

Thanks for everyone's responses. Definitely agree there is work ahead but the cost savings of managing single digit instances of SQL Server across our R+D teams is signficant.

Thanks for the quick fire responses. We're in the financial services software business so most things do require a lot of planning 🙂 Code wise we've got some...

Thanks Grant. Do you know if SQL does an implicit conversion (or has an impact on the optimizer) if the column in the where clause is a bigint but...

I like it, but I've got a situation where I want to get it for each db in my instance. I've tried using the sp_MSforeachdb but can't seem to...

Interesting read. I am quite agnostic in terms of SQL Server and Oracle - both serve their purpose. Cost wise SQL Server hands down. Oracle for high-end...

I've worked with Spotlight for Oracle and that is good....  Did some brief analysis of Spotlight for SQL and its got some good features, namely - the integration with OS...

Thanks Jonathan; just another quick one on this - so is an REINDEX more log intensive than a DEFRAG or do they have the same footprint regards to the transaction...

Jonathon - I'm interested in your comment reorganising data and index pages.  I'm seeing a similar problem with out logs and data - with the logs twice the size as...

tlight - we had a similar problem and it turned out to be the way we created tempdb objects and didn't destroy them on persistent sessions.  We re-worked the sp's...

Sorry, I'm relatively new to SQL and from an Oracle background, the procedure - Look for locks that haven't released (sp) sounds exactly what I need at the moment.  Can...

cheers mark -> thought that was the case on the sysobjects but never did confirm. would be a cool feature mr. gates (!?)

thanks Mark. As you mentionned is a little bit of over kill but it could work. Is there anything I can do on the sysobjects table?

Thanks very much. I was leaning towards going down that route, the client has gone with UNISYS big time would be easy to arrange. Once again, thanks.