• After exchanging questions with J.T. this morning I am including the information as additonal information...

    Since the SID column is the SID of the db creator this column may not be useful in this script for comparison of SID>1. The issue I encountered and discussed was that all my databases, save one, were created by sa so the SID column was 1 for all of them, only the database created under my individual user ID had a SID >1. J.T.'s solution is to replace the comparison with the follwing statement.

    SELECT NAME FROM MASTER..SYSDATABASES WHERE NAME NOT IN

    ('MSDB','MASTER','TEMPDB')

     I thank J.T. again for a wonderful article and responsiveness to queries about my results.

     

    edited to fix tipos...