ok got a little farther

no idea what this means:

declare @idxname sysname;

set @idxname = 'idx_DatePosted';

declare @idxname sysname;

set @idxname = 'idx_DatePosted';

declare @SQLCmd varchar(max);

select @SQLCmd = stuff((

select 'union all' + char(13) + char(10) + 'select ''' + db.name + ''' as DatabaseName, object_name(idx.object_id) as TableName, idx.name as IndexName from ' + db.name +'.sys.indexes idx where idx.object_id in (select object_id from ' + db.name + '.sys.tables) and idx.name = ''' + @idxname +''' ' + char(13) + char(10)

from sys.databases db

where db.name not in ('master','tempdb','model','msdb','ReportServer','ReportServerTempDB')

for xml path(''),type).value('.','varchar(max)'),1,11,'');

print @SQLCmd;

exec(@SQLCmd);

go

Msg 1934, Level 16, State 1, Server NSAB-SS80-SQL-N, Line 6

SELECT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or

query notifications and/or xml data type methods.