How can we help you today? How can we help you today?

Help compairing system databases

For auditing and security reasons I need to establish SQL Server 2000 v8.00.818 "baseline" master and msdb databases on a "secure" instance so I can compare other instances against them.

When I compare the baseline master database with another master database, using SQL Compare 5.2.0.32, only 51 objects are compared.

Any recommendations on how I can get a full compare of system databases?

Thanks
Mike Edwards
medwards
0

Comments

2 comments

Sort by
  • medwards
    Found the problem. SQL Compare filters out system objects.
    Believe this should be an option.

    While synchronizing system objects is a dangerous thing, being able to report differences in system objects is a very usefull thing.

    If anyone has suggestions, please let me know.

    Thanks
    Mike
    medwards
    0
  • Brian Donahue
    Hi Mike,

    That's indeed something to look into. I found myself wanting to compare two MSDB databases the other week to troubleshoot a problem and didn't get anything back from them.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.