I'm sure there are other ways to do this. However, for simplicity we have done it a the folder level.

Datasources

Type 1

...

I'm not sure if anyone else has a better solution.

When I did this I used RSScripter ( http://www.sqldbatips.com/showarticle.asp?ID=62 ). I was able to script out the objects...

I would like to thank everyone for the great feedback on this thread.

The original matrix I posted was created from a quick review of what I found when I did...

I would have to agree. I used the attached matrix to help with my selection. Idera, SQLSentry and Oracle rose to the top for the features I was...

This might get you a little closer for the list of objects.

SELECT *

FROM master.sys.objects o

WHERE NOT EXISTS (SELECT 1 FROM master.sys.system_objects so WHERE so.object_id = o.object_id) ...

Basically you could create something like this.

SELECT command = CASE

WHEN OBJECTPROPERTY(object_id, 'IsTable') = 1 THEN 'DROP TABLE '

WHEN OBJECTPROPERTY(object_id, 'IsView') = 1 THEN 'DROP VIEW '

WHEN OBJECTPROPERTY(object_id, 'IsProcedure') =...

I don't have a full solution. However, I would start with a query to determine what objects have been added to the master database.

This statement will show all objects...

I was wondering about the Best Practices Analyzer.

Where is that located in SQL Server 2005.