Lisa

Can you please send me the source code you are using to generate the script , let me check and comeback to you.

Regards

Murali

DBCC...

These commands clears the allocated buffers but does release the memory taken by SQL SERVER

Thanks

Murali

I would recommend to select the options to over-write all the components at the time of insallation.

so that you can have a complete seup.

The oher choice is to uninstall...

Hi

Your question is ambiguous , you said SQL 2008 is already installed , do you mean installing a new instance.

cheers

Murali

Hi

There is no way to claim back the memory , have to restart.

Cheers

Murali

Sorry Guys I was on a vacation so could not amend the script with the necessary changes. comments and enhancements are much appreciated. I am glad that the script is...

New version is available pls check and let me know

Can you try the below and let me know :

*************************************************************************

DECLARE @idxTableName SYSNAME

DECLARE @idxTableID INT

DECLARE @idxname SYSNAME

DECLARE @idxid INT

DECLARE @colCount INT

DECLARE @IxColumn SYSNAME

DECLARE @IxFirstColumn BIT

DECLARE @ColumnIDInTable INT

DECLARE @ColumnIDInIndex INT

DECLARE...

Hi Andy ,

I tried in SSMS for SQL2005, SQL2008 , SQL2008R2 .

I could not reproduce your error , It looks like more an environment issue .

Do you mind...