Home Forums SQL Server 2005 Administering How to find out the Objects Defacults Schema Details RE: How to find out the Objects Defacults Schema Details

  • You can use the following script for a specific database -

    SELECT *

    FROM sys.database_principals

    WHERE [type] IN ('U','S')

    AND ISNULL(default_schema_name,'')<>'dbo'

    Chandrachurh Ghosh
    DBA – MS SQL Server
    Ericsson India Global Services Limited
    Quality is not an act, it is a habit.