Hi again ,

forgot to mention that there is a continutaion for this article (Part 2) - it's on the same page.

Oana.

Hi,

Check this out : 😉

http://www.sqlservercentral.com/articles/Administration/2988/

Regards,

Oana.

Hi there,

can you please post also a part of the xml file .. to see exactly the structure 🙂

Thanks,

Oana.

Hi,

Try this :

CREATE TABLE #t(d SYSNAME, t SYSNAME);

EXEC sp_msForEachDB 'INSERT #t SELECT ''?'', TABLE_NAME

FROM [?].INFORMATION_SCHEMA.TABLES

WHERE TABLE_TYPE=''BASE TABLE'';';

SELECT * FROM #t ORDER BY d,t;

DROP TABLE #t;

Thanks,

Oana.

Hi there,

you have this statement:

SELECT @SQL = @SQL + ' where ' + @AuditItem + '=' + @status

and you say that @AuditItem is VARCHAR and