SQL Server Performance

schema binding

Discussion in 'Third Party Tools' started by chetana, Apr 12, 2007.

  1. chetana New Member

    Want to uninstall the AuditDb and its schema components from sqlserver2005. Im not clear whether the agents or components installed with it bind to a particular schema. if it is, what is the best way of doing it? I just want to avoid reloading sqlserver2005?




    Thank you
    Chetana
  2. MohammedU New Member

    You need to check with AuditDB tech support to get the right answere on this but...

    It is possible that some of the objects might have shema binding but if you are cleaning them all I don't think need to worry at all...
    Make sure you are deleting only AuditDB related objects not system objects if the unistallation is not taking care of...
    And in sql 2005 you can't drop and/or modify system objects without DAC connections, so nothing to worry..

    I don't think you may to reinstall sql for auditdb cleanup...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page