Hello Nicholas,

I know this subject was discussed some time ago, but I am new to SQL and was wondering if you had enhanced the original script yet. I am in...

Hello Tom,

Once I have an understanding on how to build the query it will become a stored procedure and run daily, populating another table with the results and then using SQL...

Thanks for the quick reply John

The data is not ordered. Basically the report that has been requested is trying to find trends of phrases grouped by SessionID

The every 100th is...

Sorry for the late response

Yes ms04-011 is installed

There are no errors in the event log

The CPU is high until you start to disconnect the remote enterprise manager connections afterwhich it...

Thanks for the quick responses, I will let you know how I get on

That is right jon, I want hold the resulting scripts in sourcesafe. The databases are very large and although we do backups I just wanted the schema including indexes, SP...