Hi

This page http://support.microsoft.com/kb/321185

gives you this bit of code:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

which will show you the edition and service pack for your SQL boxes

Seth

Thanks - That trace tool could be good.

The problem is that this app was developed over years and some SQL code is in the database (where it should be) and...

Hi

I suspect it is incomplete and someone put SET in by mistake and left it there.

The strange thing it that SQL Server 2000 seems to ignore it and 2005 +...

Hi

This is the script use - it reindexes everthing though - whether it needs it or not:

USE Master

DECLARE @dbName varchar(255)

DECLARE @sql varchar(500)

DECLARE dbCursor CURSOR FOR...