Wednesday 23 February 2011

Check your Databases are set to Trustworthy

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.