Browse by Tags

Get basic Database Mirroring information- principal or mirror

Published 19 August 7 5:32 PM | SSQA.net

SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc...

Filed under: sql server, high availability, database, database mirroring, tsql, principal, witness, mirror

Control metada visibility using few 'simple' statements

Published 9 August 7 5:3 AM | SSQA.net

You may be aware that a user in a SQL Server 2005 database can only see metadata that the user either owns or on which the user has been granted some permission. A default policy enhanced as compared to how a DBA can control the security access to the...

Filed under: security, access, view, tsql, principal, privileges, metadata