SELECT dtb.[name] AS [database],
CASE(dtb.is_trustworthy_on)
WHEN 0 THEN 'False'
WHEN 1 THEN 'True'
END AS [Trustworthy]
FROM master.sys.databases AS dtb;
To change database to Trustworthy:
ALTER DATABASE DatabaseName SET TRUSTWORTHY ON
GO
No comments:
Post a Comment
Note: only a member of this blog may post a comment.