SELECT name AS DB, state_desc AS Status, recovery_model_desc AS 'Recovery Model', suser_sname(owner_sid) AS Owner, collation_name AS Collation, compatibility_level AS 'Compatibility level', create_date AS 'Create date' from sys.databases
miércoles, 1 de julio de 2015
Relevamiento de Bases de Datos en SQL Server
Consulta para relevamiento de Bases de Datos en SQL Server
SELECT name AS DB, state_desc AS Status, recovery_model_desc AS 'Recovery Model', suser_sname(owner_sid) AS Owner, collation_name AS Collation, compatibility_level AS 'Compatibility level', create_date AS 'Create date' from sys.databases
SELECT name AS DB, state_desc AS Status, recovery_model_desc AS 'Recovery Model', suser_sname(owner_sid) AS Owner, collation_name AS Collation, compatibility_level AS 'Compatibility level', create_date AS 'Create date' from sys.databases
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario