Chris,

Just check the database properties for all the databases using sp_helpdb in QA, Are owner and stutus same for all databases.

Santveer

please use this script

Select a.name,backup_type, Backup_Date from master.dbo.sysdatabases a

left join

 ( select database_name, Backup_Type = Case type  when 'D' then  'Database'

       When 'I' then  'Database Differential'

       When 'L' then  'Log'

       When 'F' then  'File...

All,

Regarding CMAX function, this is actualy a typoerror... please read it MAX function.

I didn't include DELETE FROM [ObjList] becuase I want to maintain the history also. If some one don't want to maintain the history, he/she may include the DELETE statement. This is...

Mike,

Thanks for the suggestion.

Santveer

Pete Schott,

I agree with you. I got a number of emails to include Backup type in this script.

Below is the revised script to take care of this issue.

Select a.name,backup_type, Backup_Date...

Below script will provide missing records in db2

SELECT     *

FROM         db1.dbo.table1  A Left JOIN

                      db2.dbo.table1 B ON A.u_logon_name = B.u_logon_name

Where B.u_logon_name is null

and

Below script will provide missing records in db1

SELECT     *

FROM         db2.dbo.table1 ...