Browse by Tags

• access
• database
• database mirroring
• high availability
• metadata
• mirror
• privileges
• security
• SQL Server
• tsql
• view
• witness

• Get basic Database Mirroring information- principal or mirror

  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 Read More... Posted Monday, August 20, 2007 8:32 AM from SSQA.net | (Comments Off) Filed under: SQL Server, tsql, database, database mirroring, principal, high availability, witness, mirror

• Control metada visibility using few 'simple' statements

  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 Read More... Posted Thursday, August 09, 2007 8:03 PM from SSQA.net | (Comments Off) Filed under: security, tsql, access, view, privileges, principal, metadata